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
> >> >
> >> >
> >>
> >>
> >>
>
>

Hiding duplicates in a details row and hiding the row when it's em

I have a report that is using the drill down feature. So i have 2 detail
rows. The first row is field labels for the 2nd details row. What i would
like to do is only show the first details row once. I know i can set the
properties for each field to hide duplicates but then i'm still stuck with it
showing the blank row. So if i could find a way to suppress the first row
when it's blank that would be good or find a way to only print the first
details row once.well i answered my own question. i moved the field labels to the bottom of
the last grouping before the details, made sure all of the textbox fields
were marked hide duplicates, set the row height to 0, set visibility for the
row to true, and set the toggle setting to be the same as the detail toggle
setting.
"deniseamat" wrote:
> I have a report that is using the drill down feature. So i have 2 detail
> rows. The first row is field labels for the 2nd details row. What i would
> like to do is only show the first details row once. I know i can set the
> properties for each field to hide duplicates but then i'm still stuck with it
> showing the blank row. So if i could find a way to suppress the first row
> when it's blank that would be good or find a way to only print the first
> details row once.