Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display 2 identical pages on a single crystal report 8.5

Status
Not open for further replies.

luminous1975

Programmer
Nov 18, 2004
4
US
I need to display a report (Voucher) which should have two copies...both would be identical except that the second page would have COPY printed on it.
In short display 2 identical pages on a single report.
Please tell me how to go abt it!
 
Here's one way of doing this:

Add a table to your database that has a single column ("Which_One") with 2 rows:

Which_One
Original
Copy

Include that table in your report (without any joins).

Each record in your report will no be repeated twice, once with the "Which_One" column of "Orginal" and once with the "Which_One" column of "Copy"

Cheers,
- Ido

CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.
 
You could also do it programmaticallly, if so inclined. And you wouldn't need to restructure your linking. If interested, post your development environment.

For example, if you're using VB6 with the RDC, you can do it like this:
1) Add a formula field to the report called 'Copy', and give it the text of "". Place it on the report wherever you want it to print.
2) When you print the report, you can call the PrintOut method twice, setting the text of the formula to 'COPY' the second time:
[tt]
Report.PrintOut True, 1
Report.FormulaFields.GetItemByName("Copy").Text = "'COPY'"
Report.PrintOut True, 1
[/tt]
-dave
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top