distinct records

[catchingup]

I am working a report in CR11. The information in the report is all coming from a stored procedure. There is a parameter in which the user selects a specific week.

The Grouping is set up as such:

GRP1 HDR - grouped by Project
GRP2 HDR - grouped by Company
DETAIL - CompName, #of Units, #ofWorkers
GRP2a FTR - displays subtotals by Comp for the week selected
GRP2b FTR - displays subtotals by Comp for whole project
GRP1a FTR - displays Grand Total for week selected by Project
GRP1b FTR - displays Grand Totals for whole project


I am having problems in this final Group footer section because my formulas are adding the same info multiple times.

The information that is passed contains week specific and project specific info. The formulas in this section are adding the same cell values multiple times.

This is an example:

Formula for grand total Total #of Units -
SUM({TOTAL_UNITS}, {CompName})

but the data in the table looks like this:

PROJECT COMPNAME CONT TOTAL_UNITS
123 ABC X 6
123 ABC Y 6
123 AER A 6
123 GHJ B 6
123 GHJ C 6
123 XYZ H 6


When I put this formla above in - for CompName ABC I should be getting 6 but I am getting 12. thoughts?

 

[lbass]

Use a running total instead that does a sum of {totalunits}, evaluate on change of group: compname, reset on change of group: compname.

Place the running total in the group footer for company.

-LB