Microsoft SQL Server 2014 Business Intelligence Development: Beginner’s Guide

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, ...