Dynamic columns in report

In RS2005, is it possible to add / remove report columns dynamically. I

mean the user will have choice to see which columns he wants to see in the

report. Depending on his selection, the report will be rendered.

Is this possible?

TIA,
Tan

YOu will have to use Report Builder for that, there is a sample within the reporting server samples and explanations in the BOL.

HTH, Jens Suessmeyer.

http://www.sqlserver2005.de|||

Another way to accomplish this is to create a report parameter with each column name as a value. Then set the visibility of each column to whether or not the user selected the value in the parameter.

For example, let's say you have a table with 3 columns - city, state, and zipcode

First, create a parameter called columnChoice set as multivalued and values from non-query. Enter in the name of the column as both the value and the label.

Then, select the city column from your table. Be sure to click the grey bar above the column as opposed to just clicking individual cells. Set the visibility -> hidden property to:

=Iif(InStr(Join(Parameters!columnChoice.value), "city"), false, true)

You can then apply this same format to each of the columns in the table. You now have a report where the user can determine which rows to show and which to hide.

Good luck!!

|||

Thanks a lot,

It solved my issue.

Tanmaya