Hiding Point Labels

Hi all,
I have been working with a pie chart and have had some issues with data
overlapping due to the small size of the pie slice. Robert Bruckner has
graciously helped me with the expression below to hide the data points that
are smaller than X% but now the lines are still showing.
=iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart3") < 0.005 , " ",
Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2"))
I would assume that I can hide the line by going into the Label Style and
adding an expression that changes the Color to the same as the backgroud
color if the pie slice is smaller than X%. However, I can't figure out the
syntax for the expression...see below what I have and please let me know how
I should change.
=iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
"#FFFFFF", "#000000"))
This is the error I get:
The color expression for the chart â'chart2â' contains an error: [BC30205] End
of statement expected.
Build complete -- 1 errors, 0 warningsYou only need one closing parenthesis at the end of the expression. Try
this:
=iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
"#FFFFFF", "#000000")
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
news:173EAE83-5542-4FC5-A168-89E09F0CD5C0@.microsoft.com...
> Hi all,
> I have been working with a pie chart and have had some issues with data
> overlapping due to the small size of the pie slice. Robert Bruckner has
> graciously helped me with the expression below to hide the data points
> that
> are smaller than X% but now the lines are still showing.
> =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart3") < 0.005 , " ",
> Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2"))
> I would assume that I can hide the line by going into the Label Style and
> adding an expression that changes the Color to the same as the backgroud
> color if the pie slice is smaller than X%. However, I can't figure out
> the
> syntax for the expression...see below what I have and please let me know
> how
> I should change.
> =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
> "#FFFFFF", "#000000"))
> This is the error I get:
> The color expression for the chart 'chart2' contains an error: [BC30205]
> End
> of statement expected.
> Build complete -- 1 errors, 0 warnings
>|||Well that was easy!! The only problem is...it changed the text of the label.
I need to make the line and the label disappear. Can I do this? If so
where does the expression need to go?
Thanks again for all the help!!
"Robert Bruckner [MSFT]" wrote:
> You only need one closing parenthesis at the end of the expression. Try
> this:
> =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
> "#FFFFFF", "#000000")
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> news:173EAE83-5542-4FC5-A168-89E09F0CD5C0@.microsoft.com...
> > Hi all,
> >
> > I have been working with a pie chart and have had some issues with data
> > overlapping due to the small size of the pie slice. Robert Bruckner has
> > graciously helped me with the expression below to hide the data points
> > that
> > are smaller than X% but now the lines are still showing.
> >
> > =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart3") < 0.005 , " ",
> > Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2"))
> >
> > I would assume that I can hide the line by going into the Label Style and
> > adding an expression that changes the Color to the same as the backgroud
> > color if the pie slice is smaller than X%. However, I can't figure out
> > the
> > syntax for the expression...see below what I have and please let me know
> > how
> > I should change.
> >
> > =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
> > "#FFFFFF", "#000000"))
> >
> > This is the error I get:
> >
> > The color expression for the chart 'chart2' contains an error: [BC30205]
> > End
> > of statement expected.
> > Build complete -- 1 errors, 0 warnings
> >
> >
>
>|||If this is RS 2000 SP1/SP2:
Go to the Appearance tab of the data value. Click on the "series style"
button and modify the border line width property: =iif(
Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005, "0.5 pt", "1
pt")
If this is RS 2005, you should modify the border style expression:
=iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005, "None",
"Solid")
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
news:1193D40C-9712-41E4-96EF-D018C7C017D2@.microsoft.com...
> Well that was easy!! The only problem is...it changed the text of the
> label.
> I need to make the line and the label disappear. Can I do this? If so
> where does the expression need to go?
> Thanks again for all the help!!
> "Robert Bruckner [MSFT]" wrote:
>> You only need one closing parenthesis at the end of the expression. Try
>> this:
>> =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
>> "#FFFFFF", "#000000")
>>
>> -- Robert
>> This posting is provided "AS IS" with no warranties, and confers no
>> rights.
>>
>> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
>> news:173EAE83-5542-4FC5-A168-89E09F0CD5C0@.microsoft.com...
>> > Hi all,
>> >
>> > I have been working with a pie chart and have had some issues with data
>> > overlapping due to the small size of the pie slice. Robert Bruckner
>> > has
>> > graciously helped me with the expression below to hide the data points
>> > that
>> > are smaller than X% but now the lines are still showing.
>> >
>> > =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart3") < 0.005 , "
>> > ",
>> > Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2"))
>> >
>> > I would assume that I can hide the line by going into the Label Style
>> > and
>> > adding an expression that changes the Color to the same as the
>> > backgroud
>> > color if the pie slice is smaller than X%. However, I can't figure out
>> > the
>> > syntax for the expression...see below what I have and please let me
>> > know
>> > how
>> > I should change.
>> >
>> > =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
>> > "#FFFFFF", "#000000"))
>> >
>> > This is the error I get:
>> >
>> > The color expression for the chart 'chart2' contains an error:
>> > [BC30205]
>> > End
>> > of statement expected.
>> > Build complete -- 1 errors, 0 warnings
>> >
>> >
>>|||That did the trick!!
Thanks alot!!
Anthony
"Robert Bruckner [MSFT]" wrote:
> If this is RS 2000 SP1/SP2:
> Go to the Appearance tab of the data value. Click on the "series style"
> button and modify the border line width property: =iif(
> Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005, "0.5 pt", "1
> pt")
> If this is RS 2005, you should modify the border style expression:
> =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005, "None",
> "Solid")
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> news:1193D40C-9712-41E4-96EF-D018C7C017D2@.microsoft.com...
> > Well that was easy!! The only problem is...it changed the text of the
> > label.
> > I need to make the line and the label disappear. Can I do this? If so
> > where does the expression need to go?
> >
> > Thanks again for all the help!!
> >
> > "Robert Bruckner [MSFT]" wrote:
> >
> >> You only need one closing parenthesis at the end of the expression. Try
> >> this:
> >> =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
> >> "#FFFFFF", "#000000")
> >>
> >>
> >> -- Robert
> >> This posting is provided "AS IS" with no warranties, and confers no
> >> rights.
> >>
> >>
> >> "anthonysjo" <anthonysjo@.discussions.microsoft.com> wrote in message
> >> news:173EAE83-5542-4FC5-A168-89E09F0CD5C0@.microsoft.com...
> >> > Hi all,
> >> >
> >> > I have been working with a pie chart and have had some issues with data
> >> > overlapping due to the small size of the pie slice. Robert Bruckner
> >> > has
> >> > graciously helped me with the expression below to hide the data points
> >> > that
> >> > are smaller than X% but now the lines are still showing.
> >> >
> >> > =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart3") < 0.005 , "
> >> > ",
> >> > Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2"))
> >> >
> >> > I would assume that I can hide the line by going into the Label Style
> >> > and
> >> > adding an expression that changes the Color to the same as the
> >> > backgroud
> >> > color if the pie slice is smaller than X%. However, I can't figure out
> >> > the
> >> > syntax for the expression...see below what I have and please let me
> >> > know
> >> > how
> >> > I should change.
> >> >
> >> > =iif( Sum(Fields!YTD.Value)/Sum(Fields!YTD.Value,"chart2") < 0.005 ,
> >> > "#FFFFFF", "#000000"))
> >> >
> >> > This is the error I get:
> >> >
> >> > The color expression for the chart 'chart2' contains an error:
> >> > [BC30205]
> >> > End
> >> > of statement expected.
> >> > Build complete -- 1 errors, 0 warnings
> >> >
> >> >
> >>
> >>
> >>
>
>