Data Manager Fundamentals - SS4 - TRN016690 - 10002 - Metric

Download as pdf or txt
Download as pdf or txt
You are on page 1of 88

Bentley Data Manager

Fundamentals
V8i
Metric

Bentley Institute Course Guide

TRN016690-1/0002
Trademark Notice

Bentley and the "B" Bentley logo are either registered or unregistered trademarks or
service marks of Bentley Systems, Incorporated. All other marks are the property of their
respective owners.

AccuDraw, MDL, MicroStation, and SmartLine are registered trademarks; PopSet and
Raster Manager are trademarks.

AutoCAD is a registered trademark of Autodesk, Inc.

Copyright Notice

Copyright ©2012 Bentley Systems, Incorporated. All Rights Reserved.

Bentley Data Manager Fundamentals 2 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Table of Contents

Course Overview ____________________________________ 5


Course Description ____________________________________5
Target Audience_______________________________________5
Prerequisites _________________________________________5
Course Objectives _____________________________________5
Modules Included _____________________________________6
Installation Directories: _________________________________7
System Requirements __________________________________8
AutoCAD® or related Autodesk® Products _______________9
Document Management System Supported _____________9
CAD File Viewer Supported___________________________10
Project Review Tools Supported_______________________10
i-model Composition Supported_______________________10
Databases Supported _______________________________11
Recommended Configuration_________________________12
Installing the Training Project ____________________________12

Introduction to Data Manager _________________________ 15


Module Overview _____________________________________15
Module Prerequisites __________________________________15
Module Objectives_____________________________________15
Starting Bentley Data Manager ___________________________16
The Data Manager Interface _____________________________18
Views ____________________________________________18
Reports __________________________________________18
Macros___________________________________________18
Tables ___________________________________________18
Data Manager Toolbars _________________________________19
Project Toolbar ____________________________________19
View Toolbar ______________________________________19
Tools Toolbar______________________________________20
Applications Toolbar. _______________________________20
Logging On ___________________________________________21

Sep-12 3 Table of Contents


Copyright © 2011 Bentley Systems, Incorporated
Table of Contents

Data Manager Tags __________________________________ 25


Module Overview _____________________________________25
Module Prerequisites __________________________________25
Module Objectives_____________________________________25
AutoPLANT Tags_______________________________________26
Create an Instrument Tag _______________________________27
Create a Valve Tag _____________________________________30
Tag Data Editing_______________________________________31
Deleting a Tag ________________________________________32
Tag Information _______________________________________33

Data Manager Views _________________________________ 39


Module Overview _____________________________________39
Module Prerequisites __________________________________39
Module Objectives_____________________________________39
Data Manager Views ___________________________________40
Modifying the View Format______________________________44

Navigating Project Data ______________________________ 55


Module Overview _____________________________________55
Module Prerequisites __________________________________55
Module Objectives_____________________________________55
Search and Replace Tools _______________________________56
Database Tools________________________________________59
Define a Default View __________________________________61
Exporting and Importing Data ____________________________62

Data Manager Reports _______________________________ 67


Module Overview _____________________________________67
Module Prerequisites __________________________________67
Data Manager Reports _________________________________68
Report Creation _______________________________________69
Opening the Report ____________________________________71
Modifying the Record Source ____________________________72
Adding Graphics_______________________________________74
Adding Text and Labels _________________________________77
Previewing Report Changes______________________________81
Modifying the Format __________________________________82

Data Manager Assessment ____________________________ 85


Questions ________________________________________85
Answers __________________________________________87

Sep-12 4 Table of Contents


Copyright © 2011 Bentley Systems, Incorporated
Course Overview

Course Description
Bentley Data Manager is a powerful relational database management tool for
storing, creating, and customizing project instrumentation, equipment, piping,
and valve data. Bentley Data Manager is the ideal tool for plant engineering,
maintenance, and operation departments.

Bentley Data Manager provides quick and easy access to the Bentley project data
and provides quick, easily-modified reports in a standard format.

Target Audience
This course is designed for engineers, designers, and drafters who are using the
AutoPLANT software and will need to access the data within their projects.

Prerequisites
The student needs to have a working knowledge and at least six months
experience using either AutoPLANT or Microstation.

Course Objectives
After completing this course, you will be able to:
• Log in to Data Manager and use the Data Manager interface.
• Create, edit, and delete tags, and view a tag's properties.
• Sort and filter data displayed in a Data Manager view.

Sep-12 5 Course Overview

Copyright © 2012 Bentley Systems, Incorporated


Modules Included

• Modify the view format, create a new view, and change the default view.
• Use the Search and Replace tools and the Database tools.
• Import or export data into or out of Data Manager.
• Open, review, create, and modify Data Manager reports.

Modules Included
The following modules are included in this course:
• Introduction to Data Manager
• Data Manager Tags
• Data Manager Views
• Navigating through Project Data
• Data Manager Reports

Course Overview 6 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Installation Directories:

Installation Directories:
For AutoPLANT (SELECTseries 4) there are differences in the installation
directories for Windows XP, Windows 7 or Windows Server 2008. The following
tables provide the paths to the software files.

Directory Structure for Windows XP:

Network_Root: \\Program Files\Bentley\Plant V8i

Local_Root: \\Documents and Settings\All


Users\Application Data\Bentley\Plant V8i

Default Projects Root: \\Bentley Plant V8i Projects\

Note: Whenever Network_Root/Local_Root/Project_Root are mentioned in the


document, it refers to the above paths.

Directory Structure for Windows 7 (32 bit):

Network_Root: \\Program Files\Bentley\Plant V8i

Local_Root: \\ProgramData\Bentley\Plant V8i

Default Projects Root: \\ProgramData\Bentley\Plant V8i\Bentley Plant


V8i Projects\

Note: Whenever Network_Root/Local_Root/Project_Root are mentioned in the


document, it refers to the above paths.

Directory Structure for Windows 7 (64 bit) or Windows


Server 2008:

Network_Root: C:\Program Files(X86)\Bentley\Plant V8i

Local_Root: C:\ProgramData\Bentley\Plant V8i

Default Projects Root: C:\ProgramData\Bentley\Plant V8i\Bentley


Plant V8i Projects\

Sep-12 7 Course Overview


Copyright © 2012 Bentley Systems, Incorporated
System Requirements

System Requirements
You must have a CD drive or internet access for product installation. The following
prerequisites are required to run the modules included in the AutoPLANT Plant
Design V8i or AutoPLANT Plant Design V8i x 64 (Version 08.11.09.140) or
AutoPLANT P&ID V8i or AutoPLANT P&ID V8i x 64 (Version 08.11.09.140) or
Bentley Process and Instrumentation V8i or Bentley Process and Instrumentation
V8i x 64 (Version 08.11.09.140).

Processor: Intel Pentium 4 processor or AMD Athlon, 3.0


GHz or greater
Intel or AMD Dual Core processor, 2.0 GHz or
greater

