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

Question

 

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 ??

 

Answer 1

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.

thanks,
Zuomin

Answer 2

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:

=Parameters!MyParameter.Label

 

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