CR and Labels [RESOLVED]

[melvin74]

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

[Besoup]

Could you add blank records to your datasource temporarily?

[melvin74]

Could you add blank records to your datasource temporarily?

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

Thanks

[brucevde]

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.

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

[Besoup]

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

[brucevde]

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

[melvin74]

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

[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!

[melvin74]

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!

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.

[Set me As newtype]

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

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...?

Thanks for the help!