Geeks With Blogs

Shervin Shakibi's Blog blog June 2007 Entries
Example of using SSRS SOAP API
This example uses adventure works sample database and reports, please refer to books on line for setup instructions. 1. Open Visual Studio and create a console application (VB or C#) 2. Replace the code in Module.vb or Module.cs with the appropriate code snippet a. C# using System; using SoapAPI.ReportService2005; class Module1 { public void Main() { ReportingService2005 rs = new ReportingService2005(); rs.Credentials = System.Net.CredentialCache.... rs.Url = "http://Localhost/reportser... ......

Posted On Thursday, June 21, 2007 7:51 AM

Example of using SSRS SOAP API
This example uses adventure works sample database and reports, please refer to books on line for setup instructions. 1. Open Visual Studio and create a console application (VB or C#) 2. Replace the code in Module.vb or Module.cs with the appropriate code snippet a. C# using System; using SoapAPI.ReportService2005; class Module1 { public void Main() { ReportingService2005 rs = new ReportingService2005(); rs.Credentials = System.Net.CredentialCache.... rs.Url = "http://Localhost/reportser... ......

Posted On Wednesday, June 20, 2007 9:39 PM

How to run a subscription on demand by Trigerring Events in SSRS from command line
One of my custmers wanted to use their own scheduler control all of their SSRS subscriptions. if you need to do the same here is the step by step example of acomplishing this task. Create either a datadriven or regular subscription 1. In Management studio connect to the Database Engine (local) 2. Expand the database and drill down to Report Server Database 3. Click on File à New à query with current connection 4. In the query window type the following command and execute it to get the subscription ......

Posted On Wednesday, June 20, 2007 9:23 PM

Copyright © Shervin Shakibi | Powered by: GeeksWithBlogs.net