Multi column display in report studio

[babu babu]

Hi,
I have 3 fields like A,B,C and measure(Revenue).
The user had to select the fields(single select or multi select) based on that it should display in the report.Please give me the solution.

Thanks!
Anand.

[cognostechie]

Which version are you using? Cognos 8 or 10? I saw the same question in Cognos 8 Report Studio forum !!

[babu babu]

Hi,
I am using Cognos 10.1

Thanks!
Anand.

[cognostechie]

Your questions is not clear. If I am understanding it correct, you want the user to select which columns they want to see in the report.

If that is what you want, it can be done using conditional variable (render variable). You can use the 'Box Type' property to hide and show columns based on which fields the user selected. Create a Value prompt with Static choices for the field names.

[babu babu]

Hi,
The user need to select the combinations of columns A,B,C in the value prompt(A,B or A,C or B,C).If i use static choice A,B,C and created data item like

case when(?p?='A') then('A')
case when(?p?='B') then('B')
case when(?p?='A') then('C')
end
but the problem is i can select only 1 column based on that i can getting only one column.But the user want to select multiple combinations.
Please give me the solution.

Thanks!
Anand.

[Gopinath]

create a condition for each field..

condition1 for column A
ParamValue('p') contains 'A'

condition2 for column B
ParamValue('p') contains 'B'

condition3 for column C
ParamValue('p') contains 'C'

and render the columns based on the above conditions