PAGE BREAK NIGHTMARE !!!!!!

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

The Cornjerker - 09 Feb 2006 18:34 GMT

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.

Reply to this Message

microsoft - 14 Feb 2006 05:23 GMT

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.

>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.
[quoted text clipped - 11 lines]
> report generator on the planet do this and RS can't? Please PLEASE
> tell my I'm missing something obvious.

Reply to this Message

The Cornjerker - 14 Feb 2006 20:52 GMT

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.

Reply to this Message

LesW - 29 Apr 2006 01:30 GMT

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!

> 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
[quoted text clipped - 11 lines]
> breaks you'd think that someone would actually FIX THE EXISTING
> PROBLEMS.

Reply to this Message

The Cornjerker - 29 Apr 2006 02:15 GMT

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.

Reply to this Message