Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By : Abolfazl Radgoudarzi, Reza Rad
Book Image

Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide

By: Abolfazl Radgoudarzi, Reza Rad

Overview of this book

Table of Contents (19 chapters)
Microsoft SQL Server 2014 Business Intelligence Development Beginner's Guide
Credits
About the Author
About the Reviewers
www.PacktPub.com
Preface
Index

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