Getting Dynamic columns into my SSRS report

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services » Getting Dynamic columns into my SSRS report

Getting Dynamic columns into my SSRS report

Rate Topic

Display Mode

Topic Options

Author

Message

Arjun123

Posted Thursday, February 14, 2013 12:01 AM

Grasshopper

Group: General Forum Members
Last Login: Monday, May 13, 2013 8:20 AM
Points: 19, Visits: 175

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

Koen Verbeeck

Posted Thursday, February 14, 2013 12:17 AM

SSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 6:51 AM
Points: 9,373, Visits: 6,470

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 »

Permissions