CODEWITHSUNDEEP
ssrs-2008reporting-services
Alex Gordon
Alex Gordon

Reputation: 60751

how to insert another level of drill down into report?

I currently have a working drill down report.

I would like to add another level of drill down, and I do not know how to do it.

I have this right now:

enter image description here

But the last row that shows <<Expr>> needs to be included under the row above it.

How can I include an extra level of drill down?

I did what @eestein recommended, and here's the result:

enter image description here

as you can see the bottom row has not been associated with the one above it!

Upvotes: 0

Views: 1360

Answers (2)

eestein
eestein

Reputation: 5114

Ok, from you last comment I think I understood what you mean. To accomplish that you will need to create an element in the row above a + sign, for instance, and then bind that to the hidden property of your row below.

  1. Create an element with a + sign
  2. Press F4 on the row you want to expand/retract
  3. Roll all the way to the end until you see the visibility group
  4. On ToggleItem select the name of the item with a + sign
  5. Set your Hidden to true

http://technet.microsoft.com/en-us/library/dd220405(v=sql.105).aspx

Upvotes: 1

djangojazz
djangojazz

Reputation: 13242

It sounds like you just want two levels of 'detail' but that may be in a group as well. SSRS has an option when you click in a cell you can choose 'Insert Row' that expands to 'Inside Group ...' or 'Outside Group ...'. If you want a parallel level of detail continued with a prior row just choose 'Inside Group' and it should continue information only level to that level of either 'Detail' row, 'Parent Group1', 'Parent Group2' etc...

Upvotes: 1

Related Questions