SQL Data Source=(local);Initial Catalog=AdventureWorks true f3057d13-47d2-41db-9154-e016fb9bc828 ProductCategory System.String SubCategory System.String OrderYear System.Int32 OrderQtr System.String SalesAmount System.Decimal Territory System.String Region System.String DataSource1 SELECT PC.Name AS ProductCategory, PS.Name AS SubCategory, DATEPART(yy, SOH.OrderDate) AS OrderYear, 'Q' + DATENAME(qq, SOH.OrderDate) AS OrderQtr, SUM(SOD.UnitPrice * SOD.OrderQty) AS SalesAmount, Sales.SalesTerritory.[Name] AS Territory, Sales.SalesTerritory.[Group] AS Region FROM Production.ProductSubcategory AS PS JOIN Sales.SalesOrderHeader AS SOH JOIN Sales.SalesOrderDetail AS SOD ON SOH.SalesOrderID = SOD.SalesOrderID JOIN Production.Product AS P ON SOD.ProductID = P.ProductID ON PS.ProductSubcategoryID = P.ProductSubcategoryID JOIN Production.ProductCategory AS PC ON PS.ProductCategoryID = PC.ProductCategoryID JOIN Sales.SalesTerritory ON SOH.TerritoryID = Sales.SalesTerritory.TerritoryID WHERE (SOH.OrderDate BETWEEN '1/1/2003' AND '12/31/2004') GROUP BY DATEPART(yy, SOH.OrderDate), PC.Name, PS.Name, 'Q' + DATENAME(qq, SOH.OrderDate), PS.ProductSubcategoryID, Sales.SalesTerritory.Name, Sales.SalesTerritory.[Group] false false false true ProductCategory System.String SalesAmount System.Decimal Cost System.Decimal Revenue System.Decimal DataSource1 SELECT PC.Name AS ProductCategory, SUM(SOD.UnitPrice * SOD.OrderQty)/1000000 AS SalesAmount, SUM(P.StandardCost * SOD.OrderQty)/1000000 AS Cost, SUM(SOD.UnitPrice * SOD.OrderQty)/1000000-SUM(P.StandardCost * SOD.OrderQty)/1000000 AS Revenue FROM Production.ProductSubcategory AS PS JOIN Sales.SalesOrderHeader AS SOH JOIN Sales.SalesOrderDetail AS SOD ON SOH.SalesOrderID = SOD.SalesOrderID JOIN Production.Product AS P ON SOD.ProductID = P.ProductID ON PS.ProductSubcategoryID = P.ProductSubcategoryID JOIN Production.ProductCategory AS PC ON PS.ProductCategoryID = PC.ProductCategoryID JOIN Sales.SalesTerritory ON SOH.TerritoryID = Sales.SalesTerritory.TerritoryID WHERE (SOH.OrderDate BETWEEN '1/1/2003' AND '12/31/2004') GROUP BY PC.Name false false false true Product Category true true #528ae7 Bold White 2pt 2pt 2pt 2pt Sub Category true true #528ae7 Bold White 2pt 2pt 2pt 2pt 1in 1in 1in 1in 0.25in =Sum(Fields!SalesAmount.Value) true true Normal C0 2pt 2pt 2pt 2pt =Sum(Fields!SalesAmount.Value) true true Bold C0 2pt 2pt 2pt 2pt =Sum(Fields!SalesAmount.Value) true true Normal C0 2pt 2pt 2pt 2pt =Sum(Fields!SalesAmount.Value) true true Bold C0 2pt 2pt 2pt 2pt 0.25in =Sum(Fields!SalesAmount.Value) true true #c0c0c0 Bold C0 2pt 2pt 2pt 2pt =Sum(Fields!SalesAmount.Value) true true #c0c0c0 Bold C0 2pt 2pt 2pt 2pt =Sum(Fields!SalesAmount.Value) true true #c0c0c0 Bold C0 2pt 2pt 2pt 2pt =Sum(Fields!SalesAmount.Value) true true #c0c0c0 Bold C0 2pt 2pt 2pt 2pt 0.25in =Sum(Fields!SalesAmount.Value) true true Bold C0 2pt 2pt 2pt 2pt =Sum(Fields!SalesAmount.Value) true true Bold C0 2pt 2pt 2pt 2pt =Sum(Fields!SalesAmount.Value) true true Bold C0 2pt 2pt 2pt 2pt =Sum(Fields!SalesAmount.Value) true true Bold C0 2pt 2pt 2pt 2pt =Fields!Region.Value 0.25in =Fields!Region.Value true true #528ae7 Bold White 2pt 2pt 2pt 2pt 0.25in Total true true #528ae7 Bold White 2pt 2pt 2pt 2pt =Fields!OrderYear.Value 0.25in =Fields!OrderYear.Value true true #528ae7 Bold White 2pt 2pt 2pt 2pt 0.25in Total true true #528ae7 Bold White 2pt 2pt 2pt 2pt =Fields!ProductCategory.Value 1in =Fields!ProductCategory.Value true true #528ae7 Bold White 2pt 2pt 2pt 2pt =Fields!SubCategory.Value 1in =Fields!SubCategory.Value true true #c0c0c0 Bold White 2pt 2pt 2pt 2pt 1in Total true true #c0c0c0 Bold White 2pt 2pt 2pt 2pt Before 1in Total true true #528ae7 Bold White 2pt 2pt 2pt 2pt 1in Total true true #528ae7 Bold White 2pt 2pt 2pt 2pt Before DataSet1 5.92667cm 0.42333cm 2.54cm 15.24cm =Fields!Region.Value =Fields!OrderYear.Value =Sum(Fields!SalesAmount.Value) Primary Primary Black 1pt 30pt 0pt Axis Title False 0.5 NaN NaN NaN 6pt 10pt Axis Title False 0.5 NaN Opposite NaN NaN 6pt 10pt Axis Title 0.5 NaN NaN NaN 6pt 10pt Axis Title 0.5 NaN Opposite NaN NaN 6pt 10pt None Normal 8pt Normal None 7pt Black Black Chart Title BrightPastel No Data Available DataSet1 9.49854cm 0.42333cm 8.01688cm 15.24cm 1 White None 1in 2.47917in 1in 0.25in true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt true true 2pt 2pt 2pt 2pt 1.96875in =Fields!ProductCategory.Value true true 2pt 2pt 2pt 2pt 75 54 90 180 0pt 0pt External true RoundedWithWideIndentation 33 Tapered White DiagonalLeft Orange None 1pt =Sum(Fields!SalesAmount.Value) 1 Zero 25 0pt 0pt External 25 Wedge Cross 10 Marker 0pt 0pt External true RoundedWithWideIndentation 33 Tapered Red DiagonalLeft Orange None 1pt =Sum(Fields!Cost.Value) 1 0pt 0pt External 25 Wedge Inside 15 0pt 0pt External true RoundedWithWideIndentation 33 Tapered #008000 None #00ff00 None 1pt =Sum(Fields!Revenue.Value) 1 Zero 0pt 0pt External 25 Wedge Inside 15 Red DiagonalLeft #00ff00 None 0pt 30 0 1 60 1 15 30 Inside CornflowerBlue None White None 0pt NaN NaN 60 1 0 1 NaN NaN DimGray Cross External 18 2 NaN NaN DimGray Cross External 8 1 0 WhiteSmoke Cross true External 6 6 Circle 0 WhiteSmoke Cross true External 6 6 Circle NaN NaN 0 true true true true 0 WhiteSmoke DiagonalLeft Gainsboro None 0pt Edged CustomSemiCircularN1 External true External 1.48 100 100 true Gainsboro DiagonalLeft Gray None 0pt External External DataSet2 White Vertical Thermometer Red None Red None 0pt =Sum(Fields!SalesAmount.Value) 1 0pt 0pt External 25 Wedge Cross 9.5 CornflowerBlue None White None 0pt NaN NaN 60 1 0 1 NaN NaN DimGray Cross External 15 2 NaN NaN DimGray Cross External 9 1 0 WhiteSmoke Cross true External 6 6 Circle 0 WhiteSmoke Cross true External 6 6 Circle NaN NaN true true true true 0 WhiteSmoke HorizontalCenter DarkGray None 0pt Edged RoundedRectangular External true External 0.346 100 100 true Gainsboro DiagonalLeft Gray None 0pt External External DataSet2 White After DataSet2 5.63563cm 11.37709cm 2 17.51542cm 16.51cm 0.635cm true true 0.635cm true true 356mm 216mm 2cm 2cm 2cm 2cm