Select columns to include in the Report

[vinu]

Hi,

I have report which contains more than 100 columns,these report columns should be displayed based on the user selection from the prompt.
I know that we can achieve this by using java script,but i want to know is there any best approach to achieve this with out using any script.

if number of columns are less we can achieve this easily,since number of columns are more i am looking for best approach.

Please let me know if any one achieved this with out script.

Thanks,

[MFGF]

Hi,

This might be a silly question, but why not just give the users Query Studio and a package containing the relevant columns?  The users can then just drag in the items they want to see.

MF.

[vinu]

my client expecting this from Report studio.And it is not a single report.Its part of a dashboard.and it involves calcuations and filters.

please let me know if any one knows the solution.

Thanks in advance.

[blom0344]

Though cumbersome you should be able to work this out by using a render variable on the list column.
You promptpage should then have an additional prompt with a static list of the columns and render column based on this selection. We've build this with 6-10 possibilities, 100 seems to be daunting. There is perhaps even an upper limit to the amount used..