In this example, we will change the PageSize property of the report to reveal how the page size will affect the printing layout of the report. Perform the following steps:
Create a new report and use the same data source for it,
AdventureWorksDW2012
. Then, use the following query as the query string:SELECT FirstName, LastName, BirthDate, MaritalStatus, Gender, TotalChildren, NumberChildrenAtHome, EnglishEducation, NumberCarsOwned FROM DimCustomer
Choose Tabular as the report type. Next, select all columns to be in the Details section in the Design the Table window. Rename the report to
Customers
and complete the wizard.Preview the report. In the Preview window, click on the Export button and export the report to PDF (as shown in the following screenshot):
Save the PDF file and then open it. You will notice that the number of pages is 1762 by default. Next, the pages exported to the portrait layout caused each report page to split...