Operating System: Windows XP Professional (32 bit) SP3 or later


Windows 7 (32 Bit)
Windows 7 (64 bit)

Internet: Microsoft Internet Explorer 6.0 or later

Memory: 2GB or greater for Windows XP 32-bit


environments
4GB or greater for Window 7 32-bit
environments
8GB or greater for Window 7 64-bit
environments

Hard Disk: 2GB free hard disk space

Input Device: Industry-standard input device supported by


Windows

Output Device: Industry-standard output device supported by


Windows

.NET Framework Microsoft .NET 1.1 SP1 is required as a


minimum requirement to install AutoPLANT
PDW
For Windows Vista and Windows 7 run
Windows Update to ensure that the latest
version of .NET Framework is installed

Video Graphics Card: 512 MB (minimum), 1GB (recommended),


OpenGL, or Direct3D capable workstation class
graphics card
For Windows 7, DirectX 9 graphics device with
WDDM 1.0 or higher driver

Course Overview 8 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
System Requirements

Network Environment: For project hosting only. AutoPLANT software is


not installed on a server.
Windows Server 2003
Windows Server 2008, SP2
Windows Server 2008 R2

Microsoft Office: Microsoft Office 2007 SP2


Microsoft Office 2010
Notes:
• Microsoft Office is required for Project
Administrator, Data Manager, Datasheets,
SpecGen editing & outputs, Piping & Equipment
reports.
• Microsoft Office is not required for 3D Modeling

AutoCAD® or related Autodesk® Products

AutoCAD: 2012 - (32-bit and 64-bit)

AutoCAD Architectural: 2012 - (32-bit and 64-bit)

AutoCAD MEP: 2012- (32-bit and 64-bit)

Note: The latest applicable service packs must be used for all of the above products.

Document Management System Supported

Bentley ProjectWise: V8i (SELECTseries 3)


V8i (SELECTseries 4)
Notes:
• ProjectWise V8i (SELECTseries 4) or
(SELECTseries 3) server can be used with
AutoPLANT (SELECTseries 4). However, only
ProjectWise V8i (SELECTseries 4) client is
supported with AutoPLANT V8i (SELECTseries 4).

Sep-12 9 Course Overview


Copyright © 2012 Bentley Systems, Incorporated
System Requirements

CAD File Viewer Supported

Bentley View: V8i (SELECTseries 2)


Notes:
• Bentley View is required to view 3D documents
in the Relationship Manager and the 2D to 3D
Consistency Reporter.
• Bentley View can also be installed as the default
CAD file viewer for Bentley® Vision.
• Bentley View is not required for 3D modeling.
• See Known Issues regarding DWG 2010 files and
Bentley® View V8i (SELECTseries 2).

Project Review Tools Supported

Bentley ProjectWise Navigator: V8i (SELECTseries 3)


V8i (SELECTseries 4)
Notes:
• See Known Issues regarding DWG 2010 files and
Bentley® Navigator V8i (SELECTseries 3) &
(SELECTseries 4).

Bentley Navigator: V8i (SELECTseries 3)


V8i (SELECTseries 4)

i-model Composition Supported

Bentley ProjectWise i-model V8i (SELECTseries 3)


Composer: V8i (SELECTseries 4)
Notes:
• See Known Issues regarding DWG 2010 files and
Bentley® i-model Composer V8i (SELECTseries 3)
& (SELECTseries 4).
• See Known Issues for Bentley® i-model
Composer Installation Order.

Course Overview 10 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
System Requirements

Databases Supported

Microsoft Access 2010*

Microsoft SQL Server Microsoft® SQL Server 2008 Express Edition


Microsoft® SQL Server 2008 Standard Edition
Microsoft® SQL Server 2008 Enterprise Edition
Plus SP1 for ProjectWise integration
Microsoft® SQL Server 2008 R2 Express Edition
Microsoft® SQL Server 2008 R2 Standard
Edition
Microsoft® SQL Server 2008 R2 Enterprise
Edition

Oracle ORACLE® 11g Release 1 (v11.1.0.6)


ORACLE® 11g Release 1 (v11.1.0.7)
ORACLE® 11g Release 2 (v11.2.0.1)
ORACLE® 11g Release 2 (v11.2.0.3)

Note: The Bentley I&W applications are only supported on a Microsoft Access
database in a single user, non-networked environment. For a multi-user, server
based project environment, SQL Server or ORACLE® must be deployed.

Note: Please see Known Issues section of this ReadMe for more information
regarding the deployment of Bentley I&W with ORACLE in a 64-bit environment.

Note: Note: Please see Known Issues section of this ReadMe for more information
regarding the deployment of ORACLE 11.2.0.3 in both 32-bit and 64-bit
environment.

Sep-12 11 Course Overview


Copyright © 2012 Bentley Systems, Incorporated
Installing the Training Project

Recommended Configuration
Windows 7 Enterprise (64-bit), or Ultimate (64-bit) with:
• Intel® Core™ i7 Extreme, or Intel® Xeon® 5600 processor
• AMD Phenom ™, or AMD Phenom™ II processor
• 8 GB RAM (minimum)
• 1 GB Microsoft Direct3Dcapable workstation-class graphics card
• 2 GB (minimum) available disk space
• AutoCAD 2012 (64-bit)
• Microsoft Office 2010 Professional (64-bit)
• Microsoft SQL Server 2008 R2

Installing the Training Project


Note: If you are taking the AutoPLANT P&ID Design course, you do not need to install
the dataset.

Prior to creating a project P&ID, a project must be created. A project has been
provided for your convenience. You will need to unzip this project onto the drive
of your choice. The exercise below installs the project onto the C:\ drive.

 Exercise 1: Installing the Training Project.


1 Make sure all AutoPLANT applications are closed.
2 Download the file Data Manager Fundamentals_SS4_TRN016690-
10002_Dataset.zip.
3 Save the file to your desktop.
4 Double-click on the file AP_FV8i_DM_M.exe.
5 Click Unzip to begin the extraction to the root directory of the C drive
(C:\).
6 Click Close.
7 From your Windows Start menu, select Programs > Bentley > Plant V8i >
Project Tools > Project Administrator.
8 Select File > Add Root.

Course Overview 12 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Installing the Training Project

The Browse for Folder dialog opens.

Note: You cannot create a project root directory under a project directory.
Therefore, in order for this option to be available in the File menu, you
must select something at the primary root level of the navigation tree.
9 Select C:\Bentley Training Project.
10 Click OK.

Note: The project root folder, C:\ Bentley Training Project, now appears in the
navigation tree at a primary level.

Additional training on the Project Administrator utility is covered in the


AutoPLANT Administrator training courses.

Sep-12 13 Course Overview


Copyright © 2012 Bentley Systems, Incorporated
Installing the Training Project

Course Overview 14 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Installing the Training Project

Sep-12 15 Course Overview


Copyright © 2012 Bentley Systems, Incorporated
Installing the Training Project

