How to make subreport display based on data
-
Hi all , I am using ssrs2005. I am trying to generate a report which list employee leave detail ie Empcode , name , no of leave taken , balance leave. Now user want to see detail information of employee when he click on empcode . Is it possible using ssrs2005. I tried with subreport. How can I make subreport to be visible when he select particular employee code Please help
imran khan
-
Hi all , I am using ssrs2005. I am trying to generate a report which list employee leave detail ie Empcode , name , no of leave taken , balance leave. Now user want to see detail information of employee when he click on empcode . Is it possible using ssrs2005. I tried with subreport. How can I make subreport to be visible when he select particular employee code Please help
imran khan
I would keep it simple and make two reports, and have your main one navigate to the detail report. Add another report to the same project, and make sure you have a parameter for empcode. In the first report (the main one), go to the properties for the empcode textbox. Under the Navigation tab, choose "Jump to report", then choose the detail report in the combo box. Click the "Parameters..." button and have empcode equal to "=ReportItems!empcode.Value" (I'm assuming that the textbox for empcode is called empcode). When a user clicks on the empcode the detail report will show with the value that they clicked.