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

sql server reporting services

group:

Change the displayed name in the Series Group for a chart


Change the displayed name in the Series Group for a chart pmud
3/10/2005 1:09:06 PM
sql server reporting services:
Hi,

I created a chart in sql reporting services. I added a series group to it.
Now what i want to do is to dispaly different series names when the chart is
viewed . For example, in my database, I have Region code as numbers. I have
used this Region Code as the Series group. What i want to do is, ...

if (RegionCode ==01
{
//the series group should display North
}

Similarly for other region codes. Is it possible? & how?

Thanks
Re: Change the displayed name in the Series Group for a chart Robert Bruckner [MSFT]
3/10/2005 8:16:24 PM
Yes this is possible through the Label expression of a chart series
grouping.
* right-click on the chart and open the chart properties dialog
* go to the Data tab and edit the series grouping
* the grouping dialog has a grouping expression and a label expression
below. If no label expression is set, it will take the group expression
value as label by default.


-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

Re: Change the displayed name in the Series Group for a chart pmud
3/11/2005 7:11:05 AM
hi Robert,

I have already tried to use the following exprseeion but i think thats wrong..

=Iif(Fields!Region_Code.Value="06",chart1_SeriesGroup1.Label="California",IIf(Fields!Region_Code.Value="08",chart1_SeriesGroup1.Label="Virguinia",Iif(Fields!Region_Code.Value="06",chart1_SeriesGroup1.Label="Dallas","Florida")))

ERROR:: The label expression for the chart ‘chart1’ contains an error:
[BC30451] Name 'chart1_SeriesGroup1' is not declared.

[quoted text, click to view]
AddThis Social Bookmark Button