Course Overview 16 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Introduction to Data Manager

Module Overview
This module will introduce you to the Data Manager application. You will be
guided through Data Manager and become familiar with the interface. You will
then learn about Data Manager's security feature by changing the login and
logging in as a guest.

Module Prerequisites
• Six months experience with AutoCAD or Microstation.
• Familiarity with Microsoft Access.

Module Objectives
After completing this module, you will be able to:
• Open a project using Data Manager.
• Use the Data Manager interface.
• Change login name to increase or decrease permissions within Data Manager.

Sep-12 15 Introduction to Data Manager

Copyright © 2012 Bentley Systems, Incorporated


Starting Bentley Data Manager

Starting Bentley Data Manager


In this module, you will open a project using Bentley Data Manager and you will
be introduced to the Data Manager interface.

 Exercise 1: Opening a project with Data Manager


1 Select Programs > Bentley > Plant V8i > Data Manager from your
Windows Start menu.
2 If the Login dialog does not display, select Open Project.
3 Select Bentley Training Project.
4 Select Metric Training.
5 Click OK.
The Login dialog displays.

Note: If you previously logged into another application and set the Save
Password check box, you will not see the Login dialog. You can access
this dialog by selecting File > Log on as a Different User.

Note: Users or groups are granted access to individual projects by your System
Administrator. Bentley Data Manager defaults to logging in with
supervisor privileges by populating the Login Name field with
Supervisor.
6 Click OK.

Introduction to Data Manager 16 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Starting Bentley Data Manager

The Bentley Data Manager environment displays.

Sep-12 17 Introduction to Data Manager


Copyright © 2012 Bentley Systems, Incorporated
The Data Manager Interface

The Data Manager Interface


This module introduces the main features of the Bentley Data Manager interface.
The Project Window appears in the left pane of Bentley Data Manager and
displays the available project items. The right pane of Bentley Data Manager
displays the project objects selected from the Project Window pane. It is possible
to display many objects in the pane and to display them simultaneously. In this
training course, you will learn how to display and modify the views in this pane.

Views
The views are the main data retrieval and data entry point for project data.
They are how Bentley Data Manager displays the project data to the user.
Views may be modified by delegated project users. As part of this training
course, you will learn how to use views to display and edit data. You will also
learn how to modify a project view to display additional data.

Note: The PID-based views commonly recognized by the AT_ prefix are no
longer a part of the Data Manager application and can be found in the
Project Administrator tool.

Reports
Reports are Microsoft Access reports, which allow project data to be
displayed or published to paper or electronic format. Reports may be
modified by delegated project users. In this course, you will learn how to
display and modify reports.

Macros
The Microsoft Access macro facility provides a way of automating Bentley
Data Manager tasks. This feature will not be covered in this course.

Tables
Tables provide access to the underlying project tables. Generally, this access
should be restricted, and project tables should be hidden from user access to
safeguard project data. Modifications of the tables will not be covered in this
course.

Introduction to Data Manager 18 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Data Manager Toolbars

Data Manager Toolbars


Data Manager provides four toolbars for quick access to the most commonly-
used application options. The toolbars are permanently docked at the top of the
Data Manager window.

To view the name of the command that will be executed by any toolbar button,
position the cursor over an item and pause. A "tool tip" will display describing
that item.

The following provides a quick reference to the icons available.

Project Toolbar
Toolbar Icon Description
Open Project Displays the Open Project dialog, which enables you to
locate and open an existing project

View Toolbar
Toolbar Icon Description
Equipment List Displays the Equipment List view, which shows the
database details for all equipment defined in the current
project. From this view, you can create new equipment
or edit existing equipment details, filter and sort data,
and modify data using a powerful search and replace
engine.
Motor List Displays the Motor List view, which shows the database
details for all motors defined in the current project.
From this view, you can create new motors or edit
existing motor details, filter and sort data, and modify
data using a powerful search and replace engine.
Instrument List Displays the Instrument List view, which shows all of the
instruments defined in the current project. From this
view, you can create new loops, edit existing loops, or
edit individual instruments on a field-by-field basis, filter
and sort data, and modify data using a powerful search
and replace engine.
Refresh Immediately updates displayed information with current
data

Sep-12 19 Introduction to Data Manager


Copyright © 2012 Bentley Systems, Incorporated
Data Manager Toolbars

Project Window Opens, creates, or modifies database tables, database


views, reports, and macros
Properties Window Launches the Property Sheet dialog, which enables you
to view and edit database information specific to the
current tag, such as tag number, loop number, service,
description, manufacturer, and model

Tools Toolbar
Toolbar Icon Description
New Tag Creates a new tag number within the current view

Edit Tag Edits an existing tag number in the current view

Delete Tag Deletes an existing tag number from the current view

Tag Information Displays information specific to the current tag, such as


tag number, loop number, service, description,
manufacturer, and model
Find Tag Locates a specific tag in the current view

Publish to ProjectWise Allows the user to publish to ProjectWise if enabled for


the project. The icon will be greyed out if ProjectWise is
not enabled.

Applications Toolbar.
Toolbar Icon Description
Data Sheet Editor Launches the Datasheets module

Hookup Editor Launches the Hookups module

PID Launches the AutoPLANT PID application

Introduction to Data Manager 20 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Logging On

Logging On
Bentley provides for different levels of security that can be applied to both
project data and application tasks. While you are not provided details on how
to implement the security, you are introduced to the security within Data
Manager. Security within Data Manager can be applied to either user or
group level, with Bentley recommending a user-level implementation. The
first tasks should be to change the Supervisor password and to set up users.
During this course, you will learn some of the restrictions that are
implemented as standard.

 Exercise 1: Log On as a Different User


1 Select File > Log on as a Different User.
2 Type ChiefEng in the Login Name field.
3 Leave the Password field blank.

4 Click OK.

Note: Every time a Bentley application is opened, the Login dialog will appear.
If you do not wish to keep clicking OK or entering your password, you
can set the Save Password check box, which will prevent the dialog
from appearing until the Logon as a Different User option is selected.
The Login dialog disappears and Data Manager is displayed. As ChiefEng,
you have the right to modify project data.
5 Select View > Process Instrument List.
6 Select Tools > New Tag.
The Select Type dialog opens.
7 Select AT_INST_.
8 Click OK.

Sep-12 21 Introduction to Data Manager


Copyright © 2012 Bentley Systems, Incorporated
Logging On

The Tag Number dialog opens to allow you to create a new tag.

9 Click Cancel.
The dialog closes.

 Exercise 2: Login to Data Manager as a Guest


When you log in as a guest, you can look at project data, but you will not be
able to create a new tag. In this exercise, you will log in as a guest to look at
project data.
1 Select File > Log on as a Different User.
2 Type Guest in the Login Name field.
3 Leave the Password field blank.

4 Click OK.
The Login dialog disappears and Data Manager is displayed.
5 Select the Process Instrument List.
Note the entire view is grey.
6 Select Tools > New Tag.

