Sub-Report Problem

[Sameal]

I have a sub-report placed into the footer of the main report. The problem I have is that when the detail section of the sub-report is larger then the space allocated for the footer on the main report, it does NOT carry over to a second page and continue printing out the details. It instead cuts off the detail section neatly at the end of the page and thats it.

Does anyone know how I can get a sub-report to carry over into consecutive pages?

 

[HiBoo]

Place the subreport data at the bottom of the Detail section and set the Can Grow property to True. If you've got the report sorted with GroupBy's then you may also place the sub report in one of the GroupBy footers to get the results you are looking for. You will not get the results you're looking for by placing the sub report in either of the page or report footers.

 

[Sameal]

I tried putting the sub-report into the detail section and that have very bad results. It began to print the sub-report for each item in the main report. 10 pages of reports or something like that.

So I put it in the report footer instead of the page footer and it put the sub-report onto a second page if it was to long. This is what I was trying to achieve, so I left it at that.

 

[DancingDon]

I have an unbound field in a sub report (Access 97) which is a sentence composed of data from a bound field. I did this in VBA in onformat, capturing and qualifying the data of each record and concantinating it every time it loops. The phase comes out just fine in the report, but as a sub report it goes bonkers.

Firstly, the sentence repeats itself twice. Secondly, if the sub report visible property is set to no, the sentence doesn't even appear in a linked field in the main report. I have the same result even if I leave it visible but shrink the size of the sub report. I've tried moving code and unbound field to various sections of the report but still to no avail. I am currently using a convoluted method of opening and closing each of several sub reports with similar construction and setting the setence to a global variable but the screen flashes even though echo is set to false.

If someone has a clue I'd be grateful.