SQL Server Performance

How to avoid a table detail row from being scattered across pages.

Discussion in 'SQL Server 2005 Reporting Services' started by shivi, Oct 9, 2007.

  1. shivi New Member

    Hello, I have a simple report which displays the values from a sql server table thru reporting services.
    We have used a 'table' report item. One column in table details row is nvarchar(max) so this value can be very big or can have just one word. We do not want the table details rows to split across pages when exported to pdf and printed. Is there a way to check if the size of the varchar data can fit into the remaining length of the current page .
    if not this row must be printed from the next page. If the length of the column is small then many rows can appear in one page.As long as they dont spread across pages. This problem is happening only when the report is exported to PDF not in the preview or view report section.
    Please help
    Regards,
    Shivi
  2. satya Moderator

Share This Page