Parameters acting as Array

[kclark]

Hi Experts,

I am trying to develop a report which utilizes a multi select prompt.  Yes, I have set the function to use the IN operator.  Now, I need to read each selection separately as would be done if I were to cycle through an array.  For example, if I were to select "Pens", "Legal Copy Paper", and "Staplers" in the prompt screen.  I would like for my report to show for Pens:  The number of orders placed, the cost of each pen, etc., then in another query the same for Legal Copy Paper, and so on.

How would I accomplish this?

Kind Regards,
kclark

[Lynn]

Sounds like you just need to include that same data item you are filtering on in your layout along with the data item containing the measure. One query needed, no iterations through an array required. Unless I'm missing something more?


Sent from my iPhone using Tapatalk

[kclark]

Yes but the issue is in the organization of the report.  I have a sample attached.  So even if I have it all in one query, I need to have each quote separated out into columns.  Thought to use crosstab first BUT that does seem to work based on the way the columns are grouped as if it were a single instance/query.  The attachment is really helpful.

Thanks!