Using Report Designer you can create your own report templates and use them in DataSight.

Within Report Designer you define the data to use for a report using a Query Builder, add data regions to the report design surface, link the data and data regions, apply formatting, create or modify parameters to provide user interactivity, preview the result, and publish the report. These are sometimes referred to as Query Reports.

To make effective choices about report design, you can explore the following report features:

• A basic report has a header, a body, and a footer.
• A report also has a default page size with page headers and page footers.
• You can place report items such as images, text boxes, and lines in headers and footers.
• The body of the report contains the report data.
• You can combine a number of charts, tables and text – extracted from the database - to produce a multi-page document and output this document to printer, screen or file.
• You link report data to report items on the design surface.
• When the report is processed, the report data and layout items are combined.
• When you view the report, the combined data and layout elements are sent to a report renderer. The renderer dynamically determines how much data fits on each page.
• Report parameters are used to specify the data to use in a report, connect related reports together, and vary report presentation.
• In a report, you can place report items anywhere on the design surface; you are not limited to "bands" of data.
• You can place data regions with different sets of data side-by-side.
• Certain report items can also contain other report items.

To use DataSight Report Designer to design reports requires a reasonable proficiency in computing. Report Designer is complex, containing a wealth of features to help you create and edit customised reports. 

Reports are created and saved using either the Report Wizard or the Report Designer, but both are editable in the Report Design Panel.

Create a report using Report Designer

1. Click Report Designer from the Output group on the DataSight Ribbon.
2. Create a query with Run a Query Builder or select a Stored Procedure (See Query Builder for details).
3. Click Finish. DataSight will take you to Report Wizard.
4. Step through the Report Wizard as required (See Report Wizard for more details).
5. Click Finish to complete the Report Wizard. DataSight will now take you to the Report Designer.