Groups | Blog | Home
all groups > sql server reporting services > february 2006 >

sql server reporting services : Subreport Page-Break Rendering


nash_music
2/2/2006 12:13:27 PM
I'm having trouble rendering a subreport properly.

The parent report only takes about 10% of the first page. The subreport
returns too many rows (80 - 200) to fit on the first page with the parent
report, and is automatically being forced to a new page. This is leaving
about 90% whitespace at the bottom of the report for each new page containing
the parent report data.

I've checked to confirm the width of the subreport is not an issue. In
addition, if I reduce the number of lines of data that is returned by the
subreport, it will format properly.

The parent report is a simple report with one group header and four
following lines. The fifth row in the table contains the subreport.

Richard Wodabek
3/22/2006 3:31:32 PM
Anyone find a solution to this? I'm running into the same problem.




[quoted text, click to view]

Jens Winter
4/2/2006 12:00:00 AM
I'm looking for a solution too!!

Ciao,
Jens

[quoted text, click to view]
Dale M.
4/4/2006 9:39:28 AM
I'm also running into this issue. I'm using Reporting Services 2000 SP2.
Any word from the MS folks on workarounds for this? It's as if it is forcing
a "keep together" on the subreport.

For my report, I've got a table in the body of the main report with 5 detail
rows in the table. The third detail row has a rectangle in it and my
subreport in that. As was reported, when the subreport contains too many
lines of data to fit on the page with the other detail rows, it pushes the
whole subreport to a new page.

If you need samples, LMK, but it should be easily reproducible.

Dale.

[quoted text, click to view]
Potus
4/10/2006 9:15:34 AM
I'll try resubmitting this in the managed flavor, hoping to elicit a
response from MS. Is there a workaround to this issue?

=?Utf-8?B?RGFsZSBNLg==?= <DaleM@discussions.microsoft.com> wrote in
news:BEF9CB3A-8DCE-4C8B-B5E3-134BDB9B92B9@microsoft.com:

[quoted text, click to view]
rqually
4/15/2006 10:25:01 PM
I'm having the exact same problem. Does anyone know if this is fixed in RS
2005?

[quoted text, click to view]
AddThis Social Bookmark Button