Skip to Content

Is it possible to use a value in on a parameter

Jan 18 at 12:11 AM


avatar image

HI I have a report that has a parameter for item#. The user enters the item and he likes the report page by page according to item. The logic is using a command to create summaries and this is relatively complex.

I want to know if i can enter for the item? param a list of values he has over 800 to run

{Command.ORD_TYPE} = {?Order Type} and {Command.IDPRT#} = {?item}

I tried running this with all the items but it produces one total he wants separates.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Abhilash Kumar
Jan 18 at 09:22 AM

Hi Paul,

If you need list of values for Item prompt, here's what you need to do:

1. Create a separate command object with this sql:

Select Distinct Table.Item from Table

2. Ignore the warning CR shows after validating the command

3. Go to the Field Explorer > Edit Item prompt > Change the List of values to 'Dynamic' > From the Value column, choose the Item field from the new command table above.

4. If you want the report to produce totals per Item, you would need a group on the Item field and all summaries should be in this Group's footer.


10 |10000 characters needed characters left characters exceeded