Basically, you simply call a method, pass in the SubscriptionID, and RS will do whateRe: Create

I have a VB.NET console application. The requirement is to create a summary report of records processed from an incoming txt that I split up into several txts after the process is done. During my process, I insert each row into tables so I can perform reporting on this information easily. The issue is, how can I essentially "save" there report into a specific directory after the module is done running?

I want to use SSRS 2005 which is fine but I do not know how I would create a database snapshot possibly from my m odule...to run a report I create and save the snapshot into a PDF format or something into a reports directory on anther server.

The users will be looking for these snapshots daily.

[733 byte] By [FavorFlave] at [2007-12-19]

«« Formating on data driven web tests
»» attachEvent using code-behind html

# 1

You can create a file share subscription which will cause SRS to run the report and deliver it to a file share on whatever schedule you prefer. In other words, you don't need a custom application in order to do this.

JohnGallardo-MSFT at 2007-9-8 >

top of Msdn Tech,SQL Server,SQL Server Reporting Services...

# 2

Ok, but then how can I trigger the subscription programically. I need this to run after my vb.net app runs...which is not always at the same time...so how can I tell the subscription to fire off from vb.net any time I want?

FavorFlave at 2007-9-8 >

# 3

See the FireEvent() API:

http://msdn2.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.fireevent.aspx

Basically, you simply call a method, pass in the SubscriptionID, and RS will do whatever action you have associated with the subscription.

JohnGallardo-MSFT at 2007-9-8 >

# 4

thanks, I wish Microsoft would actually finish their KBs and tell us what missing references we need to import right not this isn't recognizing in code completion:

New ReportingService2005()

FavorFlave at 2007-9-8 >

# 5

I'm still trying to figure out what references I need at the top of my .NET 2.0 console app .vb page in order for these methods to recognize

FavorFlave at 2007-9-8 >

# 6

ok, figured out how to add ReportServer2005 class although adding the web refrence is not intuitive if it's your first time trying to add a class like this. You end up using Imports yourreportname.ReportServer2005

FavorFlave at 2007-9-8 >

# 7

>>>Basically, you simply call a method, pass in the SubscriptionID, and RS will do whatever action you have associated with the subscription.

Ok, but I want it to save the report immediately; will it ignore the schedule then at this point if I use the FireEvent() method?

FavorFlave at 2007-9-8 >

SQL Server Hot Topic

SQL Server New Topic

SQL Server

Java / MSDN / Linux Tech / PHP Tech / MSDN DotNet / MSDN TECH / Health Library / Programmers Tech / visual basic Tech / Developer Tech / Ipod faqs / Msdn China Tech