Report lines split between pages. 1

[JAES]

I have a report that consists of 10 sub reports, one directly after the other. Occasionally, the last line of the page is split in half horizontally with the other half being on the next page. It seems to happen with such irregularity that I haven't been able to nail it down. Until I can, has anyone come across something like this?

Jeff

 

[lameid]

When I see that it is because my report is too wide to fit on one page and the line wraps to the next piece of paper. Since it is happening only some of the time, I would be suspicious if maybe the sub reporots are somehow causing this. Although I would expect the subreports to be truncated rather than widen the report.

I suggest you find data that it occurs for. Make a copy of your main report and run it for the data that has the wrapping pages. Next delete a sub report and rerun the main report until it does not happen. The report that subreport that makes the problem goes away is the source of your problem. That is of course assuming that my hunch is right.

 

[JAES]

The sub reports are not very wide and it has happened on at least 3 of them. The one that it is splitting on right now is only 3" wide and 2" tall. It appears that it will not be happy until ALL my hair is pulled out. I'll keep trying to pin it down. Thanks for the suggestions though.

 

[Spenney]

When using sub-reports I always set the height of the sub-report object on the main report to the 'default' ie select the object and double-click on the black box marking the bottom right-hand corner. This will size the object so that it corresponds with the size of the sub-report it is trying to display. I'd try that first.

Also what do you have set for the properties of 'Can Grow' and 'Can Shrink'?

 

[lameid]

Perhaps you have a page break control or the Force New Page property set on on of the sections of the subreport(s)?

 

[JAES]

Thanks for the responses. Maybe the way I formated the report was incorrect to begin with. I have a report that has up to 12 different sections (sub reports) and any given report can have from 3 to 12 of those sections in it. They can be simple memo text boxes or continueous reports. When I sized the sub reports correctly it left a large space between say section 3 and 10 if those in between were not used. Because of this I scrunched the subreports down to the size of the detail or header bar so if they had no information there was not a big space. I think I have 10 sub reports in 2" of report! Maybe I need to change that methodology.

Can grow and can shrink are both on. Force New Page property is set to none.

 

[Spenney]

To remove the blank area caused by sub-reports with no data, set the 'Can Shrink' property of the section (the Detail section I assume) where the sub-reports are placed to 'Yes'.

Did the setting of the sub-report object to the default size help with the line splitting problem?

 

[JAES]

I thought I tried the can shrink property by I'll try it again. When I set the sub report to default size it moved the first 4 lines (the 5th was split)to the next page and left a space at the bottom of the original one.

 

[lameid]

Let me say it again... within the subreports do you have any force new page properties set on any of the sections?

 

[JAES]

Hi lameid, I have checked all sub reports and the Force New Page setting is set to None in all sections, header, detail, etc.

Like I said before, the problem is real sporadic. The report I'm currently printing has the problem with one of the first sub reports so I'm trying things on that one. I’ll keep trying different things. For some reason, the sub report does not recognize the correct end of the page and tries to print one more line before going on to the next page. Unfortunately it only gets half the line printed. Strangly enough, it prints the second half on the top of the next page.

Thanks