Hi, I do have a report (Report1) with grouping with expand/collapse and details. I want to click on a row in the detail area and do not do more expand/collapse but show further details in a separate area below the main table. The user is Ok to see the only details for the row he/she clicked. So, I dont need to bring more data into the main table or put a sub-report for the row inside the main table that would kill the performance. I tried two scenarios: I put a rectangle below the main table and put a sub-report there. On the details row field in the main table Im using a placeholder that has an action but the Action is only for a bookmark, report, and url (I dont need). Im trying to jump to the same report (Report1) but as I have parameters that all are refreshed and its empty report again. And Im not sure if the needed parameter would even go into a sub-report.Im using the same details field placeholder and jumping to the sub-report as a separate report. The parameter is passing well and the sub-report is run as a separate report. I even put a textbox button Go Back to the main report. But, the main report is empty when I go there again as Id need to pass the initial parameters back there to have the same data again but itll be without expanding that it was before. I could probably pass parameters from the main report to the sub-report and save it there and pass it back to see the report with the same parameters. But, it seems a bit complicated and would require to run and re-run the same report. Is there any other way I could show a separate additional table on the same report with a parameter passed from the main table showing/hiding the additional table. Thanks

Hi, Please create a parameter with a same name in the main/sub reports and update the parameter with the value which need to be sent to the sub-report. This will automatically pass the value from the main report. If my above solution doesn't help ,please send me the screen shots of both Main and Sub reports. Good Luck

Hi, Please create a parameter with a same name in the main/sub reports and update the parameter with the value which need to be sent to the sub-report. This will automatically pass the value from the main report. If my above solution doesn't help ,please send me the screen shots of both Main and Sub reports. Good Luck Thank you so much for your response, SharePointUdai. This is a problem how could I update the parameter with the value which need to be sent to the sub-report when I click on the specific details row/placeholder/field. I also want to hide or show the sub-report but I could probably accomplish it with the IF parameter is Nothing or no data, etc. The main problem for me how to make the main report to communicate (send a value) to a sub-report. Please, see the included picture. I put the sub-report into a rectangle. I could probably use a Bookmark to jump there on the placeholder clicking. Thanks

Hi There Thanks for your posting. I dont think you can refresh sub report embedded inside main report without refreshing main report. I would suggest you please use drill through report instead. I am afraid that we cannot just refresh part of the report. It is by design of the The entire report can only be treated as a whole item. I hope this will help Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

Thank you, Syed. I'll try a one more thing on Monday and let you know if it goes through. All I need is to pass a value to a subreport, table, etc. on the same report. The whole idea is to not bring all details for every row into a main table (dataset) but to show the details in a separate sub-report or a table for the row clicked in the main table only. The sub-report or a table on the same report would use a different dataset with a parameter equal to a value passed from the main table on the same report.

Hi There Thanks for your posting again. The closest approach is hide your table initially based on parameter and by clicking on your master table uses the same report as drill through report by pass a hidden parameter value which will unhide that table. Please have a look the similar approach has been used in this blog http://www.codeproject.com/Articles/270924/Master-Details-Report-in-SSRS-2008 I hope this will help Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Hi There Thanks for your posting again. The closest approach is hide your table initially based on parameter and by clicking on your master table uses the same report as drill through report by pass a hidden parameter value which will unhide that table. Please have a look the similar approach has been used in this blog http://www.codeproject.com/Articles/270924/Master-Details-Report-in-SSRS-2008 I hope this will help Many thanks Syed Qazafi Anjum Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful

Hi Syed, thank you again. That should work. Please, let me test it on my report when I have access to a system on Monday.

Hi There Thanks, I hope this will help you, Here is already Monday morning J(New Zealand) Many Thanks Syed