Skip to Content
avatar image
Former Member

Is it possible to use a value in on a parameter

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Jan 18, 2018 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.


    Add comment
    10|10000 characters needed characters exceeded