COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: everlearner on 19 Dec 2013 03:57:09 AM

Title: paramDispValue(paramater) output in list format???
Post by: everlearner on 19 Dec 2013 03:57:09 AM
Hi Gurus,

is it possible to show the paramDispValue(parameter) output in list format???
i have a multiple selection prompt, whatever the selection made on it, that are all have to show in my list report as column titles.
when i selected a single value, i able to show that as column title in list, but we i selected multiple values that are showing in csv format as column title( in a single column). i want all that in separate columns.
how to do this? thanks a lot in adv.
Title: Re: paramDispValue(paramater) output in list format???
Post by: MFGF on 19 Dec 2013 05:12:04 AM
Can you be more clear about what you need? It sounds like the data item you are filtering on is a single item? In a list it will always be a single column. If you want each value in a separate column this is what a crosstab does. Or do you mean something different?

MF.
Title: Re: paramDispValue(paramater) output in list format???
Post by: everlearner on 19 Dec 2013 05:37:13 AM
Hi MFGF, thanks for ur reply.
here the below an example.

my prompt has these values in it
A
B
C

my report consist

col1 col2 col3

when i select A from prompt, my output is col1 col2 col3 A
but when i select A,B from prompt , my output would become col1 col2 col3 A,B

but my required output is col1 col2 col3 A  B

this is what am looking for, thanks in adv