webview reports - via email?

Unanswered Question
Mar 20th, 2007
User Badges:

I can find where webview reports can be scheduled and saved to a drive. However, I can't find where these reports can be scheduled and sent via email. Anyone know how to do that? Am I missing a component that does that? I'm using ICM/IPCC 7.0.

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Gergely Szabo Tue, 03/20/2007 - 10:41
User Badges:
  • Green, 3000 points or more
  • Community Spotlight Award,

    Member's Choice, December 2015

No, you are not missing anything... WebView is a Web-based tool ;-) and, as such, it cannot be made to send reports via email.


You can use, however, the feature-rich programming platform of the SQL server itself. Just create a DTS task, that will output a neat report in CSV or XLS format onto a network share... and you have it!


If you are absolutely new to the database schema of ICM and/or to SQL server itself, let me know, what you would like to see and in what format, I can help you with that (we have a customer not using WebView at all, everything is generated by SQL server and poured onto a disk in XLS format).

Actions

This Discussion