Many Object Explorer nodes in SQL Server Management Studio display a set of standard reports created by Microsoft which summarize typically requested server information. Starting with SQL Server 2005 service pack 2, SQL Server Managemetn Studio lets administrators run custom reports created in SQL Server Business Intelligence Development Studio from SQL Server Management Studio.
Custom reports stored as report definition (.rdl) files are created by using Report Definition Language (RDL). RDL contains data retrieval and layout information for a report in an XML format. RDL is an open schema; developers can extend RDL with additional attributes and elements. Reports may execute any valid tsql statement within the report.
If Object Explorer is connected to a server, custom reports can execute in the context of the current Object Explorer selection if they reference that node's report parameters. This enables a report to use the current context, such as the current database, or a consistent context, such as specifying a designated database as part of the tsql statement that is contained in the custom report.
A custom report may be run in two ways in SQL Server Management Studio:
We recommend that users who have many custom reports organize them using file system folders.
Custom reports run using the permissions of the current user. Permissions on the file system folder that contains the report files should be set to restrict access to prevent a malicious user from changing the queries run by the report.
Both the user and the account that is used by the SQL Server service require read access to the file system folder that contains the report files.
Any valid .NET command can be embedded in a report but it will not be executed.
Warning Any valid T-SQL statement can be embedded in and executed from a report. Running a report under a high privileged user account makes it possible that any of these embedded instructions can execute without challenge.
This topic describes how to create a simple SQL Server Reporting Services report saved as an .rdl file, and then add that rdl file to SQL Server Management Studio as a custom report. This topic focuses on adding the report to Management Studio. SQL Server Reporting Services can create a wide variety of sophisticated reports. For more information about creating reports, see Reporting Services Tutorials. To create a report using this topic, you must have SQL Server Business Intelligence Development Studio installed on your computer. You do not need to install SQL Server Reporting Services to run a custom report using Management Studio.
To create a simple report saved as an rdl file
SELECT session_id, net_transport FROM sys.dm_exec_connections;
To add a report to Management Studio
Following on from my last post, Microsoft have now published some documentation on creating custom reports
Do you want the taskpad view in Management Studio then you need to download Jaspers custom report which
Do you want the taskpad view in Management Studio then you need to download Jaspers custom report...
Do you want the permission view that is avialble in Enterprise Manager for roles well you need...
Do you want the permission view that is avialble in Enterprise Manager for roles well you need to download
We introduced a cool new feature in SP2 of SQL Server 2005 that lets users access their own reports from
Hello, there! You’ve somehow managed to navigate your way through the blogosphere and into the...
Hello, there! You’ve somehow managed to navigate your way through the blogosphere and into the 21st edition