Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Getting Dynamic columns into my SSRS report Expand / Collapse
Posted Thursday, February 14, 2013 12:01 AM


Group: General Forum Members
Last Login: Monday, November 4, 2013 9:41 AM
Points: 20, Visits: 201

I have one SP it returns 10 columns based on selection some more columns i am getting(dynamic columns)
how to get these columns also into my SSRS report

in my report i am able to get those 10 columns only

Post #1419829
Posted Thursday, February 14, 2013 12:17 AM



Group: General Forum Members
Last Login: 2 days ago @ 6:23 AM
Points: 15,499, Visits: 13,162
Rewrite your stored procedure so that it always gives the same amount of columns. If the selection dictates you don't need certain columns, fill them with NULL values.
In the report, you can hide the columns you don't need.

How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at SQLKover.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1419837
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse