Previous Next

Creating New Reports
If you are unable to get the information you want by modifying an existing report, you can create a new report from scratch. In cases when you cannot get the information you want by creating reports from existing fields and operators, or when you need to transform the data, you can use a custom query report.
To create a new report
1.
If you intend to publish this report, you should still create it in My Reports, and ensure it works as anticipated before publishing the report. For more information, see Editing Reports.
2.
Click Create | Report.
3.
These are searchable fields, so provide consistent information in your reports to make them easy to find.
4.
You can only select fields from one report type.
For an overview of report types, see
Report Types Included in Enterprise Reporter.
5.
6.
7.
8.
For more information, see Creating Report Layouts, Changing the Layout and Report Designer Tips and Tricks. For a full explanation of report layouts, see the Report Designer User Guide (Developer Express), located in the folder where you installed the Report Manager.
The Query page shows you the query that will be used to generate your report.
9.
Click OK.
The report appears in the location you selected in step 1.
To create a custom query report
1.
If you intend to publish this report, you should still create it in My Reports, and ensure it works as anticipated before publishing the report. For more information, see Editing Reports.
2.
Click Create | Custom Query Report.
3.
These are searchable fields, so provide consistent information in your reports to make them easy to find.
4.
You can use any query writing tool to generate the query, and then copy it.
5.
Click Validate Query, then click OK.
– OR – 
If necessary, resolve any issues and validate your query again.
6.
If your custom query contains at least one declare parameter (such as Declare @p nvarchar(128)), the Parameters page will be available.
7.
For more information, see Creating Report Layouts and Changing the Layout and Report Designer Tips and Tricks. For a full explanation of report layouts, see the Report Designer User Guide (Developer Express), located in the folder where you installed the Report Manager.
8.
Click OK.
The report appears in the location you selected in step 1.
See also: