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.	Select My Reports or a container within My Reports.

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.	On the General page, enter a report name, author and description.

These are searchable fields, so provide consistent information in your reports to make them easy to find.

4.	On the Fields page, select the report type on which to base your new report.

You can only select fields from one report type.
For an overview of report types, see Report Types Included in Enterprise Reporter.

5.	Select the fields, and click Add.

6.	To sort on a field or apply an aggregate, right-click the field and choose the option from the menu. For more information, see Modifying the Fields to be Included.

7.	On the Parameters page, create the required parameters. For more information, see Working with Report Parameters.

8.	On the Layout page, create your report layout.

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.	Select My Reports or a container within My Reports.

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.	On the General page, enter a report name, author and description.

These are searchable fields, so provide consistent information in your reports to make them easy to find.

4.	On the Query page, type or paste your query.

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.	Optionally, on the Parameters page, create the required parameters. For more information, see Working with Report Parameters.

If your custom query contains at least one declare parameter (such as Declare @p nvarchar(128)), the Parameters page will be available.

7.	On the Layout page, create your report layout.

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:

•	Creating Report Layouts

•	Exporting and Importing Report Definitions