Post reply

Make use of reports in Sql Server 2005/2008

  • September 28, 2011 at 9:26 am

    #257994

    Hi All,

    I would like to know if we can make use of the reports the SQL Server has built inherently.

    Can we generate the reports by some job and store them in a location in pdf or some file format?

    To add more usage, can we email the reports through DB mail? Especially reports like Log shipping status, Disk usage by table etc...

    Thanks!

  • September 28, 2011 at 11:07 am

    #1387958

    For example, right click on the report and choose Export. You can export to Excel and .pdf file.

  • October 3, 2011 at 9:31 am

    #1389606

    Thats a manual way of doing it on demand. I would like to know if we can automate it?

  • October 3, 2011 at 11:21 am

    #1389703

    krishna.vanne (9/28/2011)

    Hi All,

    I would like to know if we can make use of the reports the SQL Server has built inherently.

    Can we generate the reports by some job and store them in a location in pdf or some file format?

    To add more usage, can we email the reports through DB mail? Especially reports like Log shipping status, Disk usage by table etc...

    Thanks!

    Yes, you can- create subscription and send let say daily report by email

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply