Where do I put ??

[Lhuffst]

I have a report that needs the layout changed and am not sure where to put the changes. Hoping someone can help. Thanks Lhuffst

[blue]CURRENT LAYOUT[/blue]

Inspection Support Cross Connection Support
Schedule check File Process Special Errors Load Web File Process GIS Special Errors
Emp 1 1 1 0 9 2 5 2 4 3 1 1 0 0
Emp 2 1 1 0 9 2 5 2 4 3 1 1 0 0

totals 2 2 0 ...

November 2009


Inspection Support Cross Connection Support
Schedule check File Process Special Errors Load Web File Process GIS Special Errors
Emp 1 1 1 0 9 2 5 2 4 3 1 1 0 0
Emp 2 1 1 0 9 2 5 2 4 3 1 1 0 0

totals 2 2 0 ...

December 2009



[blue]DESIRED NEW LAYOUT[/blue]

Inspection Support
Schedule check File Process Special Errors
Emp 1 1 1 0 9 2 5
Emp 2 1 1 0 9 2 5
Totals 2 2 0....


Cross Connection Support
Load Web File Process GIS Special Errors
Emp 1 2 4 3 1 1 0 0
Emp 2 2 4 3 1 1 0 0

totals 4 8 6 ...

November 2009


Inspection Support
Schedule check File Process Special Errors
Emp 1 1 1 0 9 2 5
Emp 2 1 1 0 9 2 5
Totals 2 2 0....


Cross Connection Support
Load Web File Process GIS Special Errors
Emp 1 2 4 3 1 1 0 0
Emp 2 2 4 3 1 1 0 0

totals 4 8 6 ...

December 2009


where
GH1 = Process Date - Yearly
GH2 = Process Date - Monthly
GH3 = Emp names

Thanks everyone

 

[lbass]

You would have to explain to us how you achieved the current layout.

-LB

 

[Lhuffst]

Sorry.

RH has report name
PH has report name
GH1 = Process Date - Yearly suppressed
GH2 = Process Date - Monthly
Has Inspection Support column headers

Details counts (all are formulas) Section is suppressed
Formulas = if id = 1 then 1 else 0
if id = 2 then 1 else 0...

GF3a = formulas that have sum of details columns
i.e. sum of col1, sum of col2, sum of col3...
inspection support counts

GF3b = formulas that have sum of details columns
i.e. sum of col1, sum of col2, sum of col3...
Cross Connection support counts

GF2 Totals of details (totals line)
PROCESS DATE Label - shows as November 2010

GF2b = Has Inspection Support column headers

I feel kinda dumb because I have the report working fine in a landscape view so I thought putting one section on top of the other would be easy but haven't stumbled on the correct way to do this...
Thanks for any and all help.

 

[lbass]

What is the field that distinguishes Inspection Supports from Cross Connection Supports? It looks like the id field must correspond to the conditions: Schedule, Check ...Special, Errors?

-LB