Introduction to Data Manager 22 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Logging On

Note: When you log in as a Guest, you do not have permission to add a new
instrument.

7 Click OK.
To close the New Tag dialog.
8 Select File > Log on as a Different User.
9 Type Supervisor in the Login Name field.
10 Type Supervisor in the Password field.
11 Click OK.

Sep-12 23 Introduction to Data Manager


Copyright © 2012 Bentley Systems, Incorporated
Logging On

Introduction to Data Manager 24 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Data Manager Tags

Module Overview
In this module, you will learn the importance of the tagging system within Bentley
applications. You will learn to create several types of component tags, to edit and
delete tags, and to view a tag's properties.

Module Prerequisites
• Familiarity with the Data Manager Interface.
• Using the AutoPLANT tagging system.

Module Objectives
After completing this module, you will be able to:
• Create new tags.
• Edit a tag number.
• Delete tags.
• Modify tag data via the tag information dialog.
• Modify multiple tag data via the tag information dialog.

Sep-12 25 Data Manager Tags

Copyright © 2012 Bentley Systems, Incorporated


AutoPLANT Tags

AutoPLANT Tags
A tag is a generic reference to a physical item in the plant, such as a valve,
instrument, pump, vessel, etc. Each of these items is assigned a tag.

Tags are grouped by type, and each tag type is stored with a tag code in a specific
location to assist the project implementation. AutoPLANT is very flexible in the
handling of tag types and is easily customized.

Every AutoPLANT application works with the same tagged items in the project
database, and each allows the creation, modification, and deletion of tags.
AutoPLANT does not enforce a working method on users and aims to provide a
flexible toolset for all projects. The project managers should decide upon the
tools their users will use to create tags within an AutoPLANT project.

For the purposes of this training manual, it should be pointed out that while
pumps and vessels can be created with AutoPLANT Data Manager, nozzle tags
cannot be created with an association to the pumps or vessels. The association
can only be created using AutoPLANT P&ID.

Data Manager Tags 26 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Create an Instrument Tag

Create an Instrument Tag


 Exercise 1: Creating an Instrument Tag
In this exercise, you will create an instrument tag and learn the relationship
between the tag and its corresponding view.
1 Select View > Process Instrument List.

2 Select Tools > New Tag.

Note: AutoPLANT displays the Select Type dialog because the Process
Instrument List view displays multiple tag types.
3 Select AT_INST_.

Sep-12 27 Data Manager Tags


Copyright © 2012 Bentley Systems, Incorporated
Create an Instrument Tag

4 Click OK.

5 Type 100-FT-100 in the Tag Number field.


6 Click OK.

Note: The New Tag dialog is closed and the Process Instrument List displays.
Note how the tag number is split into component fields. This is a
feature of the tag type and can be used to assist searches and sort
orders.

 Exercise 2: Create Instrument 100-FI-100


1 Click on the 100-FT-100 record.
2 Select New Tag.
3 Select AT_INST_.
4 Click OK.

Data Manager Tags 28 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Create an Instrument Tag

5 Select FI from the Typ list.

Note: Clicking Next will add one to the current value in the Num field. Clicking
Max will return the maximum number for the Num field for the current
Typ field.
6 Click OK.
The Process Instrument List is updated with the new instrument.
By separating the tags into the different tag types, reports and views can be
customized to be tag specific. For example, a user could build a report to
contain only Control Valves.

 Exercise 3: Create Tags for Multiple Tag Types


1 Select New Tag.
2 Select AT_INST_ CS from the Select Type dialog.
3 Click OK.
4 Type 100-CS-100 in the Tag Number field.
5 Click OK.
Create the following tags with the appropriate tag type by repeating the
previous exercise. Remember to change the tag format if there is a suffix
in the tag number.

Tag Type Tag Number


AT_INST_FLO 100-FE-100
AT_CVALVE 100-FCV-100
AT_INST_MCC 100-XR-100A

Sep-12 29 Data Manager Tags


Copyright © 2012 Bentley Systems, Incorporated
Create a Valve Tag

You have now created some instrument tags in the project database
which are available to all project personnel and visible to all applications
across the project. These instruments can either be inserted into a P&ID
or a 3D MODEL, connected to junction boxes using Instrumentation and
Wiring, and/or be allocated to Datasheets and Hookups.

Create a Valve Tag


In the previous exercise, you created instrument tags, and the corresponding
view was available from the menu or Project Window. The Valve List is a standard
view which is only available from the Project Window.

 Exercise 1: Displaying the Valve View


1 Expand the Views node.
2 Double-click on Valve List.

 Exercise 2: Creating the Valve Tag


1 Select New Tag.

Note: Within the Status group box, the tag type has changed to Hand Valve.
2 Type BA-100 in the Tag Number field.
3 Click OK.
The valve list is updated with the new tag number.

Data Manager Tags 30 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Tag Data Editing

Note: There is no TYP field on the dialog because the tag format does not
contain TYP.
4 Repeat this exercise to create valve tags GA-100 and GA-200.

Tag Data Editing


Tag data editing relates to the tag properties. To ensure tag formats are
observed, the editing of tags is carried out in a controlled environment.

 Exercise 1: Editing a Tag


1 Select GA-200.
2 Select Tools > Edit Tag.

Note: The Edit Tag dialog is exactly the same as the New Tag dialog.
3 Type GA-100 in the Tag Number field.
4 Click OK.
The Bentley DataBase Message dialog is displayed, indicating that the tag
number already exists.
5 Click OK.
6 Type CHK-100 in the Tag Number field.
7 Click OK.
The valve number is updated in the Valve List.

Sep-12 31 Data Manager Tags


Copyright © 2012 Bentley Systems, Incorporated
Deleting a Tag

Deleting a Tag
By default, tags that are deleted are removed from the project database. Your
project administrator can set the project properties to prevent tags from being
deleted from the database.

 Exercise 1: Deleting a Tag


1 Select GA-100.
2 Select Tools > Delete Tag.

3 Click Yes.
The valve is deleted and is removed from the Valve List and the project.
4 Select PID-01-H-11.
5 Select Tools > Delete Tag.

Because the valve has links to project documents it cannot be deleted from
the Valve list.
6 Click Ok.

Data Manager Tags 32 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Tag Information

Tag Information
Tag information refers to the project data that is stored with each tag. This can be
updated by project users. The properties that are displayed for a tag are
particular to the tag type and to the current view. This makes it possible for views
to be created which display only the relevant information for a specific task.

In the previous exercises, we have seen that instruments and valves can have
different formats. You will now see that instruments and valves can have
different data stored with them, and also that similar tag formats such as
instruments and control valves can have different data stored with them. In fact,
the project can define what data can be stored with a tag. If an item needs to be
handled differently than another item, a new tag type will need to be defined.

 Exercise 1: Review the Instrument List and Valve List Views


1 Open both the Instrument List and the Valve List views.
2 Select Window > Arrange All.

