CR and Labels [RESOLVED]

Well I just purchased the latest CR and I have a question.

I am developing a program in vb2005 that will print some labels.

I used CR Mailing Label report wizard to make a custom label there will be 5 labels on one sheet. I would like to know how i print to maybe just the 3rd label in the row.

What i am trying to achieve is if the user did not print a full sheet of labels I want them to be able to select where to start on the sheet so that they labels are not wasted.

Thanks

Could you add blank records to your datasource temporarily?

Quote:

---

Originally Posted by Besoup

Could you add blank records to your datasource temporarily?

---

That could be an option. I might have to experiment around with that.

Thanks

Another option.

Add a parameter to the report which indicates the Record/Label # where printing will begin.

Instead of printing the database fields directly, create a formula for each field. Each Formula returns either an empty string or the database field, depending on the record #. Eg.

Code:

---


IF RecordNumber < {?StartLabel} Then
  ""
Else
  {Customers.Address}

---

Bruce, wouldn't that skip some records from being displayed?

Yes, you are correct. You don't want to skip records just labels. Not sure what I was thinking with that solution.

I am pretty content with the blank records, that should fit my needs very well. Thanks for all help.

Hi Guys -

I have the same question, but my label design includes a picture.

Using the above method, how can I suppress the picture if the field is blank?

Thanks!:wave:

Quote:

---

Originally Posted by Set me As newtype

Hi Guys -

I have the same question, but my label design includes a picture.

Using the above method, how can I suppress the picture if the field is blank?

Thanks!:wave:

---

You should be able to right click on graphic and choose format graphic.
Click the common tab and you will see something that says Suppress.

To the right of that you can click on the formula editor to add some condition.

I'm using crusty old ver. 4.6.... Don't have all those options!:eek2:

The best I seem able to do is place a field over the graphic with white Fill and Font colors. The field's Format Field box contains an option to "Suppress if Blank" option.

At least this way, I can write something to the field and the graphic is covered with white (same as invisible) for blank labels. For labels I want to Print, I leave the field blank and the graphic shows through.

It's a hassle, but there may be no easier way with my stone age ver. of CR...?:rolleyes:

Thanks for the help!:thumb: