INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Jobs

incorrect page numbers after empty subreport

incorrect page numbers after empty subreport

(OP)
Using Crystal 2011 ver 14.0.9
I have a report that creates forms for patients to fill out at a doctors office pulled from an Oracle DB.
group 1 - selects the physician - displays physician name
group 2- selects the appointment time - hid
group 3 pulls appointment ID - contains group header that is suppressed on pagenumber < 2
details section A has a subreport that pulls data on the last time paperwork was filled out creates and update shared datetime variable that is used to suppress printing of unneeded areas of report below.
details section B-M are all text Objects that are suppressed by a combination of the above data elements (physician, appointment type, last date filled out, etc)
details section N resets the shared variable

The report runs great and page numbers are correct when the first record is pulled and printed or the previous record was printed.

However when there is a lunch appointment or other scheduled absence appointment ie filtered/suppressed from printing. The page numbers of the next appointment are all listed as page 1 - so the page heading is not printed.
If I drill down into the report using print preview, the page numbers are correct and the heading prints on the appropriate pages.

For example Dr Smith has 5 appointments
7:30 pt appointment Michael Knight
8:00 meeting
8:30 Breakfast meeting
9:00 pt appointment Austin Powers
9:30 pt appointment Daffy Duck

Michael Knights paperwork prints perfect - appropriate page numbers and header printing on all but first page (3 pages total)
the 8:00 and 8:30 meeting are suppressed by criteria matching in the details section - perfect
Austin Powers paperwork prints correctly but the page numbers are incorrectly marked as page 1(one), no page headers (3 pages total)
Daffy Ducks paperwork prints perfect - appropriate page number and header prints on all but first page (2 pages total)

When I print preview and drill down into the Austin Powers paperwork using the groups tree on the left - the new tab that opens containing this drill down has correct page numbers and page headings on appropriate pages.

Actual printing does not have correct page numbers.

I've switched all of my Suppress (no drill down) selections to Hide (drill down OK) and that has not helped my situations.

Any recommendations would be appreciated
Tom



RE: incorrect page numbers after empty subreport

I'm guessing you're using the "Special Field" of page number. Try creating a formula and incrementing it at the bottom of the page.

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members!

Resources

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close