Groups | Blog | Home
all groups > sql server reporting services > july 2004 >

sql server reporting services : No Page Break within SubReport


Milu
7/30/2004 2:39:02 PM
I have a main report which includes 4 sub-reports. One of the sub-report shows the details based on selected parameter values and at that time all other sub-reports are hidden. When I run the sub-report as a seperate report, it shows page breaks correctly but when I display it from the main report, I don't get any page breaks within this subreport. It shows all the values in a single long page. I even tried removing this subreport and directly including the table in it in the main report. Even then no page breaks occur.
Can anyone help on this.
Thanks in advance,
Chris Hays [MSFT]
7/30/2004 5:59:57 PM
Page breaks are not supported on items that can be hidden (either via
ToggleItem or Hidden), as it can radically alter the layout of a page (we
currently depend on consistant page layout for certain performance
optimizations)
Support for page breaks within conditionally hidden items (but not
toggleable items) is on our wishlist for a future release.

--
This post is provided 'AS IS' with no warranties, and confers no rights. All
rights reserved. Some assembly required. Batteries not included. Your
mileage may vary. Objects in mirror may be closer than they appear. No user
serviceable parts inside. Opening cover voids warranty. Keep out of reach of
children under 3.
[quoted text, click to view]
shows the details based on selected parameter values and at that time all
other sub-reports are hidden. When I run the sub-report as a seperate
report, it shows page breaks correctly but when I display it from the main
report, I don't get any page breaks within this subreport. It shows all the
values in a single long page. I even tried removing this subreport and
directly including the table in it in the main report. Even then no page
breaks occur.
[quoted text, click to view]

eirikur NO[at]SPAM hugur.is
8/6/2004 3:55:47 AM
This is a function that I really need. I have a Master report that
has one SubReport. This SubReport has two tables. I need to be able
to make a Page Break between these two tables. The thing is that if
there is nothing in the other table I hide it. So I tried to put the
tables in a Rectangle and then the Page Break works but when I try to
put the hide function on the Rectangle
"Visibility": =IIF(CountRows("dsItargognTemplate1") > 0, false, true)
then the PageBreaks stop to work.
The "Visibility" for the other table in the SubReport is:
=IIF(CountRows("dsAnItarfaerslna") > 0, false, true)

Is there any workaround for this?





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