Crystal reports 8.5 How to print different text on bottom of each copy

[argusdan]

I am using Crystal Reports 8.5
I am designing an Order form to print 4 copies. The detail section data is the same for each copy. I want to print different info on the bottom of the form for each copy, for example copy 1 will say office copy and have a number of check boxes etc. the second copy may say “Customer copy” with different info etc.

My question is How do I get the different info to print on the bottom of each copy of the form.
I don’t see anywhere in Crystal where I can tell it for example “If this is copy 1 then print “this” data.

 

[synapsevampire]

Crystal doesn't work like that.

If you're asking Windows to print 4 copies of something, then it assumes that you mean it, not that you want 4 different things.

4 copies of what, a 1 page Order, or are there multiple pages?

On trick is to insert multiple sections in the report, with new page afters, and then paste in the next page, etc, and conditionally suppress based on the page number, such as:

pagenumber = 1

You can also use this for multiple page footer sections to determine what is printed there.

-k

 

[argusdan]

Thanks for the tip . This would work if the order was never more than 1 page long but sometimes it's one page, sometimes it's 2 pages or more.
I need to print 4 copies of it no matter how many pages there are. I want a different footer on each copy of the order. 1 copy goes to shipping with shipping instructions on the botton, 1 copy goes to the office etc.
We are upgrading our accounting system and are required to use Crystal for forms. Th old system used CA_Ret report writer and there was a built in function to do it.

Dan

 

[synapsevampire]

Sorry, you'll have to use external code for this.

-k

 

[lbass]

You could insert a group on {table.orderID}, assuming you want your report to show multiple orders, each with multiple copies. Save the report under another name and then insert it as a subreport three times. Place the subreports in three group footer sections (a,b,c). Format each group footer section with "New Page Before" and also on the last section check "Reset page number after". Then create a formula like the following and place it in the page footer (you could add your customized information in the formula, too):

if pagenumber <= totalpagecount/4 then "Sales Copy - Page No: "+ totext(pagenumber,0,"") else
if pagenumber <= totalpagecount/2 then "Customer Copy - Page No: " + totext(pagenumber - totalpagecount/4,0,"") else
if pagenumber <= 3*totalpagecount/4 then "Department Copy - Page No: " + totext(pagenumber - totalpagecount/2,0,"") else
"Manager Copy - Page No: " + totext(pagenumber - 3*totalpagecount/4,0,"")

For this to work properly, each subreport must be sized the same way as the main report, as the page footer text is based on evenly dividing up the totalpagecount for the order.

-LB