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 |
|
tmcivery
Starting Member
46 Posts |
 Posted - 2008-07-30 : 13:10:59
|
| Hello all,I was wondering if anyone can tell me if SSRS can pass parameters to a web service and get back results? We need a few reports to send a startdate and time and an enddate and time as well as a location parameter to a web service which will process the information for a given location(there are multiple locations that have their own hours of operation) and send back a duration. Can this be done with SSRS?Any direction would be appreciated.Tony |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-07-30 : 13:17:41
|
| You can call .NET functions in SSRS. They can even be custom functions from a dll. So write a .NET function that does what you want, load the dll into the report, then pass the values to the dll.We are doing this in a mission critical application.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
 |
|
|
|
|
|
Can SSRS pass parameters to a web service?