3 Scroll to the top of the Valve List.


4 Place your cursor in the record for valve BA-100.

Sep-12 33 Data Manager Tags


Copyright © 2012 Bentley Systems, Incorporated
Tag Information

5 Type 760 kPa in the OP PRESS field.

6 Click on the view to activate the Process Instrument List.


7 Select the instrument 100-FT-100.
8 Type Flow Transmitter into the DESCRIPTION field.

Data Manager Tags 34 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Tag Information

 Exercise 2: Enter Data Using the Tag Information Dialog


Data can be entered directly into the view screens (as long as you have
sufficient security rights), or it can be entered via modifiable data entry
screens.
1 Close the Valve List.
2 Maximize the Process Instrument List.
3 Select 100-FT-100.
4 Select Tools > Tag Properties.

5 Type Honeywell in the Manufacturer field.


6 Type HWF802 in the Model Number field.
7 Click OK.

Sep-12 35 Data Manager Tags


Copyright © 2012 Bentley Systems, Incorporated
Tag Information

The Process Instrument List opens.

 Exercise 3: Update Multiple Instruments

Data Manager has many ways of entering information. Like the Windows
standard Cut, Copy and Paste, Bentley allows data to be entered against many
tags simultaneously.
1 Select 100-TT-100.
2 Select View > Properties Window.

3 Close the dialog.


4 Select 100-TT-200 by holding down the SHIFT key.

Data Manager Tags 36 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Tag Information

The Tag Number field in the Property Sheet turns to ** when all of the
instruments are selected.

5 Type Honeywell in the MANUFACTURER field.


6 Type HWF801 in the MODEL NO field.
7 Press Enter.
8 Close the dialog.
Notice that both instruments are updated.

Sep-12 37 Data Manager Tags


Copyright © 2012 Bentley Systems, Incorporated
Tag Information

Data Manager Tags 38 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Data Manager Views

Module Overview
In this module, you will learn to sort and filter data displayed in a Data Manager
view and modify the view format. You will also learn to create a new view.

Module Prerequisites
• Familiarity with the Data Manager interface.
• Adding, editing, and deleting tags.

Module Objectives
After completing this module, you will be able to:
• Manipulate a view.
• Modify a view.
• Lock a column.
• Highlight columns.
• Make a column read-only.
• Create a new view.

Sep-12 39 Data Manager Views

Copyright © 2012 Bentley Systems, Incorporated


Data Manager Views

Data Manager Views


A Data Manager view is a representation of the data stored in the relational
database tables for Bentley tags. There are very few restrictions on the data that
can be displayed in a view, and views can be created and edited very easily with
Bentley Data Manager.

The Entity-Relationship ("ER") diagram named Bentley Plant 08.11.05.xx ERD.PDF


is found in \BENTLEY\PLANT V8i\HELP. This diagram shows the tables created by
default for each project, as well as the main relationships between the tables in a
project.

 Exercise 1: Sorting Data Displayed in a View


1 Launch Data Manager.
2 Select View > Instrument List.
3 Select the ITYP field for any record.
4 Right-click on the ITYP field.
The context-sensitive menu opens.

5 Select Sort > Sort Descending.

Data Manager Views 40 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Data Manager Views

Process Instrument List is sorted by ITYP.

Note: Any field can be used to sort the current view, but the field must be
selected before using the sort option. Generally, when the view is
created, the sort order is decided. A user can override the sort order by
using the sort option.

 Exercise 2: Filter Data Displayed in a View


1 Ensure that the Process Instrument List is the current view.
2 Select the ITYP field of the instrument 100-FT-100.

Sep-12 41 Data Manager Views


Copyright © 2012 Bentley Systems, Incorporated
Data Manager Views

3 Select Tools > Filter > Quick Filter.

Note: Only the FT records are displayed. The application window title is
updated to display the filter. A quick filter uses the whole contents of
the current field to filter the records.
4 Select Filter > Count Filtered Rows from the context menu.

5 Click OK.

 Exercise 3: Clear the Current Filter


1 Right-click on the ITYP field.
2 Select Filter > Clear Filter from the context menu.
The filter is removed and all of the records are displayed.

 Exercise 4: Create a Filter to Find the HWF801 Instruments

Data Manager Views 42 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Data Manager Views

1 Select Tools > Filter > Build Filter …

2 Select MODEL NO from the Field list.


3 Select HWF801 from the Value list.
The Filter Expression will be MODEL NO ='HWF801'.

4 Click Test.

5 Click OK.
6 Click Help.
The Data Manager help displays for this particular dialog.
7 Close the Help screen.
The Filter Builder dialog is still active.
8 Click OK.
The filtered records are displayed, and the application window title is
updated to display the current filter.
9 Select Tools > Filter > Clear Filter.
The filter is removed and all of the records are displayed.

Sep-12 43 Data Manager Views


Copyright © 2012 Bentley Systems, Incorporated
Modifying the View Format

Modifying the View Format


Bentley Data Manager is a modifiable application which allows data to be
displayed and edited to meet user requirements. In these exercises, you will
modify the views by locking columns, highlighting columns, and setting columns
to be read-only.

 Exercise 1: Modify the Process Instrument List


1 Place your cursor between the STATUS and AREA headings.
The cursor changes to the resize icon.
2 Slide the AREA column to the left to hide the STATUS column.
The STATUS column is no longer displayed, but it can be resized by
carefully moving between the edge of the view and the AREA column.

Data Manager Views 44 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Modifying the View Format

 Exercise 2: Lock the Tag Number Column


1 Hover the cursor between the record selector column and the KEYTAG
column.
The cursor changes to the Lock Column icon.
2 Drag Lock to the right of the TAG NO column.
3 Scroll the Process Instrument List view to the right.
The TAG NO column does not scroll.

Sep-12 45 Data Manager Views


Copyright © 2012 Bentley Systems, Incorporated
Modifying the View Format

 Exercise 3: Highlighting Columns


1 In the Project Window, select the Process Instrument List view.

2 Right-click and select Edit.

Data Manager Views 46 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Modifying the View Format

3 Click Design.

4 Select MANUFACTURER from Selected Fields.


The Field field changes to MANUFACTR.
5 Select Browse in the Color field.

6 Select a blue color and click OK.

Sep-12 47 Data Manager Views


Copyright © 2012 Bentley Systems, Incorporated
Modifying the View Format

The word MANUFACTURER in the Color field will show as blue.

7 Select MODEL NO from Selected Fields.


The Field field changes to MODEL NO.
8 Select Browse in the Color field.
The Color dialog appears.
9 Select a blue color and click OK.
10 Click OK.
The Design View dialog closes.
11 Re-open the Process Instrument List view.

Data Manager Views 48 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Modifying the View Format

The MANUFACTURER and MODEL NO fields are now shown with blue text.

 Exercise 4: Setting Fields to be Read Only


