Hi, I have to design couple of snapshot reports. These reports are not supposed to run on a schedule. They must run based on a event. That is when the .net application runs a process and populates a table. Again the report snapshot needs to be generated only if there is data corresponding to that report. How do I implement this? can any one share your experience. Thanks, Gopal
There is a feature called data subscription in SQL Server 2005 Reporting services http://www.sqlservercentral.com/articles/Development/2824/ http://www.databasejournal.com/features/mssql/article.php/3370191
Hi Dinesh, I am aware of data driven sbscriptions. Is there a way to generate a snapshot based on a event and that too if there is data to report. Is Crystal Enterprise is a better solution for this type of reporting needs? Thanks, Gopal