Time for action – changing a page's properties

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:

  1. 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
  2. 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.
  3. Preview the report. In the Preview window, click on the Export button and export ...

Get Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial