Skip to Content

Crystal Report margin

Crystal Report 2013SP14

We designed a Crystal Report to print barcodes. It applies custom defined size as 1X2.126 inches, margin as 0,0,0,0. Data source gets list of records from one table, and displays barcode format.

It worked on Windows 2008R2 Server.

Week ago we moved the system to the cloud server, Windows 2016 standard version with Citrix Environment.

1. First of all, got an error as "Crystalviewer returned: attempted to divide by zero" when we selected Citrix Universal Printer. The report doesn't have any calculation, nothing to be divided.

2. System admin installed screw driver on user's PC, instead of printing to Citrix Universal Printer, user can directly print the report to the local PC printer. We don't get the error anymore. But it's printed to two pages. One with barcode, another page is blank.

System admin already made changes on server based on link below.

https://answers.sap.com/questions/12742647/reports-margins-and-size-issues.html

What could cause an empty page (added page margins) from server side?

Thanks in advance.

Jane

Add a comment
10|10000 characters needed characters exceeded

  • Thank you for visiting SAP Community to get answers to your questions. Since you're asking a question here for the first time, I recommend that you familiarize yourself with https://community.sap.com/resources/questions-and-answers (if you haven't already), as it provides tips for preparing questions that draw responses from our members. Should you wish, you can revise your question by selecting Actions, then Edit (although once someone answers your question, you'll lose the ability to edit the question -- but if that happens, you can leave more details in a comment). Finally, if you're hoping to connect with readers, please consider adding a picture to your profile. Here's how you do it: https://www.youtube.com/watch?v=F5JdUbyjfMA&list=PLpQebylHrdh5s3gwy-h6RtymfDpoz3vDS. By personalizing your profile with a photo of you, you encourage readers to respond.
    Cheers,
    Julia (SAP Community Moderator)

Assigned Tags

Related questions

5 Answers

  • Posted on Jul 29, 2020 at 01:58 PM

    It used to be an error in earliest versions of Crystal reports for "Suppress if no records" function used. My guess zero records causing the problem. Does your report have any records?

    Extra page sometime means an objects goes over border. To make sure your barcode object does not go over, right-click the object, select Format and then Lock size and position.

    Add a comment
    10|10000 characters needed characters exceeded

    • Thank you Vitaly.

      1, The report has the records, it selects records from one table, no any calculation.

      2. The page is custom defined size, 1X2.126, the barcode field is 1X2, it's locked size and position. But the print preview got additional blank page.

  • Posted on Jul 29, 2020 at 02:26 PM

    Also, margins can be printer dependent. Some printers have automatic areas that are unprintable and which get added to the output even if you have all margins set to 0.

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 30, 2020 at 02:04 PM

    How do the sections in the report look? Is there just a single section with the barcode and the rest are suppressed? Is the barcode at the very top of the section (Y=0) and is the bottom of the section pulled up to the bottom of the barcode object?

    -Dell

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 30, 2020 at 02:19 PM

    Can you set a different background color to every section of the report and see what section matches the color of the extra page?

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Aug 07, 2020 at 12:27 PM

    These are the steps I would take to troubleshoot the extra page:

    1. Preview the report in Crystal in hopes the extra page had a section label or any select-able but empty item.
    2. Use the Size and Position setup to verify that the object isn't causing the section to be taller the page set-up.
    3. Use the Section Expert to look for any setting that could be causing the new page. (e.g. Underlay Following Sections, Keep Together, New Page After/Before).
    4. Use Format Editor on object to look for Can Grow or Keep Object Together.
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.