Dynamic selection of Columns in Reports

Question

Dynamic selection of Columns in Reports

Meera

SSCommitted

Points: 1966
More actions
September 13, 2010 at 12:42 am

#229221

Hi All !
Kindly suggest me a way for Report generation in which the columns should be selected dynamically as well removed from report.
The need is, we have a report with some standard columns.
There are many more columns with the tables. The report should be like that, when further more columns are needed to be added with the columns we should be able to include it with the report. as well when some columns has to be removed it should be able to do so.
is there a way to do such report generation?if so plz do let me know as soon as possible.
Thanks,
SD.

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

Scott Murray-240410 SSCarpal Tunnel Points: 4649 More actions · Answer 1

You could include all the columns in your report definition and then hide (visibility property) the unneeded ones based on the criteria for which columns to display.

Meera SSCommitted Points: 1966 More actions · Answer 2

Scott Murray-240410 (9/14/2010)
You could include all the columns in your report definition and then hide (visibility property) the unneeded ones based on the criteria for which columns to display.

Hi Can you xplain tht in deep?

In which platform can the reports be done? in SSRS? if so how?

Thanks in advance for your reply!

Scott Murray-240410 SSCarpal Tunnel Points: 4649 More actions · Answer 3

Go ahead and add all the columns you would need on the layout tab in BIDS. Then for each column use a Switch function or an Iif statement in the visibility property of the column. You can based the visibility on a parameter selected for the report. The function in the visibility property would be something like:

=IIF(Parameters!pShowColumn1.Value="Y", False, True)

Meera SSCommitted Points: 1966 More actions · Answer 4

Hi Scott ! Yes its working !! Thanks !!

But could you say me is there a way where the user can see all fields together and when needed they can drag and drop it to the area.

like when we construct a CUBE, when we xlplore the data, we would see an interface na? like tht is it possible to achieve such report.

Kindle let me know ..

Thanks !

Scott Murray-240410 SSCarpal Tunnel Points: 4649 More actions · Answer 5

You can use Report Builder to allow for dynamic report creation. A few different versions exist depending on what version of SQL Server you are using, but this link should get you started:

Report Builder

Meera SSCommitted Points: 1966 More actions · Answer 6

Scott Murray-240410 (9/16/2010)
You can use Report Builder to allow for dynamic report creation. A few different versions exist depending on what version of SQL Server you are using, but this link should get you started:
Report Builder

Hi Scott !!

Thanks for your reply.. yes thts i needed..