Solved

Print report twice in Crystal.

Posted on 2004-09-27
5
1,221 Views
Last Modified: 2010-05-18
Dear all experts,

I have a database table (e.g. DN) for printing the Debit Note. In each row, DN will be printed twice. The only different between these DN is that 1 of them have a mark "COPY". How can I do so that I can print twice in each row. I don't know copy the section twice because the DN format is always change.

Thanks.

P.S. I am using Crystal Report 9
0
Comment
Question by:superleo
  • 2
5 Comments
 
LVL 100

Accepted Solution

by:
mlmcc earned 25 total points
ID: 12170399
I don't know of any way to easily print a row twice.  

Here is a method suggested in another ee question.  It requires a change to the database but it might be useful.  You would also need to add a column for the COPY text

http://www.experts-exchange.com/Databases/Crystal_Reports/Q_21133862.html

Another idea would be to create a report (detail section only) for the information.  You could then include it twice in the main report as subreports.  This way you only have to change the report once when the DN format changes.

mlmcc
0
 
LVL 42

Assisted Solution

by:frodoman
frodoman earned 25 total points
ID: 12178549
I had this exact requirement in the past (for printing invoices).  I created my basic invoice report first and saved it twice - once named original and once named copy.

Open original and in the report footer insert 'copy' as a subreport.  This gives you 2 reports that are indentical but run together.  Now you can edit the subreport to add the word copy or whatever other changes might be needed.

This is similar to mlmcc's second suggestion - I duplicated the entire thing instead of just the details though because I had to make a couple of other changes in my example.

HTH

frodoman
0
 
LVL 1

Expert Comment

by:dtaylor92
ID: 12467716
It all depends on the complexity of your report.

If all the data you need is in the detail section, then simply create multiple detail sections and duplicate the information.  You can print information as many times as you want to.  You can also go into the Section Expert and do things such as "new page after", etc.

Some folks aren't aware of how easy it is to create as many "detail sections" as you want... .detail a, detail b, etc. and you can format them to meet your needs.  If each invoice has to be own "detailed" report, then frodoman's idea would be the easiest.  The only downside is that you will have to hit the database twice.

If none of these answers seems to meet your needs, then let us know.  There might be other alternatives we could come up with using formulas and things like, Previous (fld), Next (fld), etc.
0
 
LVL 100

Expert Comment

by:mlmcc
ID: 13010224
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
   Split - dtaylor92 (12467716), frodoman (12178549), mlmcc (12170399)

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

mlmcc
Database Reporting Tools PE
0

Featured Post

Master Your Team's Linux and Cloud Stack

Come see why top tech companies like Mailchimp and Media Temple use Linux Academy to build their employee training programs.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
SSRS Row visibility 2 359
Sage 100 Business Intelligence 2 148
Datawarehouse Design - how to avoid Snowflake structure 3 70
Excel 2013: Displaying times in Milliseconds 6 208
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.
I recently went through setting up a JasperReports Server using the AWS EC2 instance, and this article will cover some basic administration tasks I had to perform.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

773 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