Post reply

Change header names dynamically in the tabular report SSIS 2008

  • March 20, 2011 at 8:58 pm

    #389088

    Hi Folks,

    Below is the dataset i need to show in the report but below columns i.e '03/01/2011','03/02/2011' and 03/04/2011' will change depends on passing parameters to the stored procedure. I need to show same in the report. How can i change the headers dynamically?

    Name 03/01/2011 03/02/2011 03/04/2011

    AA11 22 33

    BB20 30 40

    CC66 77 88

    Anybody can help me?

  • March 20, 2011 at 9:36 pm

    #1301103

    I don't use SSRS but I have people that do nearby. What they do under such cirumstances is they get the data from a stored procedure and they typically get that stored procedure from me. 😀

    First, see the first link in my signature below for how to post data to get the best help possible. Then, read the following article on how to do dynamic crosstabs.

    http://qa.sqlservercentral.com/articles/Crosstab/65048/

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.
    "Change is inevitable... change for the better is not".
    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)
    Intro to Tally Tables and Functions

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

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