December 17, 2007 at 4:30 pm
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?
December 17, 2007 at 5:37 pm
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?
December 18, 2007 at 1:22 am
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.
December 19, 2007 at 5:35 am
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
December 20, 2007 at 4:03 pm
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.
December 21, 2007 at 6:47 am
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
July 22, 2010 at 9:14 am
For those who are still looking for Standard Report RDLs:
Nice Caring & Sharing DBA,
Ranjith Nair
August 2, 2010 at 10:48 am
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?
August 2, 2010 at 11:06 am
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.
August 3, 2010 at 1:46 pm
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
August 4, 2010 at 11:58 am
Please vote on 583296 on https://connect.microsoft.com/SQLServer
August 4, 2010 at 10:51 pm
Check this BLOG, they have a couple of MDW RDLs: http://blogs.msdn.com/b/sqlrem/archive/tags/mdw+reports/
August 5, 2010 at 12:02 pm
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.
August 12, 2010 at 3:12 pm
Where can you download the standard reports for SQL Server 2005?
August 13, 2010 at 7:41 am
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