Report format allignment

Hi, You can use smaller font (6) for text field NAR1 - NAR6 or sets trim mode to "Trim to nearest character"

can you please tell me where i can write trim to nearest character

see to help: https://www.vfphelp.com/help/_5wn12pzo3.htm

I think what mJindrova suggests works for this case and will spare some space. In general, though, you can't force data to always fit on one page, it's as many rows as it is, and there will always be cases where the split is unpleasant and just the totals appear on a separate page. You can't avoid that for all possible cases. There's a practical limit to squeeze everything on one page. You don't have features like dynamic row height or font sizes.

What you have at hand is Modifying the frx programmatically before a report run. You can USE report.frx as a table and then act on some records about the detail band height and font sizes, but I'd not recommend going that route, unless you're very eager to always have a report on one page. If you do this for a case of batch printing multiple accounts in one report, even "hacking" the frx data you couldn't adapt font sizes and band heights for each account individually.

Modifying the FRX data allows you to change the otherwise constant sizes for the next report run, but not during a report. There are some reportengine 90 features you can learn about, which all are about the "Dynamics" tab of the properties of a report control. If I were you I wouldn't want to set this for each individual report control, though. In the extreme case you can define a set of conditions and run a script of code when the condition is met for every single report control, that sets a lot of options and will best be used in conjunction with a report listener. And the reportlistener class and what it can do is even more worthwhile learning about and using for advanced reporting.

ok chriss and mJindrova thanks for your help as per mJindrova i looked into trim into nearest character i did modify the report and set all in details accordingly but again saved some space only and going as per your advice will ignore it and let it be
thanks for the help
regards

I think you can squeeze a little more space. Because. to save space vertically, you mainly have to shrink the detail band height, using a smaller font size alone won'shrink lines. You can maximise the numnber of lines per page that way. Just also notice you print multiline Narrations that cause line breaks, so the report will automatically grow the band for such records. You have tthe option to disallow that, but whether that's viable or not depends on whether all text within the narration is necessary to appear or not. You can always shorten things and cut them off, have "..." at the end when shortening it. The TYPE column seems to be defined that way, I assume "STATE..." is the result of the report shortening something like "STATEMENT" to "STATE..."

Whatever you do, a report also becomes dysfunctional if important parts are missing. So squeeze out space you can, but you'll not have an option like "shrink report to a single page". There are printer driver options that would optimize images for page size, but you can't do that for the whole report, if at all it would be a per page feature and not squeeze a few lines of page2 into page1, anyway. I also don't see this option in Crystal Reports or any other reporting tool. Even if you have the opposite problem of mostly empty pages you'd like to grow to fit a page. It would look awkward if parts of the pages have double sized letters, for example.

Balance the band height and font size so most reports are 1 page only and live with the outliers. If you adjust everything to extreme outliers the usual report will have lots of blank space and make people scratch their head why the lines are that dense and the font is so unreadably small.