CR ver. 9 I have a report that is

[Debug44]

CR ver. 9
I have a report that is using running totals. The report uses 2 export tables from UNIX.
The 1st is Today’s sales order information by part #.
The 2nd is yesterday’s sales order information by part#. The sales quantities of both are bucketed weekly on the export.

I am using running totals to select the MAX of week1 data (Week2, etc) and another to select the Min of week1 data (Week2 etc), by part #, then a formula to calculate Net Change to reflect the 2 different “Load” dates

The data looks as follows

Item # Load Date Week1 Week2 {PageHeader}
006452 01/13/2003 2,500 5,000 {Detail}
01/14/2003 2,200 5,000 {Detail}
Net Change 300 0 (GF Item #)

The calculations are all working correctly, my problem is that the report shows ALL of the items, even those with zero net change.
I would like to remove the items that do not have ANY net change in ANY of the weekly buckets. I can not do this on running total fields.
I am grouping by Item # as shown above.
Any help would be appreciated.

 

[lbass]

If you calculated net change using a formula {@netchgwk1} like the following for each week:

maximum({week1.data},{table.partno}) - minimum({week1.data},{table.partno})

...then you could format sections (group header, details, group footer) to suppress using the formula:

{@netchgwk1}+{@netchgwk2}+{@netchgwk3} = 0

This assumes that you are grouping on {table.partno}. Why did you decide to use running totals, instead of formulas like the following?

maximum({week1.data},{table.partno})

-LB

 

[Debug44]

Sorry for the late response. I have been away on business.
I took your advise and re-wrote the report to simplify the logic. Worked great.

As always---thanks for the assist LB

Bart Preston