Urgent--Calculate the number of unsupressed formula fields 1

[dasiga222]

Hi
I am using crystal reports 10
I am using a formula field which is total_work
It is the sum of 2 database fields ( employee is table)
{@tot_wrk} := employee.regular_wrk + employee.overtime_wrk;

This tot_wrk has to be suppressed whenever its value is greater than 24;
I need to calculate the count of all the unsupressed tot_wrk
formula fields ; ie the total records which are displayed

The formula field is in a group header (G2) and is again contained within another main group (G1). I could not do
Sum ({@tot_wrk} and this is giving me an error

So the count of all the {@tot_wrk} present in group G2 should be displayed in its super group G1

Can some one please help

Thanks

 

[danausten]

Use a running total (count) and evaluate when tot_wrk > 24

HTH

Dan Austen

 

[dasiga222]

Thanks Dan Austen for the post..
Where should I place the running total (count) ?

Should I place in group heade?
Which Group header

thanks

 

[Madawc]

If you use running totals, they are working out at the same time as the Crystal report formats the line. This means you can show them in the group footer but not the group header, where they will be zero if you are resetting them for each group.
If you use summary totals, they are taken directly from the data and can be shown in the header. They can also be used to sort groups, or to suppress them.
If you want to get the summary totals for a database field, right click and choose Insert and Summary

Madawc Williams (East Anglia, UK)