all groups > sql server reporting services > february 2006 >
You're in the

sql server reporting services

group:

PAGE BREAK NIGHTMARE !!!!!!


PAGE BREAK NIGHTMARE !!!!!! The Cornjerker
2/9/2006 10:34:17 AM
sql server reporting services:
I have a group header in the middle of my large report near the bottom
of the page that I NEED to send to the top of the next page.

How do I do this?

Why can't I get a conditional page break?

How can I page break based on a value from a field?

How do I programmatically force a page break after a group footer or
before a group header?

This is ridiculous. Why is it so difficult? Why can every other
report generator on the planet do this and RS can't? Please PLEASE
tell my I'm missing something obvious.
Re: PAGE BREAK NIGHTMARE !!!!!! microsoft
2/13/2006 9:23:18 PM
One thing I did was create a subreport that was just an empty list. With a
list you can set a page break before or after. So when I want a page break
I set the subreport/list visibility off or on.


[quoted text, click to view]

Re: PAGE BREAK NIGHTMARE !!!!!! The Cornjerker
2/14/2006 12:52:33 PM
Thank you for the suggestion and I will give it a try. I ended up
hacking a page break in by putting an extra row in and hard coding it's
height so that it forced a natural page break. I then had an
expression to hide it until the group I needed appeared. I'm praying
that nothing will change in all the lines before the hack.

<sarcasm>
These various hacks, I'm sure, are the way page breaks are suppose to
be programmatically added in software that is at the version 2 level.
Maybe by version 5 we can actually control how the report looks.
</sarcasm>

I appolgize, but by the number of requests in this forum about page
breaks you'd think that someone would actually FIX THE EXISTING
PROBLEMS.
Re: PAGE BREAK NIGHTMARE !!!!!! LesW
4/28/2006 5:30:01 PM
I relate to your frustration here. I have spent many hours trying to get
basic grouping, foooter, header, page-breaks to work consistantly. This
should NOT be this hard! This product is powerful, but very touchy!

[quoted text, click to view]
Re: PAGE BREAK NIGHTMARE !!!!!! The Cornjerker
4/28/2006 6:15:36 PM
Thanks for the replay. I've been ranting on this for a while. The
SQL2005 SP1 doesn't even address it. Page breaks are key to
controlling the layout of a report, but is seems like MS has actually
gone out of their way to keep us from controlling them. This topic
alone has kept my shop from totally committing to RS.
AddThis Social Bookmark Button