Crystal Reports

1. Report is producing an extra blank page with just a Page Header. Record Source is an Access db and, for example, if table has 17 records, Crystal has page 18 with just the Page Header. How do I get rid of it?

2. When exporting the above report in RTF format, I open it in Word and the extra page 18 is not there, but page 17 (last page with data) shows "Page 18" in the rpt footer !!!!!! So the page numbering sequence goes
.... 14, 15, 16, 18 ---- strange !!


jalymoAsked:
Who is Participating?
 
mdouganConnect With a Mentor Commented:
Repost as answer (for a while, they let you accept a comment, but I guess not now)

Does your report use a report footer?  If not, you should highlight the Report Footer Section on the left side of the designer and "Surpress with no drilldown".  It's possible that you  do not have this surpressed, and maybe the space is big enough that it pages to the next page, or, you might have formatted the report footer section to "Print on New Page".

If you right click anywhere on the left part of the report designer, you'll get a pop-up menu that lets you Format Section.  Click on that, and you will see a screen that lists all of your sections.  You should Surpress with No Drilldown any sections that you are not using and/or ensure that none of these sections has New Page Before checked.

Exporting to another format is a crap-shoot.  The Crystal Knowledge base has a ton of articles about what will and will not export from the print preview to the different export types, so, the page numbers could get all out of whack from what you preview on the screen.
0
 
mdouganCommented:
Does your report use a report footer?  If not, you should highlight the Report Footer Section on the left side of the designer and "Surpress with no drilldown".  It's possible that you  do not have this surpressed, and maybe the space is big enough that it pages to the next page, or, you might have formatted the report footer section to "Print on New Page".

If you right click anywhere on the left part of the report designer, you'll get a pop-up menu that lets you Format Section.  Click on that, and you will see a screen that lists all of your sections.  You should Surpress with No Drilldown any sections that you are not using and/or ensure that none of these sections has New Page Before checked.

Exporting to another format is a crap-shoot.  The Crystal Knowledge base has a ton of articles about what will and will not export from the print preview to the different export types, so, the page numbers could get all out of whack from what you preview on the screen.
0
 
AndySulzCommented:
shrink the footer and header as much as possible.
0
Never miss a deadline with monday.com

The revolutionary project management tool is here!   Plan visually with a single glance and make sure your projects get done.

 
jalymoAuthor Commented:
Mdougan ----

Post a "Proposed Answer" and I will accept.

I changed the "Report Footer section" as you described and that killed the extra page.  I'm still getting the wrong page number on the exported file, but as I am using an Access table as input, I might add a number to each record in the table and use that field as the page number.

Incidentally, the report was originally an Access report, but the exported RTF viewed in Word had lots of extra white space and some blank pages because of some large memo text fields.  Using Crystal, I can put each of these memo fields in it's own section and this seems to take care of the problem.

I'm new to Crystal, is there a web site with good info/tips/faqs ??

Thanks, JM
0
 
mdouganCommented:
You'll need to reject this answer before I could propose, however, I don't think it's necessary anymore to do that, I think you can accept a comment as an answer.

If you go to the Seagate software site and look around, you can find the Crystal Reports Knowledge base, where you can search for some of the difficult questions.

Their help file is pretty useless.

This forum is one of the best for getting specific info.  
0
 
jalymoAuthor Commented:
Mdougan -- propose answer.

My only options here are to accept/reject AndySulz' answer.  I appreciate his input, but Mdougan was first and with the solution.
0
 
jalymoAuthor Commented:
thanks
0
All Courses

From novice to tech pro — start learning today.