Master Detail on the same report but different areas on the report

Question

Post reply

Master Detail on the same report but different areas on the report

steve.roberts 33898

SSC Enthusiast

Points: 122
More actions
May 15, 2014 at 2:40 am

#396759

Hi there I am trying to write a report which will display data, one column, down the left hand side of the report and then when you click on a value the centre part of the report will display details of that item e.g. a subreport. It is separate to the rows on the left hand side.
I’m sure this is the easiest thing in the world for some people but I just can’t seem to find a way to do this in SSRS. I am aware of the Document Mapping but that does not seem like the answer for this as it looks more like going to place holders. I also realise you can’t do the visibility option as one tablix item can’t control another tablix item.
I have attached an illustration if it helps.
Any help will be appreciated…at this stage I am guessing this may be a limitation of SSRS.
Big thanks,
Steve

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

syedathariqbal Hall of Fame Points: 3175 More actions · Answer 1

If I understand correctly, this can be achieved by using DrillThrough action on textboxes of your left column?

have you explored that option ?

Basically you would be drilliing through a different RDL which have the detailed information.

On way to do this is to create as many RDLs as many values in your textboxes on left. And suitably drill rhtough the suitable child report according to the click action a particular textbox. This is not a Neat solution, agreed, but should solve your problem.

OR,

You can have just two RDLs,

One RDL would be the Main report, the example which you have shown, then again a Drill Down and the detailed information could be parameterized and show values or Fields according to the values selected. By saying parameterized, when you click on txtbox 1, pass parameter value as 1, when click on txtbox2, pass parameter value as 2 and so on.

In detailed report, when showing values...write a IIF statement...

IIF(Parameters!paramName.value=1, <values or fields...>,<values or fields...>)

Hope this helps.

steve.roberts 33898 SSC Enthusiast Points: 122 More actions · Answer 2

Hi Thanks for the reply,

I think the second option is heading towards my type of solution I think!!

I dont think my diagram probably did it justice...the items on the left will be populated from a query i.e. a list so i dont know how many items there will be.

So need to click one of these items brought back and then the report on the right populates with the detail BUT stays in place so not like a normal drill down if that makes sense?

If the detail on the left is just that can you do a on click type of event or action or something to pass to the right hand side report (rdl)?

Thanks again,

Steve

syedathariqbal Hall of Fame Points: 3175 More actions · Answer 3

I would believe that the solution I mentioned should be fine even if the number of values in column is unknown (as is normally the case, its determined by query and would be shown by a row grouping).

Now, the way I would expect it to work is - On the Right click on the txtbox of your first column, you go to Txtbox Properties, go to Actions tab and specify the child report (create a child report for this first),

then the tricky part -You need to pass 1 parameter, which will have different values depending on the values in the field. Something like below...

Parameter Name - pDrill

Value -

SWITCH(

Fields!FieldName.Value="value1",1

Fields!FieldName.Value="value2",2

Fields!FieldName.Value="value3",3

Fields!FieldName.Value="value4",4

....

)

So, this parameter has now different values depending on which value you click on your textbox. Lets use it to show the required value in Child Report (assuming you have create it by now).

TextBox value =>

SWITCH(

Parameters!pDrill.value=1,<value you want to show1 or fieldname1.value>,

Parameters!pDrill.value=1,<value you want to show2 or fieldname2.value>,

Parameters!pDrill.value=1,<value you want to show3 or fieldname3.value>

.....

)

I wish I could create a RDL and share across.

steve.roberts 33898 SSC Enthusiast Points: 122 More actions · Answer 4

Hi Thanks again for the reply.

OK very quickly just mocked something up, ignored params for now, just for concept.

I have attached a screen shot so you can see what i am doing.

So got the table on the left with one column and a subreport on the right.

I set the textbox property, as per the screen shot, to action and subreport (there was no child report so assume this is what you mean 🙂 ) and enter the subreport name as that of what is on the right.

When you run the report and click the left list items the subreport opens in a new window (i was looking for it to activate the subreport) so you always have to do a back buttom type operation to go back...hope that makes sense. I'm wondering if it may not be possible to populate the subreport on the same page like this.

I'm sure i am doing something really thick here and appreciate your time.

Thanks

Steve

syedathariqbal Hall of Fame Points: 3175 More actions · Answer 5

Any specific reason you want to use Subreport here ? You can just as well create a single tablix to show the same layout as in screenshot.

I would try to do a mokeup later in the Day or tomorrow to send you across a RDL or screenshots with a possible solution as per my understanding.

I hope I won't confuse you further by saying that this Drill through action might not even need two RDLs. You can refer the same report on click action of the textbox and show values accordingly (the parameterized option as I mentioned in previous post.)