Solved

Crystal layout design

Posted on 2013-05-31
11
411 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 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
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:Star79
ID: 39217338
The size of the labels are:
4-inch by 3-inch.
0
 
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

Enroll in May's Course of the Month

May’s Course of the Month is now available! Experts Exchange’s Premium Members and Team Accounts have access to a complimentary course each month as part of their membership—an extra way to increase training and boost professional development.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Mask on Parameter CR2008 28 77
Crystal Report for VS2013 17 189
Help with a Crystal Report Formula - remove time 5 35
Trendline on Charts in Crystal Reports 2013 4 27
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
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.
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…
I've attached the XLSM Excel spreadsheet I used in the video and also text files containing the macros used below. https://filedb.experts-exchange.com/incoming/2017/03_w12/1151775/Permutations.txt https://filedb.experts-exchange.com/incoming/201…

738 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