Suppressing "Zero" Entries In Chart Legend

[Former Member]

Using Crystal Reports XI

I have a report which contains two charts.  Like this:

The charts are built from a single query, but the results (through a formula) are split between the two.  The values are accurate, but I would really like to somehow suppress values in the legend, either specific items (I know the names of each value) or those that result in $0.

Is this possible?  How?

TIA

[Former Member · Accepted solution]

Hi Clifton,

I guess this might help you. Only when legend values are default.

http://scn.sap.com/docs/DOC-31981

Rajesh

[Former Member · Accepted solution]

Well, I don't really want to get into the process of creating my own legend.  But I'm filing this away for future reference because it is a good idea that may be useful.

Ultimately, due to time constraints, I decided to create two separate reports.

Thanks for your help, though.

[Former Member]

What about using filters to exclude the items for those that equal zero or equal (or contain) the specific items?

[Former Member]

Ok, that's a little closer (but not quite it).

What I did was create a formula for the values that feed "On change of record".  The new problem is that there is still one line in each legend that shows $0, and the label itself is blank.

[abhilash_kumar]

Hi Clifton,

I guess what you did was return the field name as blank when the result is zero.

Yes, that'll only remove the label value. It will not actually remove that record since 'it is a part of the record set'. Anything that is a part of the result set will be a part of the chart too.

Why don't you remove them from the result set itself?

-Abhilash

[Former Member]

The reason is that the single result set feeds both charts (and is being split via a couple of formulas).

I know it's kind of silly, but the "$0" fields aren't showing up on the pie itself (not that it should or even could).  I'd just like it to not show up in the legend either.

[abhilash_kumar]

Well, I know it would have been nice not to see that legend entry at all.

I'm on CR 2011 and it does the same thing.

You may raise this as an Enhancement at https://ideas.sap.com.

-Abhilash