Sunday, February 19, 2012

Help with large amount of text and page breaks

What has anyone done with large amounts of text in a table with regard to
page breaks? I've found that the page break happens before the large block
of text starts regardless of where it starts on the page. Even if there is
3/4 of the page empty it will always page break.
Here's an example. To illustrate, I'm just pulling back the Article Title
and the Article Details. I made the table background dark just so to
distinguish it from the rest of the page.
http://www.1uvaknd.com/pagebreaktest.pdf
This is in VS2003 preview mode. Take a look at page 2. The page size is huge
in comparison with the other pages.
http://www.1uvaknd.com/pagebreaktest_page1.jpg
http://www.1uvaknd.com/pagebreaktest_page2.jpg
http://www.1uvaknd.com/pagebreaktest_page3.jpg
Anyone else run into this?
Thanks
Richard.Richard,
We're having the exact same problem and can't seem to resolve it. I'm very
dissapointed there is no answer from MS to this question. If anyone out
there can think of anything please post.
I have found that if you use a list and get it set up just right it may
work. The problem is that you have to use a group and set a page eject at
the end of the group. If you have a unique item for the group it works ok.
One of our issues is that we want to use a field in the page footer which of
course isn't allowed (at least in the early versions).
--
Zip
"Richard Wodabek" wrote:
> What has anyone done with large amounts of text in a table with regard to
> page breaks? I've found that the page break happens before the large block
> of text starts regardless of where it starts on the page. Even if there is
> 3/4 of the page empty it will always page break.
> Here's an example. To illustrate, I'm just pulling back the Article Title
> and the Article Details. I made the table background dark just so to
> distinguish it from the rest of the page.
> http://www.1uvaknd.com/pagebreaktest.pdf
> This is in VS2003 preview mode. Take a look at page 2. The page size is huge
> in comparison with the other pages.
> http://www.1uvaknd.com/pagebreaktest_page1.jpg
> http://www.1uvaknd.com/pagebreaktest_page2.jpg
> http://www.1uvaknd.com/pagebreaktest_page3.jpg
> Anyone else run into this?
> Thanks
> Richard.
>
>|||Zip:
I can't believe I've not gotten any responses from MS on this from any SSRS
newsgroups. It is so easy to reproduce and so obviously wrong. I've gone as
far as to write a SQL function that will split up a text column into a
separate result set. It basically returns a bunch of rows. I then put the
table into a list object and it seems to work. The only problem is that the
function is limited to 8K and if your text is greater than that then it will
truncate. Not a perfect solution but still better than what is happening
now.
Richard.
"Zip" <gregory.zipprich@.arpc.denver.af.mil> wrote in message
news:F908AE27-97EF-4FC6-8C8B-1F796F12B085@.microsoft.com...
> Richard,
> We're having the exact same problem and can't seem to resolve it. I'm
> very
> dissapointed there is no answer from MS to this question. If anyone out
> there can think of anything please post.
> I have found that if you use a list and get it set up just right it may
> work. The problem is that you have to use a group and set a page eject at
> the end of the group. If you have a unique item for the group it works
> ok.
> One of our issues is that we want to use a field in the page footer which
> of
> course isn't allowed (at least in the early versions).
> --
> Zip
>
> "Richard Wodabek" wrote:
>> What has anyone done with large amounts of text in a table with regard to
>> page breaks? I've found that the page break happens before the large
>> block
>> of text starts regardless of where it starts on the page. Even if there
>> is
>> 3/4 of the page empty it will always page break.
>> Here's an example. To illustrate, I'm just pulling back the Article Title
>> and the Article Details. I made the table background dark just so to
>> distinguish it from the rest of the page.
>> http://www.1uvaknd.com/pagebreaktest.pdf
>> This is in VS2003 preview mode. Take a look at page 2. The page size is
>> huge
>> in comparison with the other pages.
>> http://www.1uvaknd.com/pagebreaktest_page1.jpg
>> http://www.1uvaknd.com/pagebreaktest_page2.jpg
>> http://www.1uvaknd.com/pagebreaktest_page3.jpg
>> Anyone else run into this?
>> Thanks
>> Richard.
>>|||Another (probably better solution). Put all the tables into a List
object. Then take the large text column out of the table and place it
in the list object itself. As long as the large text column is NOT in a
table but in a List object - it seems to work much better.
Richard.|||I'll have to try these solutions. Mine worked for some records and not
others. I think there are also special characters embedded that I can't see
and these are causing proglems. We plan on writing a procedure to strip out
all characters that are standard and see if that helps as well.
--
Zip
"richard.wodabek@.gmail.com" wrote:
> Another (probably better solution). Put all the tables into a List
> object. Then take the large text column out of the table and place it
> in the list object itself. As long as the large text column is NOT in a
> table but in a List object - it seems to work much better.
> Richard.
>

No comments:

Post a Comment