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:
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, dbo.DimSalesTerritory.SalesTerritoryRegion, dbo.DimSalesTerritory.SalesTerritoryGroup, dbo.DimProductSubcategory.EnglishProductSubcategoryName, dbo.FactInternetSales...