I have created reports using Visual studio 2005 /BI projects.
I can view the rpt fine.
Also when I right click from Management studio (sql server2005) choose custom rpt and point to this rpt it executed and isplays fine.
Now I want to schedule this rpt (.rdl) file to be emailed @ regular intervals. How can I schedule/ automate this email functionality for the rdl file.