Executing report through VB.NET process

• iRobot

  Ten Centuries

  Points: 1242

  More actions

  May 28, 2009 at 7:52 am

  #205415

  I have a VB.Net process. There is no GUI and it is a console application.

  At the end of the process I need to generate some sql reporting services reports.

  The parameters are passed from the command prompt itself.

  Could someone please let me know if there is a way to fire the report,

  create the reports in pdf format by passing it parameters in this situation.

  Thanks

• Paul_J

  Hall of Fame

  Points: 3698

  More actions

  June 1, 2009 at 5:19 pm

  #1003103

  You will need to communicate with the Reporting Services web service. This will require creating a proxy class and calling the required functions.

  Haven't done it myself yet but here are a few articles that may help:

  http://www.odetocode.com/articles/95.aspx

  http://msdn.microsoft.com/en-us/library/aa179614.aspx

  http://msdn.microsoft.com/en-us/library/aa237438.aspx

  http://www.tek-tips.com/faqs.cfm?fid=5918

  Things may vary slightly depending on the version of SSRS you are using.