Showing posts with label trouble. Show all posts
Showing posts with label trouble. Show all posts

Sunday, February 19, 2012

Append String to Value

I'm using SQL Reporting Services 2000 and I've built a pie chart. I'm having
trouble displaying the values in the chart. What I want to do is append a
string to the value that is displayed in the legend. Why doesn't this work?
On the Values tab of Chart Properties -> Data tab -> I double clicked on an
item in the Values listbox.
In the Series label:
= "Fully Patched = " + Sum(Fields!FullyPatched.Value)
In the Value: label:
= Sum(Fields!FullyPatched.Value)
This displays Category 1 in the Legend. The 1 is correct but I'm not sure
where the word Category came from. Also, how do you create a Constant? If
you go to the Edit Expression dialog, You have a choice to choose from
Constants, Globals, ..., but I cannot figure out where to declare and set
these variables.
Thanks,
-ChadOk, I figured out you need to use & instead of +, so:
= Code.strTest & Sum(Fields!FullyPatched.Value) was what I needed.
Now, what about Edit Expression -> Fields: -> Constants? How do I add/use
them?
Thanks,
--Chad