Jacques Smith
asked on
Crystal Reports Printing Multiple Copies
I have an Invoice in Sage300 that I want to print multiple Copies of as a default. It is a ODBC Report with Sub Reports in it.
AS I am printing directly from Sage300, I am not able to pass any Parameters, and need the report itself to produce 2-3 Copies
AS I am printing directly from Sage300, I am not able to pass any Parameters, and need the report itself to produce 2-3 Copies
ASKER
I am using Crystal Reports 2011
Version is not an issue. To the best of my knowledge no version has the an option for copies.
mlmcc
mlmcc
ASKER
mlmcc
Unfortunately, the Sub-Reports need to be there.
Is there no way, that I can create another table in the Database, with 3 records numbered 1,2 and 3, and get it print while the numbers are not up to 3, or creating a memory variable
Unfortunately, the Sub-Reports need to be there.
Is there no way, that I can create another table in the Database, with 3 records numbered 1,2 and 3, and get it print while the numbers are not up to 3, or creating a memory variable
There is no way for Crystal to do anything like that. Generally that is solved wither through the subreport method or through an application that prints the report N times or that can tell the printer to create N copies.
When the user prints do they get a printer dialog?
Can they specify the number of copies there in the printer dialog?
mlmcc
When the user prints do they get a printer dialog?
Can they specify the number of copies there in the printer dialog?
mlmcc
One idea I just had using your extra table would be to add it and cross join to you data table. You would then get 3 copies of the data. If you added a group on the new field you could get 3 copies that way.
Just make sure the group header is suppressed and there is a NEW PAGE AFTER set on the group footer.
mlmcc
Just make sure the group header is suppressed and there is a NEW PAGE AFTER set on the group footer.
mlmcc
ASKER
I did try that, but thought that maybe I am missing a trick.
I placed the "PageNo" field in the Report Header of the report, When you say "group on the new field ", could you go into a bit more detail Please.
The Report Header is suppressed, and there is a New Page after set on the Group footer
I placed the "PageNo" field in the Report Header of the report, When you say "group on the new field ", could you go into a bit more detail Please.
The Report Header is suppressed, and there is a New Page after set on the Group footer
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thank you Very Much, It works perfectly, my problem was not making it the first group in the report
If the report doesn't have a subreport then you could use it a subreport in a new main report.
Basically you could put the report in as a subreport in the report header and footer to have 2 copies. To get more than 2 just add report headers and footers and add the subreport in again.
mlmcc