Adding Search Parameters to a New or Existing Report

Follow

JAMS Reports can include additional Parameters to be filled in each time the report is being previewed or ran ad-hoc. Additionally, based on specified values, the report will then be filtered more specifically; it is also possible to employ Parameters in Expressions or Calculated fields.

In this example, 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 the report based on its values, follow the steps below.

In the Field List window, right-click the Parameters section, and select Add Parameter. Repeat this action to create the second parameter. 

In the Field List, select the first parameter, and in the Property Grid, set its Name and Description. Make sure to set the Parameter Type to an appropriate value.  

The following instructions explain how to use these values to filter the report's data.

Click the report's Smart Tag and click the ellipsis button for the Filter String.

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.

The completed Filtering Expression should appear as:

 

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

Have more questions? Submit a request

Comments