Crystal Report 2 copies of page 1

pauls681
pauls681 used Ask the Experts™
on
Crystal Reports 11:
We have a 6 page report that prints out.
We need page 1 to print twice.
Whats the best way to accomplish this?
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
What is page 1?

The only way I can think to do that is to put the information in a second time.  Assuming it is basically information not related to records in the database it should work.

mlmcc
Assuming the page is made up from several report sections, I can't see any alternative to using a subreport which just produces the first page.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Agree.  If page 1 has anything other than basic boilerplate then a subreport is really the only way you can do it.

mlmcc
Amazon Web Services

Are you thinking about creating an Amazon Web Services account for your business? Not sure where to start? In this course you’ll get an overview of the history of AWS and take a tour of their user interface.

Commented:
I think it can be done in another way. with running total fields, but you have give some for info for that.

basically, you add a an extra field of what you want to show, add a running total on that field, which counts how many times it is shown and than supress the field when running total <>2.

but first explain yourself some more.

Author

Commented:
It is a Work order packet. The first page lists the material that will be used for that order.
We want the first page to print twice.
There are 2 sub reports on this Page.
These reports are for our ERP system called Sage X3 and are quite complicated.
I tried just copying the data on the first page twice but I get errors from our ERP system. It looks like its looking for more parameters which are called out in the 2 subreports.
This may be over my head.
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Is page 1 in the main report header?
Is it only showing the 2 subreports?

mlmcc

Author

Commented:
Everything in page one is in  Group Header 1a.
Is there any way to print the Group Header twice?
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
No, but you could add GH1b and put the same things in it.

mlmcc

Author

Commented:
I finally was able to get the 1st page to print twice. The 2 subreports embedded in that page made it difficult.
I added GH1b as a report header and copied GH1a

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial