background image
5584

Ice Ledger: Report Designer

Add Parameters to a Report

For your report, you can employ parameters, which can be requested each time the report is being previewed. And, based on specified values, the report will then being filtered. It's also possible to employ parameters in expressions of calculated fields.

In this example, we'll create two date-time parameters, to filter out orders which don't fall in the specified range, from the report.

To add parameters and filter your report based on their values, follow the steps below.

  1. In the Field List window, right-click over the Parameters section and in the invoked menu, click Add Parameter.

    dx/add_parameter.jpg

    Repeat this action to create the second parameter.

  2. In the Field List, select the first parameter, and in the Property Grid, set its (Name) and Description. And make sure to set its Type to an appropriate value.

    Then, repeat this step for the second parameter.

    dx/add_parameter_two.jpg

    Now, every time your report is previewed, you will be asked to specify two dates.

    NoteNote

    In Print Preview, if a report's Request Parameters option is set to Yes, its document is not generated until you have submitted values of all visible parameters via the Parameters UI.

    The following instructions explain how to use parameters to filter your report's data.

  3. Click your report's Smart Tag, and in the invoked actions list, click the ellipsis button for the Filter String entry. Then, in the invoked Filter String Editor, construct an expression where a data field is compared with the created parameters. To access parameters, click the icon on the right until it turns into a question mark.

    dx/access_parameters.jpg

    The complete filtering expression will then look like this.

    dx/filtering_expression.jpg

The parameterized report is now ready. Switch to the Preview Tab, and in the Parameters section, define the required values and click Submit.

dx/parameter_values.jpg

Expand image See Also


   
 

Follow Us on Facebook  Follow Us on Twitter  Follow Us on YouTube
Copyright © 2014 - 2024 1T Solutions Limited. All Rights Reserved.
/index.php?dir=d&pg=report_parameters