on 01-18-2018 12:11 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
96 | |
11 | |
11 | |
10 | |
9 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.