Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Crystal Reports - Mailing labels - Start printing on x,y label

Status
Not open for further replies.

WaukMyWay

Programmer
Apr 20, 2007
29
US
Does anyone know if, in CR10, you can get two parameters for the x(row) and y(column) positions of labels to start printing at?
We all know we can print a bunch of labels on a sheet, but sometimes not all labels are used. Is it possible to start the next batch to print on the first sheet, but to start on a different label on the sheet?
If this is possible, where can I get a full example (especially if this requires arrays, with I have not worked with yet)?
 
Maybe the better question is the following:
Can I force the RecordNumber to be 1 when the following is set?
In another attempt, I have set up no command in the database. I have a parameter for finding what label to start printing at, StartAtLabelNo. In a formula, named, LabelCounter, I add 1 for each label on a sheet, which will be going from 1-3 across and 10 down, for a total of 30 labels on a sheet.
Printing consists of the customer name, address1, city, region, and postal code, of which printing is determined by this test on the field's Format Editor for Suppress: PageNumber = 1 and {@LabelCounter} < {?StartAtLabelNo}.
Also, in the same area as the regular data, I have blank text boxes to use for the labels that should not print anything with the following test, also in the field's Format Editor for Suppress: PageNumber = 1 and {@LabelCounter} >= {?StartAtLabelNo}.
When I preview, say for StartAtLabelNo = 4, the first three labels have no data, but the 4th label contains RecordNumber 4 data. Is it possible to force the RecordNumber to 1 when it reaches label #4?
 
My method is the only one I know of that works. You are not implementing it correctly. The fact that your SQL query shows two separate sections tells me that you ALSO added a table to your report. You should ONLY be using the command--no tables. I don't see anything in the query about the part number range, and in fact, this looks to me like it is the Xtreme database. Are you trying to test this with the Xtreme database first?

If you are using the Xtreme database, you can see that this works if you start a new label report, enter the command in the command area and then follow the earlier instructions.

-LB
 
Sorry about that. My initial project is with a part master. The user needs to print a range of parts and be able to start printing at the first available label on the sheet.
As for your example, I started over again, but did NOT select the Customer Master AND create the command. It still does not work.
 
Well, I finally got it to print at the correct label, but it does not print the first record.
What am I still doing wrong?
 
You will have to recount exactly what you did for me to assist.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top