Mail Label - how to select label to start 1

[goolawah]

I am printing some mailing labels using a 2 x 7 label format on an A4 sheet. All works fine, but occasionally I have to print a single label and have been trying to figure out a way of defining which label to start printing so I can skip labels that have already been used and removed. This avoids wasting a whole sheet of labels.

Avery Design pro allows this flexibility, but I can't generate the content needed on the label. Crystal X does a great job with the content, but I can't find a way to set the starting label position.

Any suggestions appreciated.

 

[dgillz]

If you start at label 11, for example, you need to generate 11 identical labels, but then suppress the fields in the first 10 labels.

Are you familiar with how to generate X number of labels?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"What version of URGENT!!! are you using?

 

[goolawah]

No. I've been trying, unsuccessfully so far, to do something like that. I can't figure it out. I'd appreciate some input.

 

[kpereira]

I have a suggestion. If you create a parameter to have the user enter the label number, go to the section expert for the detals and click on the formula for "Next Page after" and add something like this

Remainder (RecordNumber,cdbl({?001_ROT_LabelNum})) <> 0

As long as you don't use multiple detail lines it should move you to the next page of labels.

Karen Pereira

 

[lbass]

If you have a version that allows commands, create a command as your datasource like the following. In the command window, create a parameter LabelNo and then enter:

Select Customer.`Customer Name`,
Customer.`Address1`,
Customer.`Address2`,
Customer.`City`,
Customer.`Postal Code`
From Customer
Union All
Select Null,Null,Null,Null,Null
From Customer
Where {?LabelNo} >= 0

Go to report->sort records, and choose {Customer.Customer Name} to force the nulls to sort first. Then go into the section expert and select each detail section->suppress blank section->x+2 and enter:

recordnumber > {?LabelNo}

-LB

 

[lbass]

A note of clarification. If the prompt text is:

"Leave how many labels blank at the beginning?"

...the suppression formula on each detail section should be:

recordnumber > {?LabelNo}

If the prompt text is:

"Start printing on what label number?"

...the suppression formula on each detail section should be:

recordnumber >= {?LabelNo}

You could add to the prompt text the range of labels to start on (depending upon the label template chosen), e.g.:

"Start printing on what label number? (1-30)"

You might also want to add in whether the layout is "down then across" or "across then down". This method works regardless, but if users are trying to use up partially used label sheets, the layouts have to match.

-LB

 

[IdoMillet]

Just a note about the "UNION ALL" approach. You can include the sort right inside the command. Just add "ORDER BY 1" to the end of the SQL statement. This indicates that you wish to sort the result set by the first column.

- Ido

view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[lbass]

Ido,

Thanks for that addition. I had forgotten you could do that.

Select Customer.`Customer Name`,
Customer.`Address1`,
Customer.`Address2`,
Customer.`City`,
Customer.`Postal Code`
From Customer
Union All
Select Null,Null,Null,Null,Null
From Customer
Where {?LabelNo} >= 0
Order by 1

-LB

 

[raugi]

I'm trying to do the same thing that is described in this thread. I've added what you suggested and it's not working.

Are you using this command as the only datasource?

When I tried this I had already written my report by adding all the tables required, and am now trying to add a command. Will the 2 work together or is it one or the other?

and if so, is there another way to do this, or do i need to switch the entire report to work off of a command?

 

[lbass]

This is intended for a label report. The command is the entire datasource, yes. It's not a good idea ordinarily to link a command to other tables, as it dramatically slows reports. In this case, I think it is a definite no, if you want the command to work properly and the report to start on a specific label.

-LB

 

[raugi]

I'm referring to the same report I am working from thread767-1439697.

Is there no other way to get this same result without using the command?

 

[lbass]

Why not go to database->show SQL query and copy the resulting query. You can then paste this into a command in a new report, and add the union with the nulls and parameter, etc. For a label report, there isn't that much work to recreate the label itself.

-LB