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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment