SQL Server Management Studio - Standard Reports

  • in the sql 2005 management studio, we can create a report by right clicking the database name (standard reports > disk usage, etc) which is absolutely great.

    Is there query that can be used to export the standard/custom reports functionality to a file from the SQL Management Studio without the need to install the reporting service?

  • If you don't mind doing it yourself, right-click on the preview of the actual report - you will get an option to export it (Excel and Adobe PDF were my choices).

    ----------------------------------------------------------------------------------
    Your lack of planning does not constitute an emergency on my part...unless you're my manager...or a director and above...or a really loud-spoken end-user..All right - what was my emergency again?

  • well, the idea was to create a scheduled job to create and send the report as a file.

    to get just the information, off course i can just send a normal query to get all the details, but the standard repot already look nice, it'll be good if i can just use the format and send it as a file.

    alternatively, I can create my own report using the reporting service, but that's why i'm trying to find out, if i can have the repot without installing RS (i.e IIS).

    cheers.

  • I think there's a way to see the query run by the report, but I can't find it right now. The fallback position it to put profiler on and then run the report. You'll see the precise query being run for that report and you can use that within your scheduled process.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • i've tried to use the profiler. but i think the command that runs the actual report is not a sql command (though you can see it trying to get the information).

    do you know the command to run a query that will produce export the standard/custom report to a file? if this is possible off course. thank you.

  • My own experience and what I've been able to find, there isn't any way to directly access the reports themselves. They're not stored as .rdl files, which is what you'd have to do to add custom reports. So they're built in to SSMS in some fashion. But the TSQL is available. Here's someone else discussing the same issue:

    http://blogs.technet.com/andrew/archive/2007/11/14/sql-server-monitoring-reports.aspx

    And this is the source code from MS. They've been trying to turn the reports into reporting services files themselves

    http://blogs.msdn.com/sqlrem/archive/2006/08/30/SSMS_Reports_3.aspx

    That's the best I can do. Sorry.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

  • For those who are still looking for Standard Report RDLs:

    URL: http://blogs.msdn.com/cfs-file.ashx/__key/CommunityServer-Components-PostAttachments/00-00-73-29-10/SSMS-Standard-Reports.zip

    Nice Caring & Sharing DBA,

    Ranjith Nair

  • I would like to know if it is possible to create a scheduled job which would run one of the Standard Reports and send the exported file to a pre-determined folder?

  • Yes, it's possible. You could create a subscription for the respective report and make output as Windows folder. The different options available are Email the results as HTML, Email as attachment, & Windows folder.

  • Hi,

    I am working to on publishing all Management Datawarehouse reports and following the profiler trick to get the queries,by any chance is there a location for MDW reports .rdl files similar to standard reports.

    Any help on this is highly appreciated

  • Please vote on 583296 on https://connect.microsoft.com/SQLServer

  • Check this BLOG, they have a couple of MDW RDLs: http://blogs.msdn.com/b/sqlrem/archive/tags/mdw+reports/

  • Thanks for the Link I have already deployed these by using profiler RPC trace. I am not able to repeat the same for Wait Types report and its very painful to create reports using tracing tools.

  • Where can you download the standard reports for SQL Server 2005?

  • Never mind. I found them. My laptop had not been service packed. I installed SP2 and all is well.

Viewing 15 posts - 1 through 15 (of 18 total)

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