PDF or Image Render produces extra blank page when subreport contains pagebreak

PDF or Image Render produces extra blank page when sub report contains page break.

This is almost always caused by the Body of your report being too wide for your page. Make sure that the Width of the Body is less than the physical page size, less the margins.

Thanks to both the Sites.

http://blogs.msdn.com/b/chrisbal/archive/2006/08/10/694892.aspx

http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/fc4ab32c-2f4c-4488-bf49-ee728ccd5dfe

SSRS - How to - Conditional Color the Fields, rows in a Report using Expressions

Excellent Post on SQL Reporting "How to" - Conditional Color 1/4: The Basics. Report Expressions & Custom Code.

http://blogs.msdn.com/b/davidlean/archive/2009/02/17/sql-reporting-how-to-conditional-color-1-4-the-basics-report-expressions-custom-code.aspx



Happy  Reporting!!!

Repeating Tablix Column Headers with SSRS 2008

Repeating Tablix Column Headers with SSRS 2008

 

There seems to be an issue with repeating column headers using SQL Server 2008 Reporting Services. Typically you would highlight the row, right-click and select properties then you would be able to set the property for RepeatOnNewPage to True. I tried it and it does not work for SSRS 2008 R2.

Work Around:

Click on Black Arrow, at Right Side In your grouping pane, select advanced mode, then select your outermost static row; Click F4 or open Properties Window. You should then see the "RepeatOnNewPage" property and KeepwithGroup.

Set KeepwithGroup as --- After (None, Before and After)

RepeatOnNewPage ---True

 

Happy Reporting!!!

Add Page break to Row group in a table

To add a page break to a row group in a table, matrix, or list

1. Create a Parent Group and select Group By Filed.
2. In the Grouping pane, right-click a row group, and then click Group Properties.
3. On the Page Breaks tab, select Between each instance of a group to add a page break between each instance of a group in the table.
4. Optionally, select Also at the start of a group or Also at the end of a group to specify that a page break be added when a group starts or ends in the table. 
5. Click on the Column and go to visibility option and "Hide" the column.