Page Fit

rbuser

MS Excel has the ability to automatically fit a printed page to fit on
a single page by adjusting the fonts. Is there anyway to do this in
Report Builder?

Craig

rbuser

Jim - this is a follow up to your solution. I've integrated your code
into my report and everything is almost perfect However, I've
run into a number of issues that I was wondering if you have any
thoughts on.

First - I've noticed that while the detail band height adjusts as the
font is changed the same doesnt happen for the page header - even
thought the page header's print height is set to dynamic. Thus even
though items in the header are printing with smaller fonts the
vertical spacing is the same as for the original font. While this
wastes vertical space more importantly I've also noticed that some
page header items are now printing in the detail band. Is there
anyway I can get the page header vertical spacing to also adjust as
the fonts adjust?

Second -in the detail band I've used rectangles (tppshapes) to create
boxes for user input. By setting the box's Parent Height to true, and
Shift With Parent to true the boxes adjust to the Detail Band Height.
However, nothing prints inside the box (items print when the report
is printed as its normal font).

Third - when the last detail line prints the boxes return to their
default height and interestingly this last line of boxes contain data
(in the small font).

Thanks,

Craig

On Wed, 14 Aug 2002 11:11:20 -0500, "Jim Bennett \(Digital

digitalmetaphors

I created a demo in which a report will regenerate until it fits on a single
page:

http://www.digital-metaphors.com/tips/ForceFontToOnePageReport.zip

Demo created with
Delphi 6
RB 6.03 Std.


Cheers,

Jim Bennett
Digital Metaphors

digitalmetaphors

You'll need to resize the header and footer bands. You'll also have to
manually set the top property of the controls for the best fit, based on the
font you are using. Can you modify my demo to work like yours and I'll see
what I can do to get it working. Send it to support@digital-metaphors.com


Cheers,

Jim Bennett
Digital Metaphors

rbuser

Hi Jim could you mail me this demo, the url is broken.
i think that this is what i ned.

chris

rbuser

I too am interested in this technique. Where can I get a copy of your sample
project?

digitalmetaphors

Michael,

I've emailed it to you.


Cheers,

Jim Bennett
Digital Metaphors