Generically, if you have 1 report and you want to hit print and have it print 2 copies with different footers, you would need to figure out a way to create a report that is really both pages that you want.  CR will only print/display what is in the report.

The issue is, Crystal will only print the rows in the dataset, 1 time, so you are looking for a mechanism for Crystal to create 5 datasets so that it can see them and print them.  If you go the data from a stored proc, you could  create a column in the dataset and use this column to drive the different copies, and hence get the 5 'copies' into 1 report, but joining straight to the tables...subreports would be the best bet...but I don't think it will be as straight forward...also performance will be worse as there will be more hits to the database, not too many (at least 5) could be worse.

 

The stored proc approach would be a better solution....but all my reports use stored procs....

 

HTH