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 |
|
sql_dan
Starting Member
43 Posts |
 Posted - 2010-05-17 : 07:22:44
|
| Hi Guys,I am wondering if the following is possible?I have a project in SSRS 2008 that has multiple reports in it, as the company I work for has multiple site the 1st screen you see are the logo's for said sites, upon clicking you get a list of agents that work at that site.What I was wanting to do was to click on the agent name to get the next report which is a list of that particular agents clients?Going 1 step further I would also like to be able to click on the client name to get to the final dashboard for the client.I hope that this makes sense and that there is a way to do this, or at least get round it. So far I have just defined all the parameters at each report but would love for it to be drillable!If you need any further information please let me know!ThanksDanIf you cant sleep at night, its not the coffee its the bunk! |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-17 : 12:26:53
|
| yup. what you need is to create three report and link them by means of jump to report funtionality. In first report show agent data and put jump to report option to navigate to second report which takes agent name through a parameter and shows the included client details. then again add a link on client names to navigate to final report which takes client name as parameter and gives the required clients details.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sql_dan
Starting Member
43 Posts |
Posted - 2010-05-18 : 04:06:37
|
Wonderful!! Thank you so much. As ever I was tantalisingly close!Thanks for the quick response.Dan  If you cant sleep at night, its not the coffee its the bunk! |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-05-18 : 14:11:59
|
| welcome------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Select & Use data line by line???