all groups > sql server reporting services > october 2005 >
You're in the

sql server reporting services

group:

Append String to Value


Append String to Value chalexan
10/10/2005 11:11:06 AM
sql server reporting services: 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,

RE: Append String to Value chalexan
10/10/2005 11:46:11 AM
Ok, 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,
AddThis Social Bookmark Button