Pie Chart Suppress Values equal to 0%

[trivalent]

I am using Crystal Report 11. I am using a Cross Tab to generate a Pie Chart. The Cross Tab is doing a percent count of v_rpt_service.Service_type. I want to suppress all percents equal to 0%. Can this be done and how. Thanks in advance.

 

[CR85user]

Create a formula:

//{@Servicetype}
if count({v_rpt_service.Service_type},{your.grouping} = 0 then '' Else {v_rpt_service.Service_type}

Then use this in the chart as per normal.

'J

CR8.5 / CRXI - Discovering the impossible