Is it possible to use a value in on a parameter

[Former Member]

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.

[abhilash_kumar]

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.

-Abhilash