How to create Access type drill down in SSRS 2008

[macroCharlie]

I have been searching the internet for two days trying to find info on this. I would like to create a report with a table that has parent-child relationship already showing. The parent and child should show row headers just like in Access. I have attached a screeen shot of an Access parent Order table with a child OrderDetail table as an example of what I want to do.

 

[xlbo]

sorry - can't access the link

If you're asking what I think you're asking, you can embed one table within the row of another table - by setting the groups appropriately you can create a parent table / child table relationship. you can then set expand / collapse options on the parent group to determine whether you see the child group or not

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[skaestner]

I came across a good how to blog on this subject at the link below

http://www.bidn.com/blogs/kylewalke...single-column-multiple-group-grouping-in-ssrs