Field cannot be summarized, Crystal Reports, 'previous function'

[Jdbenike]

I am working on an existing report that is trying to calculate break times for all minor employees and finding all minors that worked more then 6 hours without a 30 minute break.

Based on the tables I have and not having the ability to create new ones in the environment, I have one field that grabs the actual 'lunch time'. Called {@shortlunch}, which takes two other fields, with calculations in itself which basically calculate the lunch of a minor by taking their in punch, minus their pervious out punch. Their is no actual table field that shows the break time.

So the {@shortlunch} field does not show select expert and I need to not have any records less then 1800 seconds show grouped by eventdate for each employee. Which is Group 3 because their are multiple lines for each record.

http://i2.photobucket.com/albums/y12/jdbenike/untitled-1.jpg

That's a picture of the results. The Lunch Length column is the last filter I need to be filtered.

So I created another field called {@count}
with the code
if {@shortlunch} > 1799 then 0 else 1

Then I created another field called {@count sum}
with the code
sum({@count sum},{@GROUP3})

This is when I get the cannot summarize error message. The only way I figured to show this data is to show a '1' for when the infraction incurs, and create another column that sums that's column 'cause it will only happen once. Then use select expert to say anytime '1' incurs do not show that record.

Could someone please help me

Thank You

 

[lbass]

The following steps should have been done in the MAIN report, NOT the subreport.

Then formated the detail section, and both GH#3_b and GF#3 to suppress with this formula: Did this by going to the section expert in the subreport and clicked the formula button next to the supress ( no drill down) tab.

whileprintingrecords;
shared numbervar max;
max >= 1800

-LB

 

[Jdbenike]

Changed it. Still hanging.
Let the report yesterday run through the whole night.
This one looks like it will do the same and not finish.

The report originally before I made these changes finished in less then a minute when processed.