Dynamic Columns based on Parameter Rpt View Selection

See more:

SQL

SSRS

reporting

I have a report that has a "Report View" Parameter, this is a stored procedure based off of a table, Based on the selection of that parameter I want it to only return certain columns.

Example if they select '91-120 View' it would return...

Summary Total Claims 0-30 31-60 61-90 91-120

if they select '91-210 View' it would return

Summary Total Claims 0-30 31-60 61-90 91-210

and if they select '0-90 View' it would return

Summary Total Claims 0-90 91-180 181-360 361+

the biggest issue is there are 8 tables on the report that 20 + columns, currently i have to go into each column on each report and put a column visibility formula which works but is very time consuming not to mention the formula would have to be changed when a new view is created.

Current table set us is...
Summary Total Claims 0-30 31-60 61-90 91-120 91-210 0-90 91-180 181-360 360+
Summary Count Amount % ct amt ct amt ct amt ct amt ct amt ct amt ct amt ct amt ct amt

THERE HAS TO BE AN EASIER WAY