SSRS | How to configure SQL Server Reporting Services 2017

Step by Step to configure SQL Server Reporting Services 2017

Remove Question Mark (?) and Show Correct Total Number of Pages in SSRS Report

SSRS Report: Remove Question Mark (?) and Show Correct Total Number of Pages.

Add textbox in report header area.
Go to expression.
Do to : Built-in-Fields->overall total pages

Set the visibility status to Hide. Run the report again.

Watch Below Video for more details:

SSRS report: Parameter left blank to select all record

There are several ways to show all records when parameter field left blank.
For Single Valued parameter:

All records are displayed without parameter.

Now Add parameter and select check box for Allow blank value

Modify the data set to accept the parameter value.

When run the report we can't see the record for blank values.

So modify the data set to accept blank value.

Now again run the report. You can see all the records for the blank value passed through parameter.

You can view the Video below for more detail:

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.