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
 SQL Server 2005 Forums
 Analysis Server and Reporting Services (2005)
 SSRS auto refresh and schedule a report

Author  Topic 

sreenu9f
Yak Posting Veteran

73 Posts

Posted - 2008-11-21 : 11:07:06
Is there a way in SSRS to auto refresh a report to generate only yesterday's record and schedule to run this on a daily basis and send the report details in email.

Thanks in advance for everyone.

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-11-21 : 12:03:44
search for sql report subscriptions in google
Go to Top of Page

sodeep
Master Smack Fu Yak Hacker

7174 Posts

Posted - 2008-11-26 : 14:15:19
See Data driven Subscription.
Go to Top of Page

sreenu9f
Yak Posting Veteran

73 Posts

Posted - 2008-12-01 : 10:54:24
This is the scenario i have.

I need to pull data from a table with only the previous days entries and output several dataelements as output in a drill down report. I need this report to be generated every day and send it as an email to a group of people.

i went through the data driven subscription tutorials and articles but this wont solve my problem.

Please any suggestions.

Thanks,
Go to Top of Page
   

- Advertisement -