We help IT Professionals succeed at work.
Get Started

Repeat Group Header on next page with no records

keydev
keydev asked
on
1,422 Views
Last Modified: 2012-05-09
Hi all-

I have a report, with a group A header, details, group A footer and a report footer (which I'll cover further down)

I want the header to repeat on each page.  I have clicked the "repeat header on each page" option already.

If I have just enough details to push the group A footer to the second page, the header will not show up (and I want it to).  If there are enough details so that there is a detail line on the second page, it works as expected and is displayed.

I could put the group A header into the page header, but then there is a problem with the report footer.

My report footer is basically a terms and conditions which takes up the entire last page, with "new page before" checked.  If I have a page header at all, it pushes the report footer to a second page.  I tried putting in the page header suppression formula: IIF(PageNumber = TotalPageCount, true, false) - but it seems at runtime it puts the page header on, then checks to see if it should suppress, which still makes the report footer 2 pages.

Hope this makes sense, and any input is appreciated!
Comment
Watch Question
Commented:
This problem has been solved!
Unlock 1 Answer and 5 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE