I have a report that I have created that has a sub-report in the Report Header that prints door sizes.  I then use the Detail section of the main report to list drawer front sizes,  below that in the footer is another sub-report that prints molding sizes and qty's if it is a molded door type.   The users in the plant, would like me to make it so that if the Detail Section (drawer fronts) do not all fit on the 1st page with the doors, then the drawer fronts all be moved to the second page.   I modified the formating of the Detail Section and tried "Keep Together", but for some reason, it is still splitting this data on two pages.   I can modify the formating of the header, to "New Page After", and it moves all of the Detail Section (Drawer Fronts) to the second page.  However, I do not want to always have 2 pages, when a lot of the time, all of the data can fit on one page.  I would like to know if anyone knows how to write a formula for the "New Page After", that would tell the report, if there are more than 2 pages to make a new page after the header. 

I assume you're using the "Section Expert" when accessing the "Keep Together" option. Try adding a Group that does not change the display of the Detail section. Then on the "Options" tab of the "Insert Group" or "Change Group Options" screen, check the option for "Keep Group Together."

I have found that I have better luck using the group footers for the data. You can right click in design mode and add section below. What this will do is add anouther footer for that group. You can then add your subreports to the group footers. This will allow you to keep everything together and avoid the blank first page. I would still use the "Keep Together" in the "Section Expert". If that does not work for you. Feel free to download the report I would be glad to take a look at it for you.