Getting Totals based on meal type 1

[obuspider]

I have a select statement to select school type, school name, enrollment, total meals and meal type from a db. I need to create a view in Crystal Reports that lists each school by school type and then lists total meals for breakfast and total meals for lunch. It would look something like this

schoolname total bfast total lunch
name (number) (number)

I have been able to do one or the other, but not both. Any ideas.

 

[butkus]

Write two formula's (one for breakfast and one for lunch) that evaluates the db condition and returns a 1 if true and a 0 if false. Surpress its outpust on the report. Then insert a summary that counts each formula.

James