Hi! I am interested to create a C# application that implements the concept of reminder. Basically, at a fixed date and time, the app should pop up a reminder message. The message, date (and time) and the users that the reminder should be popped on to, are stored in the DB. Searching over the Internet and Books Online, I first found out that a possible implementation would be using the Notification Services functionality in SQL Server 2005, but later I realized that there is no NS in 2008. Now I would like to know how to implement such a functionality using Reporting Services. Thanks in advance! Best regards, Alex

Although SSRS can deliver reports to a file system directory or to a users mail inbox you should probably be looking to leverage functionality in MS Exchange or even the Outlook client. SSRS isn't really the appropriate technology for this kind of functionality. Sure, you can use SQL Server DB Engine to store the alerts and the business logic in stored procedures etc, just building a alerting / reminder system in C# and SSRS isn't going to deliver the functionality you require.

Well, any suggestions then? Using a centralized database for storing the date/time, message and user assingment for the specified requirement is essential.

Also, worth sharing: I am not interested to store anything in any text file, nor to send any e-mail. As stated, I want the application to decide what to do with a reminder (maybe just pop a window regarding it).

Hi Mang, On my experience, reporting services can't do with a reminder like popping up a window. It can delivery the message to the user maibox. If the message is different depending to the users, you can consider reporting services's Data-Driven Subscription functionality. See http://msdn.microsoft.com/en-us/library/ms169673.aspx on how to create a Data-Driven Subscription. thanks, Jerry