SSRS : How to fit PDF export on one page in reporting services avoid column splitting to multiple pages

In SSRS when exporting all the columns and records to PDF, if it is larger column volumes then it is getting splitted to 2nd page or multiple pages.

To fix this follow the below steps.

1. Go to Report Properties ->Interactive Size 
2. Make sure width and Height is more than the report Body width and height size.
3. change the report Properties-> Margins to .5 in

Run the Report. Now all the columns will fit to the one page.

Connecting to the Integration Services on the computer failed with following error : Access Denied

Installed SQL Server Integration Services. While tried to login Integration Services getting Access Denied Error. 

It will work fine when tried to login with Management Studio as "Run as a Administrator".

Here are the steps to access:

1. Run ->  dcomcnfg.exe

2. Navigate to Component Services ->Computers -> My Computer -> DCom Config

3. Search Application Name "Microsoft SQL Server Integration Services 11.0"

4. Open Properties:

5. Open Each edit option and add current user.

6. Save your changes.

7. Restart Your Service if required.

Watch the video for the details: