How to handle large amount of text ??? - SQL Server Forums

Home | Weblogs | Forums

Site Sponsored By: SQLDSC - SQL Server Desired State Configuration

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

Development Tools

Reporting Services Development

How to handle large amount of text ???

Author

Topic

rwodabek
Starting Member

3 Posts

Posted - 2006-04-21 : 16:02:05

What have folks here done with large amounts of text in a table with regard to page breaks? I've found that in a PDF 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. Typically, the amount of text spans more than one page.

Any workarounds or ideas?

Thanks

Richard.

rwodabek
Starting Member

3 Posts

Posted - 2006-05-02 : 12:49:06

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.

rwodabek
Starting Member

3 Posts

Posted - 2006-05-12 : 08:50:35

I have come up with a solution/workaround. 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.

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources