Post reply

dynamic columns in report

  • January 11, 2013 at 3:18 am

    #393922

    I want to add a Dynamic column in SSRS report at run time. Because I dont know about the columns in design time. The columns will come from stored procedure based on the user selection.

    MATRIX REPORT is not working for my scenario

    thanks in advance

  • January 11, 2013 at 10:38 am

    #1576436

    Are you adding a single column, or do you have a list of several columns that may need to be added? How many variations are we talking about here?

    Do all reports have columns A - F, but then there are varying columns after that or do all columns vary?

  • January 14, 2013 at 10:53 pm

    #1577148

    10 COLUMNS ARE static in my SP and remaining columns are dynamic based on users selection. like feedback1,feedback2.................feedback n (feedback is my column name)

  • January 14, 2013 at 11:08 pm

    #1577149

    So does the SP utilize dynamic sql?

    Jason...AKA CirqueDeSQLeil
    _______________________________________________
    I have given a name to my pain...MCM SQL Server, MVP
    SQL RNNR
    Posting Performance Based Questions - Gail Shaw[/url]
    Learn Extended Events

  • January 14, 2013 at 11:55 pm

    #1577157

    yes..i have used dynamic pivot for generating those dynamic columns

  • January 15, 2013 at 8:16 am

    #1577359

    http://www.codeproject.com/Articles/11254/SQL-Reporting-Services-with-Dynamic-Column-Reports

Viewing 6 posts - 1 through 5 (of 5 total)

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