How do I force a number of records to print on the next page? Mainly I would like to know how to do this with a subreport. For example, I want to display only the first 7 records on page one and force the remaining onto page two. Please advise in detail! I appreciate it.
As I understand you would like to display some records on a new page. Ex if you have 20 records; you would like to have 10 records on page 1 and remaining on page 2.
Steps:
-Go to select expert
-Details
-Enable new page after checkbox. Click on the formula button besides it.
Okay well I realized what my problem was - I had a subreport on my page header and Crystal doesn't like the "force print on next page" I suppose when in the header.
Now that I have the Next Page formula working, I'm not sure it is the fix I need: everything in the report must fit in its exact spot. When I force records to print on a New Page, they do not fall in the right place vertically, if this makes sense.
Because all my data is returned in Subreports, the entire report is build in the Group Header #2 (Group #1 is Account number, Group #2 is Building number).
For example, on the upper left side of the page there are 4 subreports all in-line vertically. If subreport #1 and subreport #2 both are forced to print on the next page, they overlap each other.... Maybe I need to add each subreport in a separate section - would it work if I made additional Group Headers for group #2?
1) Moved "graphics" to Page Header - Underlay Following Sections (this contains all the boxes, lines, etc that the subreports fit into - you know, the stuff to make it look good!)
2) Inserted several sections below Group Header #2.
3) Moved one subreport to each new section, placed so that it will appear where it should in relation to the "boxes, lines, etc" in the page header.
4) This method works fine until you force one of the subreports to print on a new page after, say, line 12: what happens now is instead of the remaining 13+ lines printing where the original 12 lines of the subreport printed, the additional lines print at the very upper-left hand corner of the page, outside of the box it should (and originally did) appear in.
This is proving to be very frustrating. I KNOW it can be done because I am rewriting this report, and the original report that is currently hard-coded into our system displays these subreports the way I want them to be.
I tried eliminating the subreports all together, but combining 20+ databases is too hefty. I also tried re-writing the SQL query MANY different ways, but the results set is always in the tens of thousands, causing this report to run extremely slow - the hard coded report does NOT run this slow.
I also tried moving the subreports to the Details section, but then each subreport prints several times!
Please, please... someone has to have some insight!!
Thanks, but I FINALLY figured it out. I'm not sure how to place screen shots yet...
In case anyone might be able to decipher my ramblings, here's my problem/solution:
Problem:
I have several sub reports stacked vertically and can only grow to a certain size. Since you can't limit how many lines the sub reports can grow in Format Subreport, I had to limit that within each sub report. As a few examples, each sub report can only display the following amount of lines:
Sub report 1 = 13
Sub report 2 = 8
Sub report 3 = 5
Sub report 4 = 2
Sub report 5 = 8
Limiting the number of lines each sub report can grow keeps them from 'overlapping' or 'running over' each other, since they are in the same section and vertically aligned. However, in the instances where there are MORE lines of data than can be returned, I need to display those on the following page, again without the sub reports overlapping each other (the second page of a sub report prints at the top right hand corner of the main report, regardless of where the X-Y position of the sub report is...thus if I have 3 sub reports forced to print on page 2, they are all overlapping each other...)
Solution:
In each sub report i placed the fields in Details section, and in Section Expert I conditionally forced a Print Next Page with the formula ln_num = x
(x being the last line number allowed to print for the corresponding sub report)
I made 2 group headers in a group that has Repeat Group Header enabled.
Group Header 1a is conditionally suppressed on Page 1, and enlarged perfectly to "push" the details section downward until the data fields are in the position they should appear in on the main report.
Group Header 1b contains the field headings.
Sorry for the confusion, and thanks to all who gave an effort... The solution seems SO simple now that I have it, but I had to rack my brain very hard to find it.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.