Can we create dynamic header in Report. In SSRS 2005.



    How can we create a dynamic column header in Reporting services 2005.

    According to choosed filter the header also change along with feilds data.

    Can any one know ??


    Thursday, November 22, 2007 9:17 AM

All replies

  • 1. Create a hidden text box in your report body. Filled with data desired.
    2. Add text box to header, used to present data.
    3. Add expression to link the text box in step 1 and 2.

    Tuesday, November 27, 2007 8:02 AM
  • Alternate - Create a hidden parameter with a default value from the desired data

    Give the text box in the header the value of the parameter.



    (edit) Sorry - Just re-read your question a little more carefully.


    You want the column heading to reflect some piece of data?  It depends on where the data is coming from.  Is it from a dataset or a parameter?


    If a parameter (with multiple valid values) you can make the column content:



    which will use the label instead of the value of the selected item.

    Thursday, November 29, 2007 6:30 AM