all groups > sql server reporting services > january 2007 >
You're in the

sql server reporting services

group:

Have Subreport NOT Keep Together


Have Subreport NOT Keep Together sjackson NO[at]SPAM nexterna.com
1/12/2007 2:34:51 PM
sql server reporting services:
I have a subreport inside a table on the main report. It seems
everything I
try the subreport will keep together on a new page if it cannot fit
itself
on the rest of the first page. How can I have the subreport display
it's
data on the rest of the first page and continue on to the second page?

I have looked at everything I can think of. Keep Together is set to
false
everywhere.

Please help.

Thanks,
Re: Have Subreport NOT Keep Together Andrei
1/15/2007 2:09:23 PM
Same thing here !

We have reports with 2-3 levels of subreports and the data "migrates"
sometimes to the 4th page, leaving the first 2-3 pages just with a small
header on top... it's very difficult to explain to a client why their report
looks like that. And this problem is active since the beginning of reporting
services. A few service packs later, a new version, and it's still out
there...

For some of the reports we managed to eliminate the subreports, but just
imagine how the datasets look like in the main report :(
Or, we transferred the burden of "subreporting" to the processing part,
creating a separate table to keep all the pre-calculated data, with headers
and subreport information, etc., leaving to Reporting Services the only task
of displaying the content of the table. But it's much more difficult and it
lacks flexibility !

Please, if anyone has a solution to this, make it public !
We regularly search the newsgroups for a solution to this problem, but
untill now, we just noticed a lot of people having this problem...

Thank you,

Andrei.




[quoted text, click to view]

Re: Have Subreport NOT Keep Together sjackson NO[at]SPAM nexterna.com
1/16/2007 7:44:38 AM
The sad thing is that I heard it is an issue that Microsoft has added
to their wish list. So you really need to limit the use of sub reports
or you can run into this issue.

Hopefully they can expedite the resolution of this issue.

[quoted text, click to view]
RE: Have Subreport NOT Keep Together l99057j
2/28/2007 6:34:57 AM
Will someone from Microsoft please address this question? This is a very
RE: Have Subreport NOT Keep Together l99057j
2/28/2007 6:59:24 AM


[quoted text, click to view]
RE: Have Subreport NOT Keep Together Jony
2/28/2007 9:06:03 AM
I have the same problem.
I find many posts related to this problem and recentily I published my own
post with several links to other posts, but yet any answer from MS.
Here is my post
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=1279676&SiteID=1



[quoted text, click to view]
Re: Have Subreport NOT Keep Together Andrei
3/9/2007 4:06:14 PM
Did anybody find a solution to this problem ?

Maybe somebody from Microsoft can be of assistance ?


[quoted text, click to view]

Re: Have Subreport NOT Keep Together KingcanFly
3/15/2007 12:28:00 PM
Also wrestling with this one. Also irritated by the "No fields in headers or
footers thing" but got that working.

I am now at the point where I am possibly going to play with the byte stream
output by Localreport.Render("PDF"....) to try and make it work the way I
want. Fortunately only PDF is reuired.

Will come back to this post if I find something....
--
Programming is fun but paralgiding is better!


RE: Have Subreport NOT Keep Together Clint Jennings
5/23/2007 11:45:01 AM
Same thing here as well sjackson. No one has any answers? Let's add another
client to the 'I'm Not impressed with that SQL Reporting service thing mister
contractor' list.

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