Results 1 to 11 of 11

Thread: Crystal Reports 11 - 2 Page report prints in 3 pages (1 empty page)

  1. #1

    Thread Starter
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,803

    Crystal Reports 11 - 2 Page report prints in 3 pages (1 empty page)

    I made a CR report, and I have 2 pages in it, so 1 record = 2 Pages.

    But when I print to the printer, it prints 3 pages.... 2 pages + 1 empty page

    There is no 3'rd page... I don't understand it...

    I attached a print screen of the report (but I had to obscure the text) to see that there is no 3'rd page...

    Each page is ~ 10.5 Inches, so the end of the second page should be 21 inches, but my text stops at 19 Inches... so I don't see the problem...
    Attached Images Attached Images  
    Last edited by CVMichael; Jun 20th, 2007 at 10:53 AM.

  2. #2
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: Crystal Reports 11 - 2 Page report prints in 3 pages (1 empty page)

    Is there something in a group footer that say new page after?
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

  3. #3

    Thread Starter
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,803

    Re: Crystal Reports 11 - 2 Page report prints in 3 pages (1 empty page)

    What is "Group Footer" ?

    Both Page Footer & Report Footer are empty, and Suppressed...

  4. #4
    A SQL Server fool GaryMazzone's Avatar
    Join Date
    Aug 2005
    Location
    Dover,NH
    Posts
    7,493

    Re: Crystal Reports 11 - 2 Page report prints in 3 pages (1 empty page)

    Did you set up groups in the report? If so there is a group footer and it can be set to place a new page after the footer (each group would start on a new page).
    Sometimes the Programmer
    Sometimes the DBA

    Mazz1

  5. #5

    Thread Starter
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,803

    Re: Crystal Reports 11 - 2 Page report prints in 3 pages (1 empty page)

    No, now groups...

    If there was, it would be listed in the "Field Explorer" window, under the "Group Name Fields", right ? (That section is empty)

  6. #6

    Thread Starter
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,803

    Re: Crystal Reports 11 - 2 Page report prints in 3 pages (1 empty page)

    I think I figured out what couses the problem but I don't know how to fix it...

    I started to remove objects from the second page, and when I remove the picture then I did not get the 3'rd page.

    The problem is, I need that picture there... but when it's there I get a 3'rd empty page...

  7. #7
    Hyperactive Member NPassero's Avatar
    Join Date
    May 2007
    Location
    NJ
    Posts
    272

    Re: Crystal Reports 11 - 2 Page report prints in 3 pages (1 empty page)

    Check to make sure the width of it is not exceeding the margins on the right side, sometimes it will stick an extra page to the end of it because of that margin.

  8. #8

    Thread Starter
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,803

    Re: Crystal Reports 11 - 2 Page report prints in 3 pages (1 empty page)

    The picture is small (I changed the picture in my first post to show where the picture is in the report).

    I even removed ALL the text and kept only the picture on top of the page, in the second page.... and I STILL got the 3'rd empty page.

    Just the presence of the picture, it makes the report have an extra empty page.

    Also... something else I noticed... if Crystal Reports has to print more than one record, then I DON'T get the extra page, this happens only when CR has one record to print.

    The problem is that even when I have more than one record, I will have to print one record at the time. So when I have 10 records, I'm basically calling Crystal Reports 10 times, and each time printing one record.

    This has to be like that becuse of other things that the application is doing (this is the requirment of the application to print one record at one time for all records in the table).

  9. #9

    Thread Starter
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,803

    Re: Crystal Reports 11 - 2 Page report prints in 3 pages (1 empty page)

    For anyone who wants to know:

    I solved the problem by separating the page and I put another Detail section, and I placed the picture in the second Detail section.

    See attached picture:
    Last edited by CVMichael; Jun 6th, 2009 at 09:34 PM.

  10. #10
    Hyperactive Member NPassero's Avatar
    Join Date
    May 2007
    Location
    NJ
    Posts
    272

    Re: Crystal Reports 11 - 2 Page report prints in 3 pages (1 empty page)

    Will this be affected for creating other reports with more data on the top page ? Because it would stretch the picture down further and almost recreate the same error as before..

  11. #11

    Thread Starter
    PowerPoster
    Join Date
    Feb 2002
    Location
    Canada, Toronto
    Posts
    5,803

    Re: Crystal Reports 11 - 2 Page report prints in 3 pages (1 empty page)

    I don't know... probably...

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width