Prepare the horizontally repeating record layout, by using the field selector in Report Builder as shown in Figure 4, to select Subcategory for the Columns header textbox and Category for the textbox beneath it.įigure 4. Delete the matrix row group to achieve the horizontal layout Thereby, the row header and the dynamic group are deleted, and this matrix will only repeat its, now static, rows horizontally.įigure 3. Right-click into the Rows header, and in the context menu, select Row Group -> Delete Group, and then chose the option to “Delete group and related rows and columns”, as shown in Figure 3. Matrix report item, before defining grouping and binding to data Figure 2 shows a new empty matrix on the report design surface.įigure 2. ON DimProduct.ProductKey = FactResellerSales.ProductKeyĭimProductCategory.EnglishProductCategoryName,ĭimProductSubcategory.EnglishProductSubcategoryNameĬategory, Subcategory Designing the reportĪdd a new matrix report item to represent the fixed layout for each set of data to repeat (in this example, product information). ON DimProductSubcategory.ProductCategoryKey = DimProductSubcategory.ProductSubcategoryKey , SUM(FactResellerSales.OrderQuantity) AS QtyĭimProduct INNER JOIN DimProductSubcategory , DimProductSubcategory.EnglishProductSubcategoryName AS Subcategory Launch Report Builder and create a new data source for the AdventureWorksDW sample databases.Ĭreate a dataset query to include the FactResellerSales, DimProduct, DimProductSubcategory and DimProductCategory tables, as shown below: SELECTĭimProductCategory.EnglishProductCategoryName AS Category
To design the dataset, use the following steps:
This example uses the AdventureWorksDW for SQL Server sample database, which you can download from here: Figure 1 shows the finished report.įigure 1. The report design uses Report Builder, based on a grouped query to return a product category, subcategory, and an aggregated business measure.
0 kommentar(er)
