Chat now with support
Chat with Support

Enterprise Reporter 3.5 - 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

Creating a Calculated Field

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

To create a calculated field
1
In My Reports, select the report, then click Edit report.
2
To edit the existing layout, click the Layout button, then click the Edit button.
For more information, see Changing the Layout .
3
Click the Fields List tab.
4
To add a new calculated field to the field list, in DataSet1, right-click the Table folder and click Add Calculated Field.
The new calculated field is created under the Table folder.
5
To open the Collection Editor, right-click the new calculated field, and click Edit Calculated Field.
6
Enter a name in the (Name) property.
7
In the calculated field properties, select the appropriate field type.
Possible field types include String, DateTime, TimeSpan, Byte, Int16, Int32, Float, Double, Decimal and Boolean.
8
To open the Expression Editor, click Expression property and click .
9
Set the applicable expression and click OK.
The calculated field value is based on the results of the expression. The expression can be created using functions, operators, data fields, constants and parameters. For example, to create a full name field from two fields (First and Last Name) use “”.
For more information, see the Report Designer User Guide (Developer Express), located in the folder where you installed the Report Manager.
10
Click OK to save the calculated field.
11
Drag and bind the calculated field to any control for display in report layout.
For more information, see Binding a Data Field to a Control .

Creating a Script to Run with a Report

Scripting allows you to insert scripts into a report and run them when the report is previewed, printed, or exported. Script commands should be placed within the event handlers of the report objects. When the corresponding event occurs (for example, a mouse click), the script code runs.

Script languages supported include C#, Visual Basic® and J#.

To add a script to an event
1
In My Reports, select the report, then click Edit report.
2
To edit the existing layout, click the Layout button, then click the Edit button.
For more information, see Changing the Layout .
3
Select the report control or object to execute the script on an event.
4
On the Property Grid in the Behavior section, expand the Scripts property and click the event on which to run the script.
5
To create a script for the selected event, click the drop-down arrow and select New.
6
In the Script Editor, enter the text for the new script.
Use the Validate option to validate and view script errors in the bottom panel.
7
Click OK to save changes and exit the script editor.
- OR -
Click the Designer tab to return to the Report Designer to continue editing the report.
You can edit and view the script by selecting the Scripts tab on the main Report Designer page.

Publishing Reports

Reporting administrators can publish reports that will be useful to their users. When a report is added to the Published Reports container, it is visible to all reporting users the next time they open their console. These reports are generally customized to suit your environment. You can base a published report on a report from the library, or you can create a new report and publish it. If you are a reporting administrator, you can edit reports directly in Published Reports; however, it is recommended that you copy reports to My Reports for editing.

If you have many published reports, you can create categories to group your reports for easier access. For information on copying reports, see Copying Reports . For information on categories, see Working with Report Categories .

To publish a report
•
Copy a report from My Reports or the Report Library into Published Reports.
To update a published report
1
Copy the report from Published Reports into My Reports.
2
Modify the report as needed.
3
When you are ready to publish, delete the old version from Published Reports.
If you skip this step, when you copy the revision back to Published Reports, it will be renamed to Report Name (1).
4
Copy the report from My Reports to Published Reports.

Integrating with SSRS

You can configure Enterprise Reporter for publishing reports to SQL Server Reporting Services (SSRS). Reports can then be published allowing users to generate reports using a web browser instead of the Report Manager.

See also:

•
Configuring SSRS
•
Publishing Reports to SSRS
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating