Sql-server – How to one prevent page breaks between Tables in SQL Reporting Services 2005

Place two rectangles, one inside the other.
Place your table inside the inner rectangle and set it to always be visible.
Set the inner rectangle's Page Break to Insert After Rectangle.
Set the outer rectangle's visibility to use your conditional expression.

The page break and the conditional visibility are now separated, and the inner rectangle's page break won't be processed if it is not visible, but it will if it is visible.

Edit: When I tried this, it did not appear to work in the Preview tab in Visual Studio, but it did work in the Print Preview and when I exported the report to PDF.

We narrowed down the large PDF exports from SSRS and found 2 main culprits

1) Unless images are JPG or PNG colour type 3, they are expanded to BMP's See here

2) Unless you configure SSRS to behave otherwise (not recommended), then SSRS will embed fonts or font subsets into the PDF, unless they are one of the 5 'standard' PDF fonts.

Although none of the standard fonts (other than Symbol I guess) are installed on most Windows OS's out of the box, we've found that if you use Times New Roman, Courier New, or Arial then forward and reverse font substitution will take place.

The easiest way to convert your RDL's is to view them as XML and search and replace the FontFamily tags.

If you have to use a non standard font, then, you can still minimize the damage:

• Use as few fonts as you can. Search through the RDL XML to make sure there aren't any redundant fonts.
• Use TTF fonts if you use different sizes of the font.
• Try not to mix normal, bold and italic variants of the font, else it will be embedded multiple times.