Fit Table on one page if possible

has anyone had any luck with the table property option 'Fit Table on one page if possible'. Reporting services seems to ignore this. Anyone familiar with issues surrounding this property? RS seems to break the table at will. I am MOST concerned with this issue as it relates to exporting to .pdf. Any ideas or workarounds would be helpful (we are running sp2).

Thanks!

[394 byte] By [ellenf] at [2007-12-19]

«« Smartphone emulator and Windows Media Player 10 - adding songs to the library
»» IssueVisionWebCS service for Access Database

# 1

I usually use table with defined width and page size for A4 paper format.

Divac at 2007-9-9 >

top of Msdn Tech,SQL Server,SQL Server Reporting Services...

# 2

Are you talking about the table's width and height properties? For me, this issue is height as that is what is causing the breaking to the next page. My table width is 7.5, and the height varies, but is usually set for 1.275. This of course doesn't truly reflect the height of the table once it's populated with a bunch of rows!

ellenf at 2007-9-9 >

# 3

I think I'm having the same problem as you. The report is fine except when exported to pdf/tiff where the page breaks occur across the middle of the table details. I enabled this property as suggested elsewhere but it didn't seem to have any effect.

nblankton at 2007-9-9 >

# 4

Have you tried putting the table inside a list an then play with the list properties? I use the keep together property and all my tables are on the same page.

Divac at 2007-9-9 >

# 5

I had the same problem before. When I exported the report to PDF, the last several columns were separeted onto next page. After lots of testing, I set the width of the report to 8, and keep the width of the table to 7.5, every field can be kept on the same page.

jennyliu at 2007-9-9 >

# 6

Hi ellenf ,

Habe you solved your "Fit Table" Problem?..I am also having this problem.

Is this a microsoft bug? if it is, is this fixed in RS2005?

Thanks in Advance

venkee at 2007-9-9 >

# 7

No, I never did get this to work. I didn't attempt to put my tables into lists, because this report with about 100 tables is already difficult enough to maintain. I haven't played with 2005 yet, so i do not know if it is resolved.

sorry it's taken so long to answer, I haven't checked my threads in a while!

ellenf at 2007-9-9 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech