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.
If you find a better workaround, I'd be interested to know!
[quoted text, click to view] Scott wrote:
> Did you check the box Page break at end checkbox ???
> I am having the opposite problem. I get a page break after the last group
> and I don't need one.
>
> "Mike Rand" wrote:
>
> > Hi,
> > I am having a problem with page breaks in a report that I am writing. I have
> > set some conditional logic on a Group to only show the group under certain
> > conditions. The logic works fine, but it creates a subsequent problem, and
> > that is that all of the group page breaks are eliminated (I want each group
> > on a seperate page), and now all of the groups are on the same page. I
> > noticed that someone has previously posted a question very similiar to this
> > one, but no one responded with any useful information.
> >
> > Any ideas, or suggestions would be greatly appreciated!
> > Thanks,
> > - Mike