Then I would have two layouts and look at number of records. If there is more then 15 go to the other layout
So one solution I have come up with (given the request that everything be on one page) is to:
Print to PDF
Scale to 85%
The hard copy printers here don't seem to have the necessary drivers to scale properly from FM but the PDF drivers do.
johanhedman your response would have been my what I'd have tried next if it wasn't for the intervening client curve ball of 'One page please'! Thanks for the input
If your goal is a PDF then you could always Append. So start with start parts and then depending on number of records Append different parts from different layouts
I don't completely understand the question, and I don't know if this would work, but what if you tried something along these lines:
- Have a calculation field that simply equals the unique value of the individual record
- Have one summary section that includes a page break and references the original record
- Have another summary section that doesn't include the page break and references the calculation field
- Have a script that runs OnLayoutEnter (or similarly triggered) that sets the layout to sort based on either the unique field or the calculation field, depending on whether or not there are at least 15 records.
I've used similar techniques to avoid having to use two separate layouts for very similar reports. Only one of the subsections appears on each report, because the non-relevant field is not used in the sorting.