Solved

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

Posted on 2013-12-04
9
1,343 Views
Last Modified: 2013-12-12
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?
0
Comment
Question by:g_johnson
  • 4
  • 3
  • 2
9 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39695703
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
0
 
LVL 4

Author Comment

by:g_johnson
ID: 39695712
That would be great -- thanks.
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39697437
The solution relies on a SQL Command to create dummy records and to pull in your data. The idea is that the user will use a parameter to choose the starting label position.

Here is a link to a complete discussion
http://scn.sap.com/thread/1801734

mlmcc
0
 
LVL 4

Author Comment

by:g_johnson
ID: 39698561
Thanks -- I'll see if I can follow that discussion!
0
Top 6 Sources for Identifying Threat Actor TTPs

Understanding your enemy is essential. These six sources will help you identify the most popular threat actor tactics, techniques, and procedures (TTPs).

 
LVL 22

Expert Comment

by:Ido Millet
ID: 39704843
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
0
 
LVL 100

Expert Comment

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

mlmcc
0
 
LVL 22

Expert Comment

by:Ido Millet
ID: 39705242
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)
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39705440
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
0
 
LVL 22

Expert Comment

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

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Introduction As chip makers focus on adding processor cores over increasing clock speed, developers need to utilize the features of modern CPUs.  One of the ways we can do this is by implementing parallel algorithms in our software.   One recent…
1.0 - Introduction Converting Visual Basic 6.0 (VB6) to Visual Basic 2008+ (VB.NET). If ever there was a subject full of murkiness and bad decisions, it is this one!   The first problem seems to be that people considering this task of converting…
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now