Setting a fixed height in a report. 1

[Jetter88]

I had a master/detail report.
The report top section has the master info, the middle section has the details, the bottom has more master info.

The detail section can have multiple lines depending on the number of items selected by the user.

The problem is that detail section shrinks and expands, which shrinks and expands the page. I would like to keep the report the same size (8x11) at the time. So this means if there is only one line in the details, that is fine and there would be space below in the fixed detail area, instead of the whole report being pulled up.

example:
top of page
-----------------------------------------------------
| Master |
|---------------------------------------------------|
| Detail 1 |
| Detail 2 |
| Detail 3 |
| Detail 4 |
| Blank (room for more) |
| Blank (room for more) |
| Blank (room for more) |
-----------------------------------------------------
| Master 2 |
| Master 3 |
-----------------------------------------------------
end of page

 

[BJCooperIT]

The details are contained in a repeating frame whose vertical property is set to expand or variable which is OK. However, that repeating frame should be contained in a regular frame that is stretched to the maximum size you want it to occupy on a single page. It's vertical property should be set to fixed. Hopefully that will do it!

[sup]Beware of false knowledge; it is more dangerous than ignorance.[/sup][sup] ~George Bernard Shaw[/sup]
Consultant Developer/Analyst Oracle, Forms, Reports & PL/SQL (Windows)
My website: Emu Products Plus

 

[Jetter88]

Thanks again...
I tried fixing the vertical height of the repeating frame and I knew that wouldn't work. I'm starting to get the hang of the layers and different elements in the reports. Still a long way to go!