How to duplicate report in Crystal reports?

Question

I am having a Report for receipts where needs to be duplicated at the bottom,

• If there 6 records for report, 3 records should be shown in the first page top and duplication of that 3 records will be shown in page bottom

• From Record 4 to 6 will be shown in next page, where as same records has to be duplicated in bottom of second page.

I have created a sub report from original report and linked.

01.I Checked "Select data un subreport based on field"

Since its at the page footer, it only pass last record of page where i need all 3 records. apart from that paging works correctly.

Please refer following screenshot of first 2 pages.

Full Image : https://i.sstatic.net/23Z2J.png

02.I unchecked "Select data un subreport based on field", but it shows same 3 records in each page in sub report

Full Image : https://i.sstatic.net/2l7HA.png

Answer 1

First suggestion would be don't place sub report in report footer but instead place in page footer. If this doesn't work then follow below process.

If your requirement is only 3 records then I would suggest not to go with sub report instead you can follow below process.

1. Place 3 rows in page footer.
2. From detail section store all rows as arrays in variables.
3. Now extract the values from variables page to page and display those in page footer

To store in array follow below process: 1. Create a formula and write below code.. I am giving for on column extend it for other columns aswell.

Shared String VarArray abc;

Abc=abc+Student number <<This is the student number field coming from database>>

Place above formula beside student column in detail section

Now to go to page footer. In first formula write below code.

Share String VarArray abc;
abc[1];

similar way writer for other formulas aswell

reset the abc at the end of all formulas.