Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Westi on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Blank Pages that don't seem to fit the mold

Status
Not open for further replies.

ghijkmnop

IS-IT--Management
Jan 20, 2003
3
US
Hi all--

I've been struggling with this for a few days now, and can't find the solution.

I have an 8.5 report that has a page header, three group headers/footers, and a details section to report on opent helpdesk tickets by department, then by tech. So the layout is:

Page Header
IT Group (Header 1)
IT Tech (Header2)
Helpdesk ticket info (Header 3)
Description of ticket and steps taken - memo field from DB (Details)
Horizontal rule for functional aesthetics (Footer 3)
Tally of IT Tech's open tickets (Footer 2)
Tally of IT Groups open tickets (Footer 1)
Tally of all tickets (Report Footer)

I've tried every combination of Keep Together and New Page suppression I can think of, and I get either:

A. a blank page with the page header and header #1 at the beginning of each IT group's list, or

B. any IT group that has only 1 open ticket gets grouped on the same page with the next/previous IT group, but there are no blank pages.

This is getting maddening. What I'm shooting for of course is to have each group get a new page at the start of their section without the blank one. Outside of writing a report of each of the 10 IT groups in my organization and collating them later, do any of you have any suggestions?

I appreciate any help you may have.
Thanks
 
Conditionally format Group Header 1's "New Page Before"
using the (x-2) button (the check box should be empty).

The formula to use:
Not OnFirstRecord

You shouldn't need any other new page befores or afters

Extra info:
The "keep together" in the "format section" area yields differnt results than the "keep together" when setting up your groups. Mike
If you're not part of the solution, you're part of the precipitate.
 
Well, that solved it for half the report. Strangely, the rest exhibits the same behavior.

Thanks for the help. Any thoughts on this bugaboo?

Jeff
 
None that I can think of.


If you send me the report, I'll see if I can figure it out

vonbarron1@yahoo.com Mike
If you're not part of the solution, you're part of the precipitate.
 
I've sent your file back to you.

Here's what I did:

I went into Report/Change group expert.. and for Group 2 (IT tech) I removed the Keep Together. It seems, and I may be wrong, that the Keep Together takes the where the end of the group stops into consideration without regard to where the begining starts.

Mike
If you're not part of the solution, you're part of the precipitate.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top