COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: kclark on 21 Jun 2013 10:47:30 AM

Title: Parameters acting as Array
Post by: kclark on 21 Jun 2013 10:47:30 AM
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
Title: Parameters acting as Array
Post by: Lynn on 21 Jun 2013 10:51:52 AM
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
Title: Re: Parameters acting as Array
Post by: kclark on 21 Jun 2013 12:54:13 PM
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!