1 Right-click on the Process Instrument List in the Project Window.
2 Select Edit.
3 Click Design.
4 Select DATASHEET NO from Selected Fields.
5 Set the Read Only check box.

Sep-12 49 Data Manager Views


Copyright © 2012 Bentley Systems, Incorporated
Modifying the View Format

6 Select HOOKUP NO from Selected Fields.


7 Set the Read Only check box.
8 Click OK.
The Design View closes.
9 Open the Process Instrument List.
The DATASHEET NO and HOOKUP NO fields are now grey, which indicates
read only. These fields can no longer be edited.

Data Manager Views 50 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Modifying the View Format

 Exercise 5: Create a New View


1 Highlight the Process Instrument List in the Project Window.
2 Right-click and select New.

3 Set the From current View Process Instrument List radio button.
4 Click OK.

5 Type My Instrument List in the Name field.


6 Type FT Instrument List in the Description field.
7 Set the Short List check box.
8 Click Design.
The Design View dialog displays.
9 Click Design with Access.

Sep-12 51 Data Manager Views


Copyright © 2012 Bentley Systems, Incorporated
Modifying the View Format

Microsoft Access is loaded with the view displayed in the query builder.

Note: Bentley Data Manager uses Microsoft Access to design queries and
reports. This provides an established interface and allows queries and
reports from user applications to be easily migrated.
10 Select the Criteria cell for the ITYP field.
11 Type "FT" in the Criteria cell.

12 Close the Access Query Design View window.

Data Manager Views 52 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Modifying the View Format

A prompt is displayed to save the changes.


13 Click Yes.
The Design View - My Instrument List dialog displays.
14 Select CALIBRATN from the Fields: field.
15 Double-click CALIBRATN.
The CALIBRATN field is added to the bottom of the Selected Fields list.
16 Highlight CALIBRATN and click the Field Position arrow.
17 Move the CALIBRATN field next to the MODEL NO field.
18 Click OK.
The Design View dialog closes; My Instrument List is available in the
Project Window.
19 Set the Short List check box on the Project Window.
The Project Window closes all of the nodes.
20 Expand the Views node.
21 Open My Instrument List.
Only the flow transmitters display in your new view.

Sep-12 53 Data Manager Views


Copyright © 2012 Bentley Systems, Incorporated
Modifying the View Format

Data Manager Views 54 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Navigating Project Data

Module Overview
In this module you will learn to use the Search and Replace tools and the
Database tools. You will learn how to change your default view and how to
import or export data into or out of Data Manager.

Module Prerequisites
• Familiarity with Data Manager's interface.
• Adding, editing and deleting tags in Data Manager.

Module Objectives
After completing this module, you will be able to:
• Find and replace project data.
• Use the database tools.
• Define a default view.
• Import and export data.

Sep-12 55 Navigating Project Data

Copyright © 2012 Bentley Systems, Incorporated


Search and Replace Tools

Search and Replace Tools


Like Windows applications, Bentley Data Manager allows project tags to be found
quickly using the standard search and replace functionality.

 Exercise 1: Finding a Project Tag


1 Open the Process Instrument List.
2 Select Tools > Find > Find Tag.

3 Type *LG* in the Tag Numbers that Contain field.


The Tag Numbers window reduces to only the tags which match the
required pattern.
4 Select 199-LG-100.
5 Click OK.

Navigating Project Data 56 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Search and Replace Tools

The record selector is moved to the record for 100-LG-100.

 Exercise 2: Finding Project Data


In this exercise, you will use the Bentley Data Manager’s standard Find tool to
search for data.
1 Select the MANUFACTURER field.
2 Select Tools > Find > Quick Find.

3 Type Honeywell in the Find What field.


4 Click Find Next.
The record selector is moved to the tag and the Find in Field dialog
remains open.
5 Click Close.
The Find in Field dialog closes; the Process Instrument List view is open.

Sep-12 57 Navigating Project Data


Copyright © 2012 Bentley Systems, Incorporated
Search and Replace Tools

 Exercise 3: Search and Replace Tools


1 Select the MANUFACTURER field.
2 Right-click and select Replace…

3 Type Honeywell in the Find What field.


4 Type Rosemont into the Replace With field.
5 Set Match Case and Match Whole Field.
6 Clear Current Field Only.
7 Click Replace All.

8 Click OK.
9 Click Close.

Warning: There is no UNDO feature, so you should always be careful that the Find
What and Replace With values are exactly what you want. There is no
warning with the Replace command, and it is possible to alter many
project records using it.

Navigating Project Data 58 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Database Tools

Database Tools
Bentley Data Manager is a database-based system, and as such requires a limited
amount of housekeeping.

Warning: For SQL Server and Oracle based projects, this should be carried out by a
qualified DBA (Database Administrator) who is responsible for the server
and data. For other types of projects, a standard toolkit is sufficient for
most scenarios.

Compact Database

To provide efficient access to data, database engines do not compact deleted or


modified data and objects. This is considered to be a manual task which should be
carried out on a regular basis, especially after changes have been made to reports
or views. This task is straightforward and must be run when there are no other
users using the project database.

Check All Database Objects And Update If Necessary

This command is used to synchronize your version of the report or view with the
master copy. Due to the multi-user nature of databases, it may be possible that
another user has updated the design of a report or view that you are using. This
task is only required if you have been working on the project for a long time and
you are aware that there have been changes to a report. This task is not
necessary if you open and close Bentley Data Manager at regular intervals (for
breaks or work procedures).

Check for Duplicate Tag Numbers

This feature will allow the project database to be checked against the tag type
rules. If Bentley applications are used exclusively to create tags, this option
should never be required. Bentley provides functionality to create tags through
other methods.

Check and Update Link Tables

This feature will check and update the link tables if any modifications are done.

Sep-12 59 Navigating Project Data


Copyright © 2012 Bentley Systems, Incorporated
Database Tools

 Exercise 1: Compact the Project Database


1 Select Tools > Database Tools.

2 Select Compact Database.


3 Click OK.
The Compact Database - Warning dialog opens.
4 Click Yes.
5 Click OK.
The database is compacted, and a message confirms the action.

6 Click OK.

Navigating Project Data 60 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Define a Default View

Define a Default View


In this exercise, you will learn to make the newly-created My Instrument List the
default view that opens when Data Manager is opened.

 Exercise 1: Define Default Views


1 Select Tools > Options.
2 Select My Instrument List from the View list.

3 Click OK.
The Options dialog closes.
4 Select File > Exit.
5 Re-open Bentley Data Manager.
My Instrument List displays in the right-hand panel.

Sep-12 61 Navigating Project Data


Copyright © 2012 Bentley Systems, Incorporated
Exporting and Importing Data

Exporting and Importing Data


Bentley Data Manager allows for the transfer in and out of project data and
provides tools to export project data, for 3rd party review or data entry. Bentley
recognizes that although Bentley Data Manager is a versatile tool for the
manipulation of project data, users may have preferred or predefined methods of
creating project data.

