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

sql server reporting services : Pagebreak before Table and Expression on value Hidden


Daniel Doerfel
5/23/2006 6:55:02 AM
Hi Newsgroup,

in an Reporting-Services Report i have a table that is visible/hidden by a
specific parameter and it is set the pagebreak before table to true.

Now if the table is shown in the Report (The expression for the value hidden
returns false) the flag "Pagebreak before table" does not work.

If i remove the expression for the value hidden then the flag "Pagebreak
before table" works without any problems.

Seems to be a bug. Is there a fix or workaround for it?! Does SP1 for SQL
Server 2005 help for it?!

Best regards
Rui
6/1/2006 6:53:18 AM
Hi,

I have the same problem here. If anyone knows something please share

Best Regards,
Rui
AMasson
6/2/2006 12:34:54 AM
I had similar problems with page breaks not working when a table
visibility was being set by an expression using a report parameter
value (using RS2000 SP2). This appears to be a known issue - a quoted
Microsoft response on another forum states "Any conditional visibility
disables page breaks. We hope to make expression-based conditional
visibility (but not toggle-based conditional visibility) compatible
with page breaks in some future version".

I don't think this has been fixed in RS2005. I managed to implement a
(not ideal) work around by nesting tables inside rectangles and
applying the visibility expression to the rectangle, not the table. I
then applied page breaks to other items within the rectangle to
separate the page break attributes and the object visibility setting.
It doesn't work well with export to Excel though, since it affects
layout spacing and prevents separate pages being displayed on different

worksheets

[quoted text, click to view]
Daniel Doerfel
6/20/2006 7:51:02 AM
i have now the same problem on a ReportingServices 2005 Report.

I have placed the table in a rectangle. On the rectangle i have placed the
Visible/Hidden Expression. On the Table i have placed the page break before
setting.

Now in the report i get some blank pages. I work arround this report many
hours.
Is there no solution to use the pagebreak before and a visible/hidden
expression on one and the same table?!

The blankpages are on the export to pdf.

Thanks
Daniel


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