Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

To create multiple copies of the same data, e.g., on different pages.

Status
Not open for further replies.

gseales

IS-IT--Management
Aug 18, 2009
7
US
thread149-1068454
I thought that number 10(To create multiple copies of the same data, e.g., on different pages.) in lbass posting might apply to my problem.

I am looking to take a 2 part pre-printed form and print it on our laser printer. We are using Crystal Reports 10 for Sage. The problem I am looking to resolve is get a different header printed for each of the 2 part pre-printed form(i.e. WORK ORDER, PACKING LIST).

I tried creating a database with both "Work Order" and "Packing List" in it, then created a subreport in the .rpt file tied to the Header db. I want a page printed for each entry in the Header db.

Can anyone tell me how to do this or another way to accomplish this? Thanks in advance!
 
I'm unclear on whether you ONLY need to know how to change the header, or whether you are also asking how to repeat the data on each of two pages. To change the header, I think you could just use a formula for the heading, like this:

if remainder(pagenumber,2) = 0 then
"Packing List" else
"Work Order"

-LB
 
Yes, I want to repeat the data while changing the heading.

If the report is only 1 page long how do I make it do 2 duplicate pages for each original page printed. If the Work Order report is only 1 page long then when you print it do you then print 2 copies in order to get 1 page with "WORK ORDER" and a 2nd duplicate page with "PACKING LIST"? Also if a Work Order is 2 pages long I want to end up with 4 pages a "WORK ORDER" and "PACKING LIST" page for page 1 and 2.

Thanks again!
 
Assuming you have a group on work order, insert a subreport in a group footer_b section for the packing list. Add the heading "Packing List" to GF_a and format the GH_a section to "New page before." Format the GF_b to new page after. Use Group Header_a for the "Work Order" heading, with the data in GH_b and/or the details section. Don't use the page header at all.

-LB
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top