Home » Visual StudioRSS

SSRS Graph - Adding Parameter Expression to Title

How does one add a parameter value within a Title of a Graph?

I'm using Reporting Services 2005 and it wont allow me to click on the expression like it has for other fields.



3 Answers Found


Answer 1

Hi Sam,

You can double click on Chart title  and paste or type your expression  in that field.





Answer 2

Hi Sam233,

Sorry I don't have a copy of SSRS 2005 but this is what I did in SSRS 2008 or SSRS 2008 R2.

1. Go to "Chart Title Properties"

2. Click on "fx" in Title Text:

3. Enter your experssion, e.g. ="Games Service: " & Join(Parameters!FISCAL_YEAR_QUARTER.Value, ",")

You should be able to click on "Parameters" in Expression Builder.

Please let me know if it's the case in SSRS 2005.

Hope this helps!


Answer 3

It doesn't look like there is an expression  Builder in SQL2005 for chart title, although i've just tested it and they can be used.

In the Chart Title, just add  your expression:


NB: This has been "fixed" in SQL2008

every day is a school day

<< Previous      Next >>

Microsoft   |   Windows   |   Visual Studio   |   Follow us on Twitter