How to create a variable lenght multi page report?

[tstoneami]

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.

I don't think I can use linked sub-reports because if I fill out a sub-report page with the fields, its possible only a small number of them will show on that page resulting in a lot of blank space. Same potenitally with the next page.

What I really need is a way to represent them all on the report and use the can grow / can shrink to display only those fields that are filled out, and have the report be of a dynamic length, resulting in a dynamic number of pages.



The only way I can think of doing this is to keep some sort of line counter and force a new page. Any ideas? I'm fresh out right now.

Thank you,

Troy Stone

[June7]

You can size the textboxes to 0 height then allow to grow/shrink. The textboxes will still occupy space but it will be minimized.

An alternative might be to concatenate the fields into one textbox.

[tstoneami]

Well, I have done that already and that works fine. 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...

[June7]

Not sure because I can't really visualize the issue you are describing. If you want to provide db for analysis, follow instructions at bottom of my post. Identify objects involved.

[tstoneami]

Hi All;

Well, I have this pretty much working - although there are more requirements to come, so this is pretty much still open. I made a sub report and inserted that reference into my main report. The fields shrink/grow, and their section labels are conditional based on values in the fields. It seems to print as many pages as are needed. I thought I would pass this along at this point. I am not going to mark this as solved until I am sure there are no glitches, and that way any more discovery might be useful..


Thanks.