×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Mail Label - how to select label to start

Mail Label - how to select label to start

Mail Label - how to select label to start

(OP)
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.

RE: Mail Label - how to select label to start

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
www.gainfocus.biz

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

RE: Mail Label - how to select label to start

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

RE: Mail Label - how to select label to start

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

RE: Mail Label - how to select label to start

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

RE: Mail Label - how to select label to start

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

RE: Mail Label - how to select label to start

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.
www.MilletSoftware.com

RE: Mail Label - how to select label to start

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

RE: Mail Label - how to select label to start

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?

RE: Mail Label - how to select label to start

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

RE: Mail Label - how to select label to start

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

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login


Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close