January 6, 2014 at 3:09 pm
I am trying to display a subreport on the same page based on clicking a column text of the main report.
Here are the steps I follow.
For Main report : Enter parameter value : "30 days"
It gives me a table of employees present for 30 days.
When I click on employee name Say - John from within this table , a subreport should come up displaying his salary information in another table.
I have already created two tables.
I am able to see the subreport when visible when
I make the subreport hidden I somehow don't know how to pass the parameter from Namecolumn to the subreport and make it visible.
Any advise
January 7, 2014 at 5:53 am
Sounds like you need to toggle the visibility of the subreport. Or create a parameter to show the sub report.
January 7, 2014 at 8:24 am
Can you explain how? , in this case
January 8, 2014 at 6:38 am
When you create the sub report, you actually can go the properties windows of the subreport and set the parameter to be the selected employee id. This link should help. http://technet.microsoft.com/en-us/library/ms160348(v=sql.100).aspx. You will need to figure out what you want to do when the report and subreport first appears... ie if the parameter field for the subreport is xxxx (first run) then hide subreport.... else if parameter is an employee high toggle the hide property to false.
This article may also be helpful.
http://www.bidn.com/articles/reporting-services/107/ssrs-%E2%80%93-creating-a-master-detail-report
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply