Reporting

The Telerik Report Wizard helps you quickly create the structure of your report. Using the wizard you can:

  • Select a data source.
  • Design a query to execute against the data source.
  • Choose the type of report to create. 
  • Specify the basic layout of the report.
  • Specify the formatting for the report.

The Report Wizard runs automatically when you add a Telerik Report item to the project, but can also be run using the Telerik Reporting Menu. Each run of the Report Wizard overwrites previous definitions of the report. The Report Wizard consists of the following pages:

PageImageDescription
Welcome Page
This page lists the tasks that can be performed with this wizard.
Report Choice Page
From here you can choose to create a new report or convert from an existing report. Select New Report to start from scratch or select Convert from existing Report to select from a list of available converters.  Use the Browse button to locate the report to convert.
Choose Data Source

This page lets you use an existing data source from a list of data sources or add new Data Source. If you choose to create new data source, click the Add New Data Source button to start the Data Source Wizard. It will walk you through an additional set of steps and when finished will return you to the Report Wizard so you can continue.

Select Report Type

This page lets you choose the report type. Choose Standard to create a general type of report or Label if you would like to create a special purpose report such as one for printing labels for mailing envelopes.

Design Data Layout

Lets you select data columns from the data source and have them placed in the report heading and the detail sections of the report. You can also choose columns to group data by.

Select from a list located on the left in the dialog titled Available Fields. Use the Report, Group and Detail buttons to add the selected column from the Available Fields to the respective list of Displayed Fields. Use the Remove button to move fields from the Displayed Fields list back to the Available Fields list.  Use the up and down arrow buttons to reorder the columns in the report.

Choose Report Layout

Choose from a list of predefined layouts to quickly structure the reports visual representation. See the Description and Preview window to get a rough idea of how the report will be layed out.

Select the Adjust report items to fit available space checkbox to have columns take all the horizontal area available. Unselect this checkbox if you want to add other columns by hand later and need the columns to take less horizontal space.

Check the Generate sub-totals to have subtotals created at group footers. Appropriate functions are used based on the data type of the column, i.e. Sum() for numeric Count() for other types.

Choose Report Style
Select from a predefined list of report styles to give your report a polished look. The preview widow provides  a general idea of what a finished report will look like.
Completing the Wizard
This page provides a summary of the choices made in the wizard including the connection string and SQL statement. Click the Finish button to see the completed report or Cancel to ignore all changes.