Solved

Crystal Report advancing to next label

Posted on 2014-04-17
13
255 Views
Last Modified: 2014-04-25
I have a Crystal Report that prints labels. The problem I'm having is that however many labels this report prints, when it has printed the last label, it will advance skipping an entire label before stopping. I have NO idea why this is doing what it's doing. This is a add-on to a previous post that has been resolved. I have attached the report. This CR prints to a "Zebra ZDesigner TLP 3842" thermal printer.
Label-Sens.rpt
0
Comment
Question by:BlakeMcKenna
  • 7
  • 6
13 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 40007516
Check the report

Make sure the report footer and page footer are suppressed and set to height of 0
Same for the report header and page header.
Same for any section that isn't used in the label.

Also check the printer to ensure it is set for the proper page size for the labels in use.

Crystal issues a form feed after the report is done.

mlmcc
0
 

Author Comment

by:BlakeMcKenna
ID: 40007585
Where do I check the height for the report/page footer?

Also, as far as the printers proper page size, is there a way to calculate it or do you just have to eyeball it?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40007668
You can't check the height directly.
In design view you can see how tall it is then hover the mouse over the bottom until it turns to an = then click and drag it up so it is visibly 0 height

You can add the size of a field in each section to see how "tall" you are printing
Right click a field
Click SIZE AND POSITION
You can get the height

Did you create the report?
If so did you use the LABEL wizard which allows you to set the formats of the label like size number per page etc.

mlmcc
0
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 

Author Comment

by:BlakeMcKenna
ID: 40007681
This is an existing report. I tried what you suggested and nothing seems to work.
0
 

Author Comment

by:BlakeMcKenna
ID: 40007894
How do you prevent a form feed after a report has printed?
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40007941
You can't so you have to make certain it is sitting at or above the top of the next label.  It may be it is not possible.

mlmcc
0
 

Author Comment

by:BlakeMcKenna
ID: 40008650
There has got to be a way to have the next label ready to print instead of skipping a label each time a report has completed.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40008948
DO you have NEW PAGE BEFORE or AFTER set for any section?

mlmcc
0
 

Author Comment

by:BlakeMcKenna
ID: 40008976
Yes, in fact the "Report Header", "Page Footer" and "Report Footer" are all checked but they are also grayed out and I'm not sure how to reverse that. See attachment!
Screenshot.jpg
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 40009081
Those can't be changed.

I thought if one of the other sections had it, then the one on the report footer was causing the issue

mlmcc
0
 

Author Comment

by:BlakeMcKenna
ID: 40009188
I have looked on the Printer Settings dialog and can't find anything about a Page Eject...
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 40009206
I added this to your other question by mistake

I assume this is the same label as your other question.

I took a look at it.  I found a couple of potential issues.

1.  There are sections with extra space.
2.  A couple of the items seem to go off the right side of the label

I fixed what I could.  You will need to set the printer and page size since I don't have that printer installed and it change to letter paper when I made changes.

mlmcc
Label-Sens--1-.rpt
0
 

Author Comment

by:BlakeMcKenna
ID: 40009251
I just answered your other question...haha! Unfortunately, the changes didn't work. I really dislike Crystal Reports!
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

It’s quite interesting for me as I worked with Excel using vb.net for some time. Here are some topics which I know want to share with others whom this might help. First of all if you are working with Excel then you need to Download the Following …
Parsing a CSV file is a task that we are confronted with regularly, and although there are a vast number of means to do this, as a newbie, the field can be confusing and the tools can seem complex. A simple solution to parsing a customized CSV fi…
This video shows how to quickly and easily add an email signature for all users on Exchange 2016. The resulting signature is applied on a server level by Exchange Online. The email signature template has been downloaded from: www.mail-signatures…

830 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question