I am frequently asked the question “Why does a blank page get inserted every other page in an SSRS report?”
The solution is usually simple. The Body of your report could be too large for your page. Simply make sure that the Body of your report added to the left and right margin is less than the page width.
Usually it will be the margins that push you over the limit.
You can show parameters in a report with the following code:
=Parameters!Centre.Value
However if you have multivaluded parameters this will produce an error on the report (#Error).
To solve this you can use the following code to show parameters:
=Join(Parameters!Centre.Value, “,”)
You can define multi-value parameters for any report parameters however if you want to pass multiple parameter values back to a data source by using a query then the query must use an IN clause to specify the parameter.
SELECT someColumns
FROM someTable
WHERE someColumn IN(@ParameterValue)
Rather Than
SELECT someColumns
FROM someTable
WHERE someColumn = @ParameterValue