[RESOLVED] CR11 Formula

[Mark Gambo]

I want to create pie chart on a report but I only want to the chart to display (count) certain items on the report. So I created a Formula Field:

If {CarType} = "Ford" Then {CarModel}

When the Chart is displayed all of the "Ford" Models appear on the chart but one additional slice appears which are the Non-Ford vehicles. How do I only display the "Ford" Vehicles?

Sample Data
Type-Model
Ford-E450
Ford-Crown Vic
Ford-Taurus
Chevy-Lumina
Jeep-Wagoneer
Ford-F150

Thanks!

[Mark Gambo]

I figured out how to do what I wanted. First I needed to create a subreport and then only select the records that I wanted (CarType ='Ford') and then add it to the main report and link the CarType between each report and viola it works great.