cancel
Showing results for 
Search instead for 
Did you mean: 

Limiting the no. of records(10 per page), while printing records twice on the page

Former Member
0 Kudos

Post Author: garnettk

CA Forum: Crystal Reports

hello all. I have an urgent question that I need to solve in my project.

I want to display duplicated invoice (print same thing on both upper and lower section in a page, as dig.1 below... both RECORD 1-10 are print twice)

However, I want to print RECORDS which are more than 10 in next page.

So RECORD 11-20 will be printed in page2, RECORD 21-30 in page 3.

How and where should I put the main report and sub-report?

Now I put 2 subreports in group footer(I know it shouldn't be correct but I am desperated).

Would you please help me in this case? Thanks a lot

My report: http://homies.com.mo/Invoice.rpt

dig.1 (page1 first 10 records)

dig.2 (new page after 10 records)

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Post Author: AJDuck1

CA Forum: Crystal Reports

Thats a hard one.

Try creating a union view which includes the following columns..

MyView(SELECT id, description, 'ResultsA' AS Expression0, id UNION ALLSELECT id, description, 'ResultsB', AS Expression0 id ) ORDER BY id

Then in crystal reports you will need to group Expression0 and simply put formula based page break on GROUP1 using the selection expert and your crystal formula should look like this...

IF Expression0 = 'ResultsB' then true else false.

That should do the trick, with out implementing a MOD field/formula, you may see speed trade-offs since views select all the results even if you pass it a where statement.