Dynamically adding columns to list report based on prompt selection

[dipstm]

Hi All,
I have a list report which has 8 columns. The columns tht appear after  the 8th column are dynamically populated based on the prompt selection in the prompt page.
For eg:- If the user selects 4 enteries say P1,P2,P3 and P4 from the prompt then in the list report there should be 4 additional columns(P1,P2,P3,P4) in addition to the 8 columns.
How can we achieve this?
Plz let me know.
Thanx in Advance.

[fasi]

try the link below.

http://support.cognos.com/supported/supportlink/techniques/ta_0807_02.html


Thanks.

[dipstm]

Hi,
Actually i want to add dynamically based on the values selected in the list box prompt in the prompt page.

Many Thanx.

[cognosjon]

Hi,

its not very pretty but I have done this before though I only had 6 columns to display.
Created a list report containing every potential column that you want to be displayed.
On the prompt page create a value prompt (Check box) and added as static values every column Name that appears on the list report. I made the prompt mandatory.

Then create a variable that tests the prompt to see if the values selected and then use this variable as a render variable on for your column on the report.
So in my case I had six variables ( i did say it wasn't pretty) that tested the values selected in the prompt and then used these to hide or display the desired columns.

Hope i haven't confused you