By default, Bentley Data Manager assumes that an export will NOT be re-
imported to the project. However, this course will cover the ability to modify the
export so the data can be re-imported back into the Bentley project.

 Exercise 1: Export Data


1 Close My Instrument List.
2 Open Valve List.
3 Select File > Export …

4 Set the Access, Excel radio button.


5 Click OK.
The Export file dialog is displayed.
6 Browse to C:\Bentley Practice Projects\Metric Training.
7 Type ValveList.xls in the File Name field.

Navigating Project Data 62 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Exporting and Importing Data

8 Click Save.

9 Set the View radio button.


10 Select Valve List from the list.
11 Click OK.

12 Click OK.
13 Close Data Manager.
14 Open Windows Explorer.
15 Browse to C:\Bentley Practice Projects\Metric Training.
16 Double-click on ValveList.xls.

Sep-12 63 Navigating Project Data


Copyright © 2012 Bentley Systems, Incorporated
Exporting and Importing Data

The data is exported along with all of the fields for the Valve List view.

The exported spreadsheet (or database, text file etc) can be used by third-
party applications or for review by project users without Bentley access.

Navigating Project Data 64 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Exporting and Importing Data

 Exercise 2: Import a Modified Spreadsheet into Data Manager


1 Type values into the CLASS and MATERIAL columns.

2 Select File > Save.


3 Select File > Exit.
4 Open Bentley Data Manager.
5 Select File >Import > Tagged Data.
6 Set the Access, Excel radio button.
7 Click OK.
The Import dialog displays.
8 Select ValveList.xls.
9 Click Open.

Note: Just it was possible to export to multiple tables in a single workbook, it


is also possible to import from multiple tables in a single workbook.
10 Select VALVELIST.

Sep-12 65 Navigating Project Data


Copyright © 2012 Bentley Systems, Incorporated
Exporting and Importing Data

11 Click OK.

12 Click OK.
The Import message will indicate the success of the action.
13 Click OK.
14 Refresh the Valve List view to see the imported data.

Navigating Project Data 66 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Data Manager Reports

Module Overview
In this module, you will learn about Bentley Data Manager's Reports. You will
learn to open and review reports, create reports, and modify existing reports.

Module Prerequisites
• Ability to navigate through the Data Manager interface.
• Proficiency in editing data.
• Skills required to import and export data.

Module Objectives
After completing this module, you will be able to:
• Open a report.
• Create a new report.
• Modify the record source for a report.
• Add a company logo to a report.
• Modify the format of existing fields in a report.

Sep-12 67 Data Manager Reports

Copyright © 2012 Bentley Systems, Incorporated


Data Manager Reports

Data Manager Reports


Bentley Reports provide a hard copy or electronic snapshot view of the project
data at a designated time. By default, a Bentley report is a paper view of the view
data. The Bentley Report allows user logos and other required information to be
displayed on the report.

Bentley Data Manager uses the Microsoft Access report engine to produce
reports, independent of the back-end database engine used. This provides a
flexible and scalable solution to all of your project requirements. Most reports
that can be created in Microsoft Access are available in Bentley Data Manager. A
project created in Microsoft Access can migrate to MSDE and to SQL Server,
without requiring any changes to the reports or views.

Bentley does not register reports, nor does it log users who create or issue
reports.

 Exercise 1: Open the Process Instrument List Report


1 Expand the Reports node.
2 Select the Process Instrument List report in the Project Window.
3 Right-click and select Preview.
4 Click on a portion of the report to zoom in.

Data Manager Reports 68 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Report Creation

5 Click on a portion of the report to zoom out.

Note: Reports can be printed to a printer using the Printer icon at the bottom
of the report preview window. For the purposes of this training course,
we will not produce a hard copy of the report.
6 Close the report.

Report Creation
In the following exercises, you will create a new report, open the report builder,
and modify the report structure. You will add a company logo, add text, and
modify the format of some of the existing fields.

This section requires some knowledge of Microsoft Access. While reports can be
created quickly and easily in Bentley Data Manager from existing reports, there is
little benefit in having a duplicate report. Therefore, new reports will be modified
in some way.

 Exercise 1: Create a New Report


1 Right-click on the Process Instrument List report.
2 Select New.
The Create New Report dialog displays.
3 Set the From Current Report radio button.
4 Click OK.
5 Type My Instrument List in the Name field.

Note: If My Instrument List is already present, delete the existing report and
create a new one.
6 Type Transmitter List in the Description field.
7 Click OK.
My Instrument List is now an available report.
8 Double-click My Instrument List to open the report in Preview mode.

Sep-12 69 Data Manager Reports


Copyright © 2012 Bentley Systems, Incorporated
Report Creation

The My Instrument List report displays with exactly the same data as the
Process Instrument List report.

Data Manager Reports 70 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Opening the Report

Opening the Report


 Exercise 1: Open the Microsoft Access Report
1 Select the My Instrument List report in the Project Window.
2 Right-click and select Edit.
3 Click Design.
The Microsoft Access report builder is displayed.

Note: All Microsoft Access reports are split into sections. The Report section is
printed once for every report, the Page section is printed once for every
page, and the Detail section is printed once for every record.

Note: The Report and Page sections have Headers and Footers. Headers are
printed at the top of the section, and footers are printed at the bottom
of the section.

Sep-12 71 Data Manager Reports


Copyright © 2012 Bentley Systems, Incorporated
Modifying the Record Source

Modifying the Record Source


All reports require a record source. The record source defines which data the
report will display. Data Manager Reports should always use a Data Manager
view as their record source.

 Exercise 1: Modify the Record Source


1 Right-click on the Report Selector.
2 Select Properties.

3 Select the Data tab.


The Data properties for the report are displayed.

Note: As the properties window is a floating window, it can be located outside


of the Microsoft Access window. If Properties is shown as depressed,
the properties window will be displayed somewhere on the screen.
4 Using the list in the Record Source field, select My Instrument List.

5 Close the Report dialog.


6 Close the Microsoft Access window.

Data Manager Reports 72 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Modifying the Record Source

The Microsoft Access message displays, requesting whether the changes


should be saved.
7 Click Yes.
The Instrument List displays, with only the Flow Transmitter information.

Sep-12 73 Data Manager Reports


Copyright © 2012 Bentley Systems, Incorporated
Adding Graphics

Adding Graphics
 Exercise 1: Add Graphics to the Report
1 Right-click on My Instrument List report.
2 Select Edit.
3 Click Design.
4 Right-click on the Bentley logo and select Properties.
5 Select the Page Header section.
6 Select the Format tab.
7 Select the Picture field and browse to: C:\Bentley Practice
Projects\Metric
Training\Standards\Instrumentation\Templates\Client.bmp.
8 Click OK.

Data Manager Reports 74 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Adding Graphics

9 Select Stretch from the Size Mode list.

