Report Generation and Notification
Hi,We need to generate the reports in a file share location and notify the Users about the location. Since the subscriptions support either File share or Email notification, we have configured file share mode in our subscriptions. We tried writing a custom C# component to send emails to the Users but getting the status of reports generation is difficult.Is there a way to notify the users after generating the reports in a file share?Subash
November 9th, 2007 3:26am
I would use the C# app to create the report, save it to a share, and then send the email.
This way you control all of the steps.
I have a code example here:
http://bobp1339.blogspot.com/2007/11/rendering-ssrs-2005-reports-with-web.html
peace
BobP
Free Windows Admin Tool Kit Click here and download it now
November 9th, 2007 4:07am
We proposed this solution already but the architects rejected it....Is there any other way for this?
November 12th, 2007 10:44pm
1, Run the subscriptions as normal, and write a C# app to use a filesystemwatcher component that send the email when new files are dropped in the directory.
2. Write an app to call the listsubscriptions method of the web service:http://technet.microsoft.com/en-us/library/microsoft.wssux.reportingserviceswebservice.rsmanagementservice2005.reportingservice2005.listsubscriptions.aspx
Of course, that would be some sort of polling mechanism, but you could check the status and send emails when appropriate
3. Set up sharepoint integration: deliver the reports to a document library in sharepoint, and have notifications (or rss feeds) set up for the document library.
Mike G.
Free Windows Admin Tool Kit Click here and download it now
November 12th, 2007 11:04pm
I'd like to do something similar.
one problem I see with most of these is that the UI provided by report server when reports are run immediately must be duplicated and those report parameters passed as arguments to the webservice call. Is there anyway to use the report server parameter input UI, have it call the appropriate URL to render the report, but have the rendering done in teh background (so that the user gets control back immediately), and then send the report by email/file share.
I dont mind writing some code but I'm after a cheap and cheerful solutioon to this for now.
December 24th, 2007 3:05pm
There is a really interesting reporting/docgen system where you design the templates in Microsoft Office. Makes the layout trivial. There's a good review of it
at
An Evaluation of Windward Reports.
Free Windows Admin Tool Kit Click here and download it now
November 15th, 2010 1:22pm