Post reply

Getting Dynamic columns into my SSRS report

  • February 14, 2013 at 12:01 am

    #270100

    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

  • February 14, 2013 at 12:17 am

    #1587729

    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.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

Viewing 2 posts - 1 through 1 (of 1 total)

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