Extra blank page when Save to PDF from SQL Reporting Service

When you save a report as PDF from Sql Reporting Services, you might see an extra blank page in between the pages in the report. This is due to the actual print out size exceed the page size that is specified.

For example, you specify your report size to be width (11 in) x height (8.5 in) which is a A4 size. However in the body of the report, you might have specify (intentionally or unintentionally) the size to be larger than that. When you save the report to PDF, you will see a blank page because the report size actually run over the page size.

To solve this problem, make sure you check the Size and Margin property of both the Report and Body (you can access this from the properties window).

Licensing Requirement to Install Reporting Service on separate server

I was asked if the SQL Server Reporting Service is installed in a separate server from where the SQL Server database engine is installed, does it need another SQL Server license?

Although I am not a licensing expert (and not many people seem to be able to understand Microsoft Licensing scheme), but I can confidently say Yes to the question above.

The answer lies in the following document:

Licensing Doc

In the above scenario, you need two SQL Server license.

I hope Microsoft can be more open and clear in communicating licensing issue and requirement in the future. It will be good if they can include some of the common deployment scenario for their software together with the licensing requirement in Technet.