asked on

Crystal Report Labels starting point on page, VB.Net, VS 2012

Using VB.Net in Visual Stuido 2012, we have a need to call a Crystal Report that prints labels. These labels are a 2 x 6 layout on 8 1/2" by 11" laser printer paper. It is desirable to choose which label to start with. For example, start in row 3, column 2 and print 17 labels (which will "bleed" onto the next page).

How would one accomplish this?

Mike McCracken

It is possible. There used to be an example on the Crystal site showing how to do it. I will try to find it.

mlmcc

g_johnson

ASKER

That would be great -- thanks.

ASKER CERTIFIED SOLUTION

Mike McCracken

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

g_johnson

ASKER

Thanks -- I'll see if I can follow that discussion!

Ido Millet

How about inserting blank Detail a, Detail b, Detail c... sections (as many as the maximum number of "skips" you need. You can then Un-suppress as many as you need based on the parameter. In the N'th section, the suppress condition would be:
{?Number_of_Labels_to_Skip} < N

So, for Detail b, the suppress expression would be {?Number_of_Labels_to_Skip} < 2

Mike McCracken

That works except he has 2 columns so unless the report can skip a full row a label may get missed.

mlmcc

Ido Millet

I'm not sure I understand the last comment. If you mean the printout may contain more than one record, then add a condition to always suppress the blank sections on 2nd record and above. So:

(NOT OnFirstRecord) OR ({?Number_of_Labels_to_Skip} < N)

Mike McCracken

No, I mean he has 2 columns so he may want to start printing in the right column rather than skipping over it. Printing blank sections will skip the label in the right column.

mlmcc

Ido Millet

Didn't notice the multi-column layout stipulation. Indeed, as pointed out by mlmcc, extra detail sections would not work in this case.