Solved

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

Posted on 2013-12-04
9
1,358 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
LVL 4

Author Comment

by:g_johnson
ID: 39698561
Thanks -- I'll see if I can follow that discussion!
0
 
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

NAS Cloud Backup Strategies

This article explains backup scenarios when using network storage. We review the so-called “3-2-1 strategy” and summarize the methods you can use to send NAS data to the cloud

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

If you're writing a .NET application to connect to an Access .mdb database and use pre-existing queries that require parameters, you've come to the right place! Let's say the pre-existing query(qryCust) in Access takes a Date as a parameter and l…
Microsoft Reports are based on a report definition, which is an XML file that describes data and layout for the report, with a different extension. You can create a client-side report definition language (*.rdlc) file with Visual Studio, and build g…
Established in 1997, Technology Architects has become one of the most reputable technology solutions companies in the country. TA have been providing businesses with cost effective state-of-the-art solutions and unparalleled service that is designed…
Email security requires an ever evolving service that stays up to date with counter-evolving threats. The Email Laundry perform Research and Development to ensure their email security service evolves faster than cyber criminals. We apply our Threat…

778 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