on 04-21-2008 6:44 AM
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)
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.