?
Solved

Crystal layout design

Posted on 2013-05-31
11
Medium Priority
?
416 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 5
  • 4
11 Comments
 
LVL 101

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 101

Expert Comment

by:mlmcc
ID: 39217171
What do you mean?

WHat size are the lablels?

mlmcc
0
 [eBook] Windows Nano Server

Download this FREE eBook and learn all you need to get started with Windows Nano Server, including deployment options, remote management
and troubleshooting tips and tricks

 

Author Comment

by:Star79
ID: 39217338
The size of the labels are:
4-inch by 3-inch.
0
 
LVL 101

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 101

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 101

Accepted Solution

by:
mlmcc earned 2000 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Hi, In my previous Article  (http://www.experts-exchange.com/Database/Reporting/A_15199-Introduction-to-Microstrategy.html)I discussed some basic understanding of Microstrategy that how we can get in Intro of Microstrategy (MSTR). Now it's tim…
Today, still in the boom of Apple, PC's and products, nearly 50% of the computer users use Windows as graphical operating systems. If you are among those users who love windows, but are grappling to keep the system's hard drive optimized, then you s…
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…

800 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