Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Development Tools
 Reporting Services Development
 problems with events

Author  Topic 

spark58510
Starting Member

4 Posts

Posted - 2005-04-26 : 10:16:10
Hi all,
I've started tooling with SQL RS. It's great so far. Documentation sort of stinks though. I have no great books so far. I'm just trying to figure out the ins and outs. Building the reports seems to be the easy part. Snapshots and subscriptions seem more tricky. I can't get events to fire. For example, I set a report up to render from an execution snapshot. The snapshot is generated on a report specific schedule (of every 1 minute) for testing. I also set up (on the history tab of the report) to use a one-minute schedule to add snapshots to report history. Neither are happening. I've stopped and restarted Reporting Server, SQL server, SQL agent. The SQL agent jobs are firing every minute, but that is the only thing happening. The logs look fine. The datasource is using stored credentials (the windows service account). I'm having problems emailing subscriptions as well but think that it may be related. Any advice is greatly appreciated.
   

- Advertisement -