How to create Report: Table Report & Matrix Report

            We have 2 tools  : VS.NET BI  or Report Builder. now i am using VS.NET BI for creating SSRS reports.

Based our sql server 2005/2008/2012 installtion we get this Business intelligence tool/SSDTools. BI responability is building our reports and testing and we have option to deploy in visual stduio ssrsproject---Properties-- TargetServiceURL location.(report is deployed).

next

we can prepare query using querybuilder also.

SELECT DimDate.CalendarYear, DimReseller.BusinessType,DimReseller.ResellerName, SUM

(FactResellerSales.SalesAmount) AS TotalSales FROM DimReseller

INNER JOIN FactResellerSales

ON DimReseller.ResellerKey = FactResellerSales.ResellerKey

INNER JOIN DimDate

ON FactResellerSales.OrderDateKey = DimDate.DateKey

GROUP BY DimReseller.BusinessType, DimDate.CalendarYear, DimReseller.ResellerName

this Querybuilder Prepares a Dataset referencing SharedDatasource(DS_AdWorks2012)with Default Name as "DataSet1". 

next

next

next

next

next

In this process automated many steps

1. Referencing Shared Datasouce
2. Prepared a Dataset--default name --"DataSet1"(Querybuilder query in it).
3. Automated Report will be generated by Report Wizard.

How to create Matix Report ?

Matrix Report :  Report ( Rows & Columns) describe the information.

now we will add --query in Querybuilder

SELECT DimDate.CalendarYear, DimReseller.BusinessType, SUM (FactResellerSales.SalesAmount) AS

TotalSales, DimDate.EnglishMonthName, DimDate.CalendarQuarter, SUM (FactResellerSales.TaxAmt) AS

TotalTax

FROM DimReseller

INNER JOIN FactResellerSales

ON DimReseller.ResellerKey = FactResellerSales.ResellerKey

INNER JOIN DimDate

ON FactResellerSales.OrderDateKey = DimDate.DateKey

GROUP BY DimReseller.BusinessType, DimDate.CalendarYear, DimDate.EnglishMonthName,

DimDate.CalendarQuarter

then -Next--- Matrix ---then

Now Name(MatrixReport_QuaterWiseEMonthBusinssetype.rdl) the report then select the Preview --Finish.

Notes :