Parameterized Report

Parameterized Report

This topic describes the steps to create a report with parameters. You are required to add parameters and filter the report based on their values.

  1. Create a new report.
  2. Bind the report to DataSight data.
  3. In the Field List window, right-click over the Parameters section and in the invoked menu, click Add Parameter.
  4. In the invoked window for the created parameter, set its Name and Description. Make sure to set its Type to an appropriate value.
  5. Enabling the Supports the collection of standard values option of the parameter allows end-users to modify its value and also activates the Dynamic values and the Static values tabs of the window:

- On the Dynamic values tab, you can specify a parameter's data source, data adapter and data member. The value member defines a data field that provides values to the parameter. The display member defines a data field that provides display names for parameter values (how these values appear in the user interface available in a Print Preview).

- On the Static values tab, you can manually fill the list of parameter values, with each value having an individual description (specifying how this value appears in the Parameters panel).

  1. Repeat the previous steps to create additional parameters as required, so that every time your report is previewed, you will be asked to specify these parameters.
  2. To use parameters to filter your report's data, click your report's Smart Tag, and in the invoked actions list, click the ellipsis button for the Filter String
  3. In the invoked Filter String Editor, construct an expression where a data field is compared with the created parameters.
  4. To access parameters, click the icon on the right until it turns into a question mark.
  5. Switch to the Preview Tab, and in the Parameters section, define the required values and click Submit.

Note

In Print Preview, the report's document is not generated until you have submitted values of all the parameters that have the Show in the parameters panel option switched on via Parameters.

 

    • Related Articles

    • Report Designer

      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 ...

    • Report Wizard

      The Report Wizard is a tool that allows you to easily create reports using data from the currently selected filter in a datasheet, focussed in the Main Panel. These reports are sometimes referred to as Datasheet Reports. Report Wizard is also invoked ...

    • Sharing Report Templates

      You can create customised reports using Report Designer. If the report needs to be re-created in a new database with the same design, this can be done by sharing the report template. DataSight allows you to save the report, and share its template ...

    • Designing with Report Gallery

      The Report Gallery allows you to store common report controls, styles, data sources and full report layouts, or a combination of these elements and re-use them in different reports. Manage Report Controls You can combine report controls residing ...

    • Report Designer Bands

      Reports built using DataSight 's Report Designer follow a conventional banded report design advocated by Microsoft® and adopted by many other report engines. As opposed to "What you see is what you get" WYSIWYG reports in which a designed report is ...