Crystal Report margin

[former_member1093627]

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

[former_member30]

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)

[former_member1000092]

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.

[vitaly_izmaylov]

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

[former_member1093627]

Great idea. Let me test. Thanks

[DellSC]

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

[former_member1093627]

Thanks. It's a single section, suppressed report header/footer, page header/footer. The page size is 1X2.126, barcode field is 1x2. (X=0, Y=0)

--JN

[DellSC]

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

[former_member1093627]

Thank you Dell.

We used the same printer, Dymo 450 label printer.

It was good when we printed barcodes from local server.

Since we migrated to cloud server, same report, same data, report preview got a blank page.

--JN

[vitaly_izmaylov]

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.

[former_member1093627]

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.