Multiple copies

[dmack]

Q? I have a report that draws from a SQL table. I can enter a value in the SQL table that will allow me to print multiple copies of the report when it is called. What I would like is to have different data on the report when the second copy of the report is printed. What is the syntax I use to hide or show these formula and db fields on the report when the page being printed is the second copy?

Help is appreciated. [sig][/sig]

 

[kenhamady]

I am not sure how the SQL table entry affects the report, but I assume that it is setting the "Number of Copies" setting in the print window.

If that is the case, Cyrstal's formula language doesn't have anything that responds to copy number (like they do for page number or record number). With the setting "number of copies" the assumption is that the copies are identical.

You can run a second, slightly different report as a subreport.

You might even be able to have every record generate two similar, but slightly different pages, by splitting the detail band into A and B, But I don't think you can base it on the number of copies. [sig]<p>Ken Hamady-

http://www.kenhamady.com<br><a

href=

http://www.kenhamady.com/>Crystal

Reports Training by Ken Hamady</a><br>[/sig]