Variable length report - Any insight?

[tstoneami]

Variable length report - Any insight?
Hey folks;

Let me see if I can explain this clearly. I need to make a report from a single record that will contain a number of individual text fields of varying lengths. If they are all filled out, they could span four pages.

The problem is that on my report there is just a little bit of room left in the details section - so I need a way to continue the printing of the details section on the next page. I don't know how many pages will result, because each time the report is run, new data will have been entered to fields as well as new fields completed.

Does that make sense? Towards the bottom of my page I have a minimal amount of room left to represent these fields, even at 0 height on the designer. Should I put them all on a subpreport (like at 0 height) and reference that in my details? Will it result in new pages as neccesary? I guess I will try that, but would rather not attempt something fruitless...

Thank you,

Troy Stone

 

[tstoneami]

>>>>When placing controls on the form, always make them one line tall (or shorter) and set their can shrink/can grow properties to yes.

Do you mean to do this in the designer, so as to maximize the available real estate in the view? I guess lay it all out then reset the heights afterward?

This won't work with labels...only the fields...

 

[tstoneami]

I am sure this is misunderstood, as I think I misunderstood the response in the first place.

At any rate, I was able to get a solution to this issue overall by referencing a single sub report in the details section. It was actually quite straightforward.

Sorry for the WOB.

Troy