Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imranabdulaziz
Yak Posting Veteran
83 Posts |
 Posted - 2008-07-15 : 07:05:26
|
| 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 codePlease help |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-15 : 13:39:32
|
| Yup. you can do this with a subreport. incude a subreport as a new row of main report table and set visibility property of row to toggle based on first row. onclicking pass the employeecode as parameter to subreport to retrive his details. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-07-15 : 13:41:07
|
| Refer these too:-http://technet.microsoft.com/en-us/library/ms156456(SQL.100).aspxhttp://www.mssqltips.com/tip.asp?tip=1329 |
|
|
|
|
|
|
How to make subreport display based on data