Custom Reports- mgmt studio

• pzmrcd

  Default port

  Points: 1419

  More actions

  July 9, 2008 at 3:55 pm

  #193694

  Hi

  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.

  Thanks

• Hari.Sharma

  SSCertifiable

  Points: 6904

  More actions

  July 10, 2008 at 1:34 am

  #840667

  Hi Pzmrcd ,

  I think you are talking about subscription of reports.

  First of all you need to deploy the report at reportserver.

  After Deployment, you can schedule the report at reportserver using report manager.

  Use Subscription features

  Cheers,
  Hari
  Tips & Tricks for SQL BI Developers