Bind Parameters

This document explains how to bind and pass parameters in an Ad hoc report when the report dataset contains parameters.

Objective

Send Parameters in Adhoc Report

Prerequisite

The Parameter Sales.ds dataset is used for this example.

Download Bind_Parameter.zip file for this example.

After downloading the zip file, add the Parameter Sales DS.ds into the Dataset Section of AIV for this example. To add it into AIV follow this Link.

Steps to send Bind Parameter

1. Create an Adhoc Report using the Table component by following the steps below. While creating the report, use the parameter sales.ds that was downloaded at the beginning of this document.

2. Drag contactFirstName into the Columns section, country into the Groups section, and creditLimit into the Aggregation section from the Dataset Columns panel, as shown above.

   

3. In the creditLimit settings, select Aggregate On – Groups, where country will appear in the Group dropdown.

   

4. After performing the above steps, your screen will appear as shown below:

   

5. To run the Adhoc Report using Table Component, click on Run in the top most right corner as follows:

   

6. Clicking on Run will open the Bind Parameter window. Here, USA and Spain is passed as the parameter, which is displayed in the dialog box shown below:

   

7. After the values are provided click on the SEND button.

8. Your report will be generated with applied values of parameter.