Chat now with support
Chat with Support

Enterprise Reporter 3.5.1 - Report Manager User Guide

Quest Enterprise Reporter Report Manager Introducing the Report Manager Running and Scheduling Reports Creating and Editing Reports Troubleshooting Issues with Enterprise Reporter Appendix: PowerShell cmdlets

Adding a New Grouping to a Report Layout

Groupings are set in a report layout using group bands. Each group band needs to be configured with applicable settings to group the information in your report in a meaningful manner.

2
To edit the existing layout, click the Layout button, then click the Edit button.
4
Click Insert Band and click Group Header to create a group header band.
5
Click the group header band and click on the > icon to open the Group Header Tasks dialog box.
7
Click Add to add a new group field to the collection.
In the Group Field properties panel, click the Field Name drop-down arrow and select the data field for grouping.
8
Click OK to save the grouping collection.
9
Optionally configure group header settings such as Keep Together and Repeat Every Page to control how the groupings are displayed in the report.

Adding a New Column to a Table

When creating or modifying a report, there are many instances where you will want to edit a table. The default report template has tables created in each band.

2
To edit the existing layout, click the Layout button, then click the Edit button.
5
Right click and select Insert | Column To Right.
Right click and select Insert | Column to Left.

Formatting Rules: Hiding or Showing a Field Based on Data Values

This advanced option is used when you want to control the display of data based on the value of the data. For example, if the value of the data to be displayed in a field is null, you may wish to suppress it. There are many other formatting rules that can be applied based on the value contained in the data. For more information, see the Report Designer User Guide (Developer Express), located in the folder where you installed the Report Manager.

In this section, we are going to illustrate formatting rules using an example of hiding/showing a table cell control based on a data value.

2
To edit the existing layout, click the Layout button, then click the Edit button.
6
Click Edit Rule Sheet to create a new rule.
10
Click OK to save the condition.
11
To show the table cell based on the condition, set the Formatting | Visible behavior to Yes.
12
Click Close.
13
To apply this formatting rule to the table cell, click the rule and click the > icon to add the rule to the list for “Rules Applied to This Control”.
14

Creating a Calculated Field

Calculated fields are data fields that can be created to perform calculations over different data fields in your report.

2
To edit the existing layout, click the Layout button, then click the Edit button.
3
Click the Fields List tab.
8
To open the Expression Editor, click Expression property and click .
10
Click OK to save the calculated field.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating