Friday, March 23, 2012

Have Subreport NOT Keep Together

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,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.
<sjackson@.nexterna.com> wrote in message
news:1168641290.758091.292180@.m58g2000cwm.googlegroups.com...
>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,
>|||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.
Andrei wrote:
> 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.
>
>
> <sjackson@.nexterna.com> wrote in message
> news:1168641290.758091.292180@.m58g2000cwm.googlegroups.com...
> >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,
> >|||Will someone from Microsoft please address this question? This is a very
basic reporting need. Is a service pack in the works?|||"sjackson@.nexterna.com" wrote:
> 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,
>|||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
"sjackson@.nexterna.com" wrote:
> 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,
>|||Did anybody find a solution to this problem ?
Maybe somebody from Microsoft can be of assistance ?
<sjackson@.nexterna.com> wrote in message
news:1168641290.758091.292180@.m58g2000cwm.googlegroups.com...
>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,
>|||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!|||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.
"sjackson@.nexterna.com" wrote:
> 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,
>

No comments:

Post a Comment