Blank Pages in SSRS Reports PDF Render

Recently I faced an issue within SSRS where a Tabular Report in SSRS report got blank pages in-between the rows when rendered/downloaded as PDF.

I tried to read about it, but usually people think it’s about Keeping Header in the report or Portrait/Landscape orientation of the report. But its not!

Report must be having dynamically generated columns or variable length of the columns. When an SSRS report is rendered, it usually keep additional space from right end of body same as when Report was in design mode.

When columns are generated in report render extra space taken is converted into blank pages, but its nothing but extra space on right side report body.

1. Decrease the column length in Design Mode
2. Change report orientation to landscape (if not already), so it takes more horizontal length
3. Fix report column names (instead of dynamically generated) if possible
4. Create new report for more information and decrease overall horizontal length of report

Use any of the above options to get this fix. Unfortunately its not a permanent kind of fix but this is all we got!

Let me know if you come across this kind of situation.

SQL Server 2017 – Data Tools installation

This post to third and final part of SQL Server 2017 setup guide. We have got

1. SQL Server 2017 installed
2. SQL Server Management Studio 2018
3. Adventure Works SQL Database Sample
4. Adventure Works Multidimensional and Tabular Cube Sample

Now final piece is Tool for development of SQL Server 2017 solutions. We need BIDS (Business Intelligence Development Studio) or call it SQL Server Data Tools. Installation is quite simple.

1. Download SSDT for Visual Studio 2017 (15.9.2)
2. At installation it will ask for two things
   • Visual Studio 2017 instance if not then SSDT with Visual Studio 2017
   • All MSBI services (Integration, Analysis and Reporting)
3. Installer will do all the things for setting up Business Intelligence development setup within Visual Studio 2017, make sure Internet is connected.

That’s all, you are done with development part as well. Happy Coding!!

Comment in case of any hiccups and compliments are always welcome.