DMS Report Designer

The DMS Report Designer is a powerful tool that enables you to create new reports and edit existing reports. The designer appears when you select the New Report, Copy Report, Edit Report or Add Report command.

An example of the DMS Report Designer is shown below:

Legend:

1.The area at the top of the designer has the menus and icons used to perform commands on the report (note that the Report | Data command enables you to select which DMS tables you want to appear on the report). See Designer Toolbars for an explanation of each toolbar.

2.The Code, Data, and Page tabs. For most reports you will be working in the Page tab area. The Code tab is used to write Report Scripts. The Data tab enables you to add other tables and is not used in the DMS reports at this time.

3.This vertical menu of icons is called the Designer Menu Bar and is used frequently when building a report. For details on each icon, please see the Designer Menu Bar.

4.The Objects of the report are listed and the current selected Object's Properties are listed below it.

5.This central area is where you design the report itself. Data items and variables can be dragged and dropped to this report work area.

6.The Data, Variables, Functions, and Classes tabs. The Data tab lists the current selected DMS tables for the report. The Variables tab has data such as DMS Terms, DMS calculated job fields, DMS calculated operation fields, etc. The Functions tab has the following functions:

1.Mathematical functions (Pi, Absolute value, square root, etc.)

2.Aggregate functions (Average, Count, Min, Max, and Sum)

3.Conversions of data functions (Integer to string, String to integer, String to date, etc.)

4.String functions (Trim a string of blanks, Uppercase a string, Compare texts, etc.)

5.Other functions (Create OLE object, Random number generator, etc.)

6.Date and Time functions (Date, Get the day of the week, get the current date and time (Now), etc.)

7.Formatting functions (Format date, format strings, etc.)

Items that have been inherited from a base report cannot be deleted when editing or creating a new report. These items are said to be "locked" on the report and appear with a small lock icon beside the object. In the above example, the icon, Date, Time, MasterData, and Page Footer report bands all have a lock and this cannot be deleted. Some of the fields (objects) within these bands are also locked. These locked objects can, however, be moved within the band.

If you are working on a large report with a lot of objects, you can see all the objects on your report by selecting the View | Toolbars | Report Tree. If you select this toolbar view, a report tree of objects will appear at the top left side of the designer.

See the following for more information:

1.DMS Report Tutorials for step by step examples on how to create a new DMS Report.

2.Designer Menu Bar for an explanation of the tools to design a report.

3.Designer Toolbars for an explanation of the toolbars located at the top of the Report Designer.

4.Variables tab for an explanation of the data fields, variables, etc. of the Report Designer.

5.Report Bands for information on adding report bands, such as data bands, to a report.