Parameterized Report

Filters data in a report or defines a value that is used to calculate other values (in the latter case, use calculated fields). The example describes how to create From and To date fields which can be used to filter the report using defined dates.

1. Create a new report.

2. Bind the report to a data source and drop the required fields from the Field List onto the report Detail band.

3. On the Field List window, right-click on Parameters and select Add Parameter from the drop-down menu to display the Add New Parameter window.

4. Populate the Name, Description, Type and Default Value fields using the values in the example.

   

5. On the Field List window, right-click on Parameters and select Add Parameter from the drop-down menu to display the Add New Parameter window.

6. Populate the Name, Description, Type and Default Value fields using the values in the example.

   

7. Click the Print Preview tab to display a preview of the current report layout. The Parameters window displays which must be populated before the preview can be completed.

   

8. Click Submit to filter the report preview using the defined date parameters

   Note:
   Make sure that the Request Parameters property is set to Yes for the report (which is the default setting). Otherwise, the parameters are not requested when the report is previewed, resulting in a blank report.

Refer to Create Layout Template / Report Definition and Bind Report to Dabacon Project Data for further information.