question

parupalli avatar image
parupalli asked

parent/child data regions in ssrs

I have a data set and two data regions coming from same data set. I want to link the two data regions so that if I click on the ID column of the first data region the related data must be displayed in the second data region.

My question is how to link the two regions( the child region being a hidden table should display when I click on the ID column in Parent region which is also a table).

ssrs
10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

·
Fatherjack avatar image
Fatherjack answered

You can set the visibility property of the child object to False and have it controlled by the parent object. I am pretty sure that you will need to nest the child inside the parent eg having a table group header as the parent controlling the visibility of the data rows inside that group. Your description seems to infer that the parent and child are not necessarilly nested in that way so you may have to redesign slightly for the functionality to be available. Its set on the Child object, properties dialog - Visibility|visibility can be toggled... When its set you get a + by the parent to show that it can expand something and a - when it can close/hide the child object

10 |1200

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.