Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

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

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

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

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

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


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:46 AM
Points: 13,622, Visits: 10,513
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 LessThanDot.

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

Add to briefcase

Permissions Expand / Collapse