Time for action – designing reports and working with the local processing mode

In this example, we will use the local processing mode feature in the ReportViewer control to design a new report based on the data in the AdventureWorks sample database, and the report data will be shown in the application form. For this sample, we will be using a Windows form application created in the previous examples. Now, perform the following steps:

  1. Open SSMS, connect to a local instance of SQL Server in your machine, and run the following script on the AdventureWorksDW2012 database to create a view of the sales information:
    CREATE VIEW [dbo].[SalesView] AS SELECT dbo.DimProduct.EnglishProductName, dbo.DimProductCategory.EnglishProductCategoryName, dbo.DimSalesTerritory.SalesTerritoryCountry, ...

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

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.