Its easy, just go to report property, select Page Size and set it to 59.4cm, 42cm

Cheers

SSMS (SQL Server Management Studio) do not provide any feature to turn off Auto Recovery/Auto Save option, but this will include in the future versions. Also, Microsoft will not encorporate...

Your Solution is here, Please change the SELECT Queries with your Query

SELECT * , ROW_NUMBER() OVER(ORDER BY ID) AS MY_ROW_NUM FROM

(

SELECT ID, FirstName, LastName, JoinDate FROM Table1

UNION

SELECT ID, FirstName, LastName,...