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

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

Configuring SSRS

In order to configure the Report Manager so that you can publish reports, you must provide:

•
The reporting services URL that hosts SSRS as configured in SSRS.
This must be entered in the form http://<servername>/<instancename>.
•
A user account for accessing the reporting services URL.
The account must have access to the URL.
•
A shared data source, to be used by all reporting administrators.
If the data source doesn’t exist, it is created. You can use an existing data source by entering its name. The data source is automatically linked to your Enterprise Reporter database. You need to provide an account that is able to access the Enterprise Reporter database and has been given appropriate rights to read collected data from the database. The account needs to be in the Reporter_Reporting_Admins or Reporter_Reporting_Operator groups.
* 
NOTE: Only reporting administrators can configure and publish to SSRS.
* 
NOTE: For information on configuring SSRS, see the product documentation included on your CD or download package.
To configure SSRS for publishing reports
1
On the System Configuration page, click Configure SSRS used by Enterprise Reporter.
2
Enter the reporting services URL.
3
Open the Credential Manager and select or add an account.
For more information, see Using the Credential Manager .
4
Test your connection.
5
Enter a name for your shared data source.
If you have previously created a shared data source that you want to use, enter the same name. If you are setting up a new data source, it will be created using the provided name the first time a report is published.
6
Choose the type of authentication (either Windows or SQL Server depending on how SSRS was configured).
7
Open the Credential Manager and select or add an account that can access the Enterprise Reporter database.
8
Click OK.
Related Documents

The document was helpful.

Select Rating

I easily found the information I needed.

Select Rating