Total count and percent total on page header possible?

[tektipsMem]

CR XI, WIN XP

I have a total count and a percent total on group 2 footer. I like to have these value shown on the page header to make stronger impact on clients who read the report.

Basic layout:

Page header: report title, {Site}, {Unit}, column headings
Group1 header: {Site} (hide, new page before, reset page #)
Group2 header: {Unit} (hide, new page before, reset page #)
Detail: ID , OP_ID, OP_name (duplicate suppress), Date
Detail suppress x-2: {@wrongID} len{ID}=5 or not(left({ID},2) in "00")
Group 2 footer: running total count of {ID} in group 2;
sum({@correctID}, {group 2 Unit})%({totalID count})

{@correctID}
if {ID}<>5 then 1 else
if left({ID},2) in "00") then 1
else 0

Any idea how to put the running total and % on the page header?

TTM [santa2]

 

[synapsevampire]

Create a faux group before group 1 using a formula of:

if {table.field} <> "zzzzzz" then
" "
else
" "

When inserting the group, select options and select Repeat Group Header on Each Page

Placde your page header into this, and suppress the page header.

You can now place summaries as in sum({table.field},{table.group2field}) in this section.

You may have to change your new page before to the group footers and use new page after.

Should get you close.

-k

 

[tektipsMem]

Thanks synapsevampire. I could not get rid of the first page with the fause group 1 even after trying out page before and page after on various header and footer. However, I use your sum({table.field},{table.group2field}) and also added count({table.field2},{table.group2field})to calculate the % as formulars in the page header and they worked. I suppose the formulars bypass that second pass on running sum at the footer.

Anyways, thank you very much for your tips, problem solved.

TTM [santa2]