Hiding COlumn based on Prompt

[anwar_pat]

Hi All,
  i want to show the report column based on user select into prompt list box.I mean i have prompt page where i m showing all necessary column with multi select options so that user can select only those he/she needs into reports.I am trying the hiding options based on prompt values.I have created string variable and inserted values as column name same as prompt static values and i hve written variable expression following.


Case

When ParamDisplayValue('Parameter1')='Col1' then 'Col1'

When ParamDisplayValue('Parameter1')= 'Col2' then 'Col2'

When ParamDisplayValue('Parameter1')= 'Col3' then 'Col3'
---------so on....

ELSE 'Col12'

END

i have set the properties of each column style varaible coressponding colmn name values and set the box type none.

Am i doing the correct way or any other way can i achive.pls any ideas or thougt would be appreciable.

thanz n advance.


Anwar

[Desperado]

for every column u need to have a variable. you shouldn't do it on one variable.

[anwar_pat]

thanx for reply.Can you please elobrate me in detail or steps how should i proceed.

[Desperado]

create a boolean variable var_col1.
insert something like this

ParamValue("Par_Chk_Opt_Fields") contains('col1')

then select this variable from variable explorer and apply this variable on col1.

[anwar_pat]

thz for reply..done it.