Suppressing '0' values in charts

[varadha72]

Hi,

Happy New Year...

I have a question. I have a procedure that returns be three fields
ID Current Target
1 0 10.2
2 0 45.3
3 10.2 0
4 80.8 0
5 9 55.5

Requirement- 2 charts side by side.
1. I need to plot a chart1 showing round(percentage values of Current values) and NOT PLOT 0 VALUES.
2. Chart 2 showing round(percentage values of Target values) and not plot 0 values.

I created two charts similiarly and used percent values in the chart data select and when I ploted this chart,
chart 1 shows me values for 0,0,10, 81 and 9
and chart 2 shows values for 10,45,0,0,56
But in both these charts the 0 values are not getting suppressed. Can someone please explain how I could acheive this.

 

[varadha72]

Can someone help me with this question.

 

[varadha72]

Can anyone guide me in this issue. I need to create 2 pie charts to display at the same time, but each pie chart displays different data but should supress the 0 values.
If I use record select or select expert to suppress the 0 Values, this will suppress all 0 values only for one field (either current or target).
My requirement is to suppress the 0 values in Current chart when current values=0 and in chart2 (Target chart) suppress the values when Target value=0.

 

[pmax9999]

The only way I can think of would be to put the charts in separate Sub-Reports, where you could use Record Selection to exclude the zero values. By using 2 Sub-Reports, the Record Selection becomes specific to the chart being displayed, and therefore will not impact on the data for the other chart.

Hope this helps.

Cheers
Pete

 

[varadha72]

Thanks for your response pmax9999.

I had that option, but my focus was to reduce the number of subreports in my report. Already my report has too many subreports. If any way we could acheive this by using formulas it will be very useful. Please help.

 

[varadha72]

Also my concern for not using different subreports is because, I need to show one legend which encompassess all the values from Current and Target where (current <>0 and target <>0). This I will not be able to acheive evenif I use 2 subreports to chart them. Because the legend got to be in one chart for sure. I do not want to create 3rd subreport for the legends.

Please advise.

 

[pmax9999]

Like I said in my earlier post, its the only way I can see to do it. Maybe someone else can offer a better solution.

Cheers
Pete