Solved

Crystal layout design

Posted on 2013-05-31
11
404 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
Comment Utility
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
Comment Utility
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
Comment Utility
What do you mean?

WHat size are the lablels?

mlmcc
0
 

Author Comment

by:Star79
Comment Utility
The size of the labels are:
4-inch by 3-inch.
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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
Comment Utility
what can be done if there 2 detail section details a and details b
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
What is in each detail section?

mlmcc
0
 

Author Comment

by:Star79
Comment Utility
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
Comment Utility
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

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Problem Statement In an SAP BI BO Integration project when a BO universe is built on a BEx query, there can be an issue of unit & formatted value objects not getting generated in a BO universe for some key figures. This results in an issue whereb…
Hi, I am very much excited today since I'm going to share something very exciting Tool used for Analytical Reporting and that's nothing but MICROSTRATEGY. Actually there are lot of other tools available in the market for Reporting Such as Co…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…
When you create an app prototype with Adobe XD, you can insert system screens -- sharing or Control Center, for example -- with just a few clicks. This video shows you how. You can take the full course on Experts Exchange at http://bit.ly/XDcourse.

744 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

13 Experts available now in Live!

Get 1:1 Help Now