Can't get a Subreport to start on the correct page or table header to repeat on multiple pa
I am staring to lose my mind on all this "work-around" BS in trying to create a dynamic header.
I have a report with contains a table, whose first two lines are a header line in which I want to repeat on each page. Then I have about 20 detail rows of information related to the header. The 21st detail row is a merged cell that contains a subreport relating to the header item.
When printing to PDF, the detail rows consume about half the page and the subreport is anywere from half a page to several pages long. When the subreport is more than half a page, it skips the end of the first page and starts on the top of the next page, leaving the bottom half of the first page blank. No matter what I set the page breaking to, it continues this behavior. In addition, when the subreport data spans more than one page, my parent table's header row will not print to the next page even it the RepeatOnNewPage is set to true.
I am coding this way because I have found no good way of creating a dynamic header that will correctly and consistantly display data that has detail that spans more than one page.
Any thoughts on what I might be doing incorrect?
[1199 byte] By [
unit107] at [2007-12-24]
this is an unfortunte effect of using a sub report. It (or the textbox it is in, can't remember) has an implied "keeptogether" property setting. The only way around this I have found is to use nested dataregions, which present a number of issues themselves, such as having to use the same dataset as the parent data region.
I am almost at the end of the line with this tool because if its unpredictable and, many times, uncontrolable nature of rendering reports.
It seems there about are couple major areas of improvement that the RS development team could make that would elevate this tool to a level more practical for corporate reporting:
1. As you say, the "Implied" KeepTogether property of the text boxes in tables. This is a pain because when using a subreport that spans more than one page, it will start the subreport on a subsequent page and potentially leave the previous page mostly blank...very ugly and I have yet to find a work-around
2. Not being able to reference a data field in a header. I have tried all the "work-arounds" to limited success. Even when using the table method with RepeatOnNewPage set to true, if a subreport in that table spans more than one page this also fails...I imagine anyone doing corporate reports would enjoy an improvement here.
3. "work-arounds" - It seems there are many people offering work-arounds for the short comings of this tool, including many from the RS development teams listening in on Blogs...SQL server 2005 is basically "version 2" of this tool and many of these issues should have been addressed.
I really want to use and encourage my clients to use this tool for reporting, but I am finding out that it might not get us what we need out of corporate reporting.
Try selecting "Format Subreport" from the main report. A dialog window should appear which has an option to "Keep Object Together" If this is checked, that would be your problem.
I ran into the same problem and couldn't remember this until I read it on the Business Objects website.
Ross Feickert wrote: