Often the report doesn’t fit within the boundaries of the page and these results in part of a tale being moved to the next page. When you want to get rid of this behaviour and try and render the report within the single page try changing the report layout to landscape mode by doing the below steps:-
Click on Report on the top menu of BIDS
Select Landscape mode as the report Orientation and press OK.
Now when you export the report to say PDF the report will look as shown below.
This post was written by Jayanth Kurup. A Microsoft SQL Server Consultant and Trainer based out of Bangalore, India. Jayanth has been working on MS SQL Server for over 15 years. He is a performance tuning and Business Intelligence expert. Having worked with companies like Microsoft, DELL, Wells Fargo, Thomson Reuters and many other fortune 100 companies. Some other technologies Jayanth works on include Microsoft Azure, PowerBI, Python and AWS. When he isn’t consulting or training, Jayanth like to travel, paint and read. He is also very active in social causes and the founder of Enabled Business Solutions. Visit his company by clicking the link in the menu or email him directly.