Hi, I'm trying to create a nested table/matrix like this... instead of this... anyone who knows the trick?

You need to create grouping in your report. Check the following thread, it will help you: http://social.msdn.microsoft.com/Forums/en/sqlreportingservices/thread/5d2eef42-c21f-46b0-9a1b-7d96cf3393a8 Please mark as answer if this helps. Thank you. http://thebipalace.wordpress.com

Hi SaeedB, I created groupings in my report. However, the result I'm getting is the second image I have posted above. What I'm looking for is how to format the table groupings as in my example of the first image in my post above. Thanks...

Hi benok2, According to your description, I tried the same scenario in my sample and get a nested table which is just you want. Generally speaking, create three individual groups which represent Region, Area, Territory respectively, then add two parent groups on details in each individual group, details please refer to the following steps, Step one: Region group 1. Drag a table into the design surface and add data fields to the table. 2. Right-click the product text box, select “Parent Group” below Row Group. 3. Select Region from the “Group by:” drop-down list, check “Add group header”, and click ok. 4. Right-click the product text box, select “Parent Group” below Row Group. 5. Select Category from the “Group by:” drop-down list, check “Add group header” and “Add group footer”, and click ok. 6. Select Category data field in the text box which is above the Product data field text box, and select region data field in the text box which is above the Category field text box we have filed data previously. Step two: Area group 1. Right-click the Region group, select “Add Group”, select “Adjacent Below…” 2. Select Product from the “Group by:” drop-down list, and click ok. 3. Select Product data field in the textbox which is align with the previous product data field textbox. 4. Repeat 2~6 steps I have mentioned in step one, add Area and Category groups on the Product data field. Step three: Territory group 1. Right-click the Area group, select “Add Group”, select “Adjacent Below…” 2. Select Product from the “Group by:” drop-down list, and click ok. 3. Select Product data field in the textbox which is align with the previous product textbox. 4. Repeat 2~6 steps I mentioned in step one, add Territory and Category groups on the Product data field. Step four: Delete all columns which you don’t need. Note: a prompt dialog box appears while you delete those columns, please check “Delete columns only” option. If you check “Delete columns and associated groups”, all associated groups which you have created will be lost. After you complete those steps, you will find the report like below: If you have any question, please feel free to ask. Thanks, Eileen Zhao