10 Move the cursor between the Page Header section and the Detail section.
The cursor changes to the resize cursor.
11 Click and drag the Detail section to the smallest size possible.
12 Click and drag the Page Footer section to the smallest size possible.
If you look further at the report, you will see that the data displayed on
the Page Header section and the Detail section appear to be very similar.
However, the data on the Page Header section are labels, while the data
in the Detail section is text.
In the Page Header section, labels are used on a report to display
descriptive text such as titles, captions, or brief instructions. Labels don't
display values from fields or expressions, and they don't change as you
move from record to record, so the data displayed in the Page Header

Sep-12 75 Data Manager Reports


Copyright © 2012 Bentley Systems, Incorporated
Adding Graphics

section will always be the same. This is standard for a Page Header;
therefore, it will contain the field titles.
In the Detail section, text is used to display view values or calculated
values, which will change as you move from record to record. Therefore,
the data displayed in the Detail section will be different for every record in
the view. This allows us to display all of the information from the defined
record source.
13 Close the Microsoft Access window.
14 Click Yes to save the changes.
The My Instrument List is now displayed with only the Flow Transmitter
information and the AutoPLANT logo.

Data Manager Reports 76 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Adding Text and Labels

Adding Text and Labels


You will use the Toolbox to insert items onto the report, and then modify the
properties. The toolbox can be turned on and off using the tool icon on the
Microsoft Access toolbar. The two main controls used on reports are the label and
the text, but the toolbox provides access to other controls for insertion onto a
report. Note that the toolbox also gives you access to images and other drawing
tools to enhance the layout of the report.

 Exercise 1: Add Text to a Report


1 Right-click on My Instrument List report.
1 Select Edit.
2 Click Design.
The Microsoft Access report builder opens. The Open the Toolbox toolbar
is not active.

Note: The Toolbox toolbar will appear on the screen as a floating window, and
may appear outside of the Microsoft Access window.
3 Click Textbox on the Toolbox dialog.
When the cursor is moved over the report, the cursor changes to the text
cursor.
4 Click Properties to open the Properties Sheet.
5 Select the Format tab.
6 Scroll down until the Auto Label property is visible.
7 Select No from the list.

8 Close the Properties Sheet.


9 Insert the Text on the report in the Detail section.
10 Select a location below LOCATION COD.
Text will be inserted with the value of Unbound.
11 Right-click on the Unbound field.

Sep-12 77 Data Manager Reports


Copyright © 2012 Bentley Systems, Incorporated
Adding Text and Labels

12 Select Properties.
13 Type 25.397cm in the Left field.
14 Type 0.3999cm in the Top field.
15 Type 1.998cm in the Width field.
16 Type 0.4cm in the Height field.

17 Select 8 from the Font Size field.


18 Select the Data tab.
19 Select Purchase Order from the Control Source list.
20 Close the Text Box dialog.
The text box changes from Unbound to PurchaseOr.

Note: A Text box can be bound to any field from the record source. You can
also assign text to calculated values.

Data Manager Reports 78 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Adding Text and Labels

 Exercise 2: Add a Label to a Report


1 Click Label on the Toolbox toolbar.
2 Select a location below the Locn.Code label in the Page Header section of
the report.
A label is inserted with a cursor flashing inside the label.
3 Type Purch. Ord and press Enter.
4 Right-click on the label and select Properties.
5 Select the Format tab.
6 Type 25.397cm in the Left field.
7 Type 3.799cm in the Top field.
8 Type 1.998cm in the Width field.
9 Type 0.6cm in the Height field.
10 Close the Label dialog.
11 Resize Page Header to be as small as possible.
12 Close Report Builder.
You have now inserted a new field and title onto your report.

Sep-12 79 Data Manager Reports


Copyright © 2012 Bentley Systems, Incorporated
Previewing Report Changes

Previewing Report Changes


Microsoft Access provides two tools to preview the report: the preview option
and the Layout Preview. It is not necessary to exit Microsoft Access report builder
and use Bentley Data Manager to preview the report.

The preview option gives a full preview of the report, using all of the data from
the record source. Using this option on a large record source may take some time.

The Layout Preview displays the report with a subset of data and allows an idea of
the layout of the report to be obtained. This is a much better option when
working with a large record source, or when there is a slow connection to the
project data.

 Exercise 1: Preview the Changes to the Report


1 Edit My Instrument List.
2 Click Design.
3 Select Preview.
The report that displays looks the same as the preview in Data Manager.

4 Open the report in Design Mode.


The Microsoft Access report builder returns to design mode.

Data Manager Reports 80 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Modifying the Format

Modifying the Format


 Exercise 1: Modify the Format
1 Select Manufacturer.
2 Right-click on the text, and select Properties.
3 Select the Format tab.
4 Type 16744448 in the Fore Color field.
5 Select Bold in the Font Weight field.
6 Modify the Model No text to be the same as the Manufacturer text.
7 Note the changes in the Microsoft Access report builder window.

8 Close the Microsoft Access report builder window.


9 Click Yes.
The changes are saved.

Sep-12 81 Data Manager Reports


Copyright © 2012 Bentley Systems, Incorporated
Modifying the Format

10 Preview the My Instrument List report.

Data Manager Reports 82 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Data Manager Assessment

Assessment is often equated with evaluation, but the two concepts are different.
Assessment is used to determine what an individual knows or can do.

Complete the assessment to see what you have gained from reviewing this
module or course (access to surveygizmo.com is necessary). When you complete
the online assessment, you will receive your Learning Units.

Note that assessments are for classroom or virtual classroom learning, and not for
OnDemand learning.

Questions
1 What is the command to change your login?
A. File > Log in
B. File > New User
C. File > Log in as a different user
D. Tools > Log in as a different user
2 Data modification must be on individual records
True
False
3 Which command would be used to show Manufacturers of a specific type
A. Build Filter
B. Filter
C. Sort
D. None of the above

Sep-12 85 Data Manager Assessment

Copyright © 2012 Bentley Systems, Incorporated


4 The Check all database objects and update if necessary command will
synchronize the database with the most current views and reports
True
False
5 Which Microsoft product does Data Manager use as a report designer
A. Microsoft Excel
B. Microsoft Word
C. Microsoft Access
D. Microsoft One Note

Data Manager Assessment 86 Sep-12


Copyright © 2012 Bentley Systems, Incorporated
Answers
1 A. File > Log in as a different user
2 False. Pressing the Ctrl key will allow you to select multiple tags for
updating. Data modification must be the same for each tag.
3 A. Using the Tools > Filter > Build Filter command you can isolate the
Manufacturer field and the select the Manufacturer you would like to see.
4 True. The database will be synchronized with the vies and reports. It is
designed for multi-user projects in which views or reports have been
updated.
5 C. Microsoft Access is used as the report designer.

Take the Online Assessment to receive your Learning Units!

Sep-12 87 Data Manager Assessment


Copyright © 2012 Bentley Systems, Incorporated
Data Manager Assessment 88 Sep-12
Copyright © 2012 Bentley Systems, Incorporated

You might also like