Add custom code parameters to a report

You are able to include custom code on reports in order to make them more complex. The following example illustrates how to add a custom code parameter to the report that is connected to RealTime.

To add a custom code parameter

1. In Microsoft Visual Studio, select the report that you want to add a custom code parameter to.

   

2. Right-click on the report and select Report Properties.

   The Report Properties dialog box appears.

   

3. In the Report Properties dialog box:

   1. Select the Code tab.

   2. In the Custom code field, enter the custom code function.

   3. Select OK.

4. In the Report Data pane, right-click your dataset and select Dataset Properties.

   

   The Dataset Properties dialog box appears.

   

5. Select Use a dataset embedded in my report.

   Extra field options will appear in the dialog box.

   

6. Select OK.

   The Expression dialog box appears.

   

7. In the Expression dialog box:

   1. Enter the expression in the Set expression for: Query,CommandText field.

   2. Select OK.

   The Expression dialog box closes.

8. Navigate to the Report Data pane > Datasets.

9. Right-click your dataset and select Dataset Properties.

   The Dataset Properties dialog box appears.

   

10. In the Query field, enter the text for your query call.

11. Select OK.

12. Select the Preview tab of your report.

    

13. Manipulate your report data using the new custom code parameter you created.