Reporting Services
I have spent quite some time latetly creating two SQL Server Reporting Services reports that read data from a Web services. Given that I had to solve a couple of non-trivial issues and that I did not find much documentation, I have written a few tips in this article. Tip 1: How to specify the value of the WS complex type parameter? Tip 3: How to pass another dataset as XML to the Web service? Tip 2: How to read XML from a database without truncation of the results? Technorati tags: SQL Server, SSRS,...