I have a problem generating a grand

[agray123]

I have a problem generating a grand total after creating a formula driven summary.

Our "wonderful" budget office has secreted 2 positions ina department that has no other active employees, in generating my counts for the report, I have made A.DEPT ID (from the total positions count table)equal to B. Dept ID (from the count of ActiveEmployees). As a result of this dept 1120 in the executive group doesnt show and my grand total, and executive summary are off by 2.

I wrote this:

IF GroupName ({COMPLEMENT_REPORT.DEPTID.A}) ="Executive"
then Sum ({COMPLEMENT_REPORT.TOTAL_COUNT}, {COMPLEMENT_REPORT.DEPTID.A})+2
else Sum ({COMPLEMENT_REPORT.TOTAL_COUNT}, {COMPLEMENT_REPORT.DEPTID.A})


And get the right summary total of 99 positions for Executive, unfortunately I cannot create a grand total of all groups.

My short term solution is to reallocate the 2 to an active dept id but budget is cranky about it....

HELP

 

[dgillz]

You cannot sum a summary. To create a grand total in crystal you need to sum a non-summary field or create a running total.

Is thee a database field you can use to get your grand total? Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[agray123]

Went with the position move...the easy way out.

I figured that I was summing a summary. The database table option has not worked well...