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] "Robert Bruckner [MSFT]" wrote:
> 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.
>
>
> "pmud" <pmud@discussions.microsoft.com> wrote in message
> news:13D0A129-DEAA-4C05-9736-04E3104A9935@microsoft.com...
> > 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
> > pmud
>
>