Groups | Blog | Home
all groups > sql server reporting services > august 2005 >

sql server reporting services : Long text starts on next page



Marvin
8/29/2005 3:03:02 PM
I have a table where a cell gets populated with a lot of data. When data is
longer than the page it would page break into the next while leaving a huge
white space on the previous page. how can i make it page break in the middle
of the text when it needs to instead of the whole cell getting moved to the
Donovan Smith [MSFT]
8/30/2005 11:08:24 AM
A textbox has an implicit keep-together flag set on it which dictates the
behavior you are seeing. It is not currently possible to modify this
behavior.

Workarounds include breaking the text into multiple textboxes.

--
This posting is provided "AS IS" with no warranties, and confers no rights.


[quoted text, click to view]

jrosen
11/1/2005 6:23:02 AM
I have used the workaround you suggested but many reports we use pull data
dynamically from a database that is often 60-100 lines long. We get a lot of
page breaks between table & group header rows which not only makes the report
messy but wastes a lot of paper. we also tried using a list with several
textboxes in it and set the keeptogether proprty of the list to true but now
the top textbox gets separated from the one below it if the one below it
needs to span pages. Any other ideas? Thanks.

[quoted text, click to view]
Greg Jolda
8/14/2008 11:00:03 AM
I see this as a significant problem with the Reporting Services. I'm using the product in a solution over Cognos reporting for sending official Maine State correspondence. Often times text boxes contain denial reasons for medical procedures and become lengthy out of necessity. With the header and introduction on the first page and the discussion on the second, the apprearance certainly presents an un-professional appearance. I'm now working on a multiple text-box solution. I would favor the keep-together property much like comparable situations in Microsoft's Access reports product. There may be reasons this can't be done that I'm not seeing, but my vote is to fix this apparently problematic issue.

From http://www.developmentnow.com/g/115_2005_8_0_0_588942/Long-text-starts-on-next-page.htm

Posted via DevelopmentNow.com Groups
AddThis Social Bookmark Button