Is there a way to tell Crystal what label to start printing at? 2

[iannuzzelli]

I am trying to create a label generator for a particular application. Unfortunately if I use standard avery laser labels then my customer will need to print entire sheets at a time and waste unused portions. I would like to be able to tell crystal what label to start printing at.

Is this possible? Does anyone know of an easy solution?

Thanks for any help.

 

[synapsevampire]

I use to cheat this by generating empty rows in the data.

Simple to do with a Stored Procedure, so if you can take that approach, that's the easiest.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[iannuzzelli]

Thanks for the reply. You state a good idea I will research others before I make my decision.

 

[dgillz]

SV,

Very nice. I have never thought of this. Software Sales, Training and Support for Macola, Crystal Reports and Goldmine
dgilsdorf@mchsi.com

 

[synapsevampire]

Thanks, dgillz.

We used to print > 100K laser labels per month, at that scale you give it fair consideration.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[iannuzzelli]

I filled a temp table with blank rows in front and it worked great. The only problem I had at first was developing the logic to know how many blank records to insert. Now everything works great no matter what type of labels are being used. Of course a report needs to be created for each type of label but if I can give my customer a choice of 3-5 they will be satisfied. They will then input the row and column to start printing on.

Here is the math to decide how many blank records to insert.

SR-> Select Row to start
SC-> Select Column to Start
NC-> Number of columns in sheet of labels


((SR-1)* NC) + (SC-1) = Number of Blank Records

This may help others dealing with this issue.