Solved

Crystal layout design

Posted on 2013-05-31
11
407 Views
Last Modified: 2013-06-27
Hello All,
Please find attached how the report has to be printed on a Drug label.
The printing paper would be the size as in the screenshot so the report that I have to develop will be printed on the paper size as in the screenshot.
Please advice how it can be done.Iam using crystal 2008.
Thanks.
label.gif
0
Comment
Question by:Star79
  • 5
  • 4
11 Comments
 
LVL 100

Expert Comment

by:mlmcc
ID: 39212324
You can control the size of the report through the page size you set.

Do you use a standard label from Avery?

Check the PRINTER SETUP

mlmcc
0
 

Author Comment

by:Star79
ID: 39217094
Hello mlmcc,
is there a way that on a particular label I be able to print only 5 drugs.
Thanks.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39217171
What do you mean?

WHat size are the lablels?

mlmcc
0
 

Author Comment

by:Star79
ID: 39217338
The size of the labels are:
4-inch by 3-inch.
0
Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

 
LVL 100

Expert Comment

by:mlmcc
ID: 39217411
One way would be to use a variable to count the records and use the NEW PAGE AFTER the when the count is 5

mlmcc
0
 

Author Comment

by:Star79
ID: 39223725
what can be done if there 2 detail section details a and details b
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 39236619
What is in each detail section?

mlmcc
0
 

Author Comment

by:Star79
ID: 39238743
Hello Mlmcc,
Please find attached the screenshot of the layout.
The report should print only 5 rono in the detail section
screenshot.gif
0
 
LVL 100

Accepted Solution

by:
mlmcc earned 500 total points
ID: 39239264
Try this

In the report header and group header add a formula
WhilePrintingRecords;
Global NumberVar RecordCount;
RecordCount := 0;
""

In Details A add a formula
WhilePrintingRecords;
Global NumberVar RecordCount;
RecordCount := RecordCount  + 1;
""

In the section expert
Select DETAILS B
Click the formula button to the right of NEW PAGE AFTER
WhilePrintingRecords;
Global NumberVar RecordCount;

RecordCount  MOD 5 = 0

mlmcc
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Crystal Report Error 14 72
Crystal Reports 11 Ignoring Parameters 3 68
Tools to Output documents from DB based on selections 8 111
Pull date to Group header 6 26
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
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…
Hi friends,  in this video  I'll show you how new windows 10 user can learn the using of windows 10. Thank you.

920 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