Tree Rendering with Reporting Services - my BI Power Hour Demo

This is the end result of the report I created in under 10 minutes during the BI Power Hour at TechEd 2006. It uses a matrix report and takes advantage of the parent-child nature of data mining content to render the hierarchy.

The .rdl file for this report is attached. All you have to do is change the connection and query string to point to your server and tree as appropriate.

<added bitmap 'blue' 8/1/2006 - jamiemac >

tree.zip

Comments

• Anonymous
  February 05, 2008
  I don't know how to solve this reporting services requirements using Matrix control. Can someone help me please?        Col1    Col2    Row Total       % Of Grand Total City1   Store1       11      12      23      10.85%   Store2       21      22      43      20.28%   Total        32      34      66      31.13% City2   Store3       31      32      63      29.72%   Store4       41      42      83      39.15%   Total        72      74      146     68.87% Grand Total     104     108     212     100.00%

1. The number of columns is unknown until run-time.
2. % Of Grand Total = Row Total / Grand Total
3. Display grouping of stores by city without using a separate column, only padded by spaces.
4. Display sub-total for each city without using a separate column, only padded by spaces. Please reply to my email bo_dong@yahoo.com Thanks a lot!