Invoice footers

[bijondhanbad]

I want to have different footers in different copies of the same page. Like while printing an invoice, I want CUSTOMER COPY on one copy, SELLER COPY on the second copy, OFFICE COPY on the third copy of the invoice.

Attaching a part of the database.

You can use the rptSalesInvoice to open the report. Put a challan no as 003 & try out. The invoice can be previewed. Now I want three copies of the same page one with footer Customer copy, the other with Seller Copy as footer and the last as Office Copy as footer.

How do I do it?
Will someone help..

Regards,
Bijon

 

[ted.martin]

One way would be to cycle print the report 3 times and using a variable, change the footer e.g.

Create a Public Variable strFooter
Put a command button on a form or just call the following Function

Dim iCount as Integer
For iCount = 1 to 3

Select Case iCount

Case 1
strFooter = "Customer"

Case 2
strFooter = "Office"

Case 3
strFooter = "Seller"

end select

Next i count


In the report put me.textA = strfooter

 

[bijondhanbad]

Still not getting it.
Pl help

 

[bijondhanbad]

Request Brianwarnock to please try and help me out.

regards
bijon

 

[Villarreal68]

Another Example...

Here is another example on how to do this. It may help you...

http://www.thescripts.com/forum/thread193411.html

Read on it and see if you can figure it out!

René

 

[bijondhanbad]

Thanks Rene

I tried it out. Used a command button to render printing of the report after incorporating the changes as mentioned in that link. No doubt it is printing three copies but eah time it is giving the same footer - "Customer Copy".

Please help me out if u have any other way.

Regards
bijon