Article
10/04/2012

Using Custom Reports with Object Explorer Node Properties

Custom reports can execute in the context of a selected Object Explorer node if the custom reports reference the report parameters of that node. This enables a custom report to use the current context, for example the current database, or a database or server object.

Report Samples

Report Samples, including the standard reports created by Microsoft, are available for download. These samples may be modified by using Business Intelligence Development Studio.

Object Explorer Node Report Parameters

Parameter name	Data type
ObjectName	String
ObjectTypeName	String
Filtered	Boolean
ServerName	String
FontName	String
DatabaseName	String

Object Explorer Node Report Parameters Example

To run the example, use the following procedure.

To view the report parameter values for a node in Object Explorer

Copy the following sample code into a new text file and name the file by using an .rdl extension.
Copy the report file to a folder that you have created on the database server for custom reports.
In Management Studio, right-click a node in Object Explorer, point to Reports, click Custom Reports. In the Open File dialog box, locate the custom reports folder and select the report file, and then click Open.

When a new custom report is first opened from an Object Explorer node, the custom report is added to the most recently used list under Custom Reports on the shortcut menu of that node. When a standard report is opened for the first time, it will also appear on the most recently used list under Custom Reports. If a custom report file is deleted, the next time that the item is selected, a prompt will appear to delete the item from the most recently used list.
1. To change the number of files displayed on the recently used list, on the Tools menu, click Options, expand the Environment folder, and then click General.
2. Adjust the number for Display files in recently used list.

Custom Report Code Sample

The report that is created by using the following code will use the parameters that are associated with an Object Explorer node.

<?xml version="1.0" encoding="utf-8"?>

<DataType>String</DataType>

<Prompt>ObjectName</Prompt>

</ReportParameter>

<DataType>String</DataType>

<Prompt>ObjectTypeName</Prompt>

</ReportParameter>

<DataType>Boolean</DataType>

<Prompt>Filtered</Prompt>

</ReportParameter>

<DataType>String</DataType>

<Prompt>ServerName</Prompt>

</ReportParameter>

<DataType>String</DataType>

<Value>Tahoma</Value>

</Values>

</DefaultValue>

<Prompt>FontName</Prompt>

</ReportParameter>

<DataType>String</DataType>

<Value>master</Value>

</Values>

</DefaultValue>

<Prompt>DatabaseName</Prompt>

</ReportParameter>

</ReportParameters>

<ConnectString>Data Source=.</ConnectString>

</ConnectionProperties>

<rd:DataSourceID>f1feee4c-0fdc-4301-9efa-3cd89eed2d9f</rd:DataSourceID>

</DataSource>

</DataSources>

<rd:DrawGrid>true</rd:DrawGrid>

<rd:SnapToGrid>true</rd:SnapToGrid>

<Body>

<rd:DefaultName>textbox1</rd:DefaultName>

<Style>

<FontFamily>Tahoma</FontFamily>

<Color>SteelBlue</Color>

</Style>

<Value>AllReportParameters</Value>

</Textbox>

<DataSetName>AllReportParameters</DataSetName>

<rd:DefaultName>ObjectName</rd:DefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<Default>LightGrey</Default>

</BorderColor>

</Style>

<Value>=Parameters!ObjectName.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<rd:DefaultName>ObjectTypeName</rd:DefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<Default>LightGrey</Default>

</BorderColor>

</Style>

<Value>=Parameters!ObjectTypeName.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<rd:DefaultName>Filtered</rd:DefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<Default>LightGrey</Default>

</BorderColor>

</Style>

<Value>=Parameters!Filtered.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<rd:DefaultName>ServerName</rd:DefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<Default>LightGrey</Default>

</BorderColor>

</Style>

<Value>=Parameters!ServerName.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<rd:DefaultName>FontName</rd:DefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<Default>LightGrey</Default>

</BorderColor>

</Style>

<Value>=Parameters!FontName.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

<rd:DefaultName>DatabaseName</rd:DefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<Default>LightGrey</Default>

</BorderColor>

</Style>

<Value>=Parameters!DatabaseName.Value</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

</TableRow>

</TableRows>

</Details>

<rd:DefaultName>textbox2</rd:DefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

</Style>

<Value>ObjectName</Value>

</Textbox>

</ReportItems>

</TableCell>

<rd:DefaultName>textbox3</rd:DefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

</Style>

<Value>ObjectTypeName</Value>

</Textbox>

</ReportItems>

</TableCell>

<rd:DefaultName>textbox4</rd:DefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

</Style>

<Value>Filtered</Value>

</Textbox>

</ReportItems>

</TableCell>

<rd:DefaultName>textbox5</rd:DefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

</Style>

<Value>ServerName</Value>

</Textbox>

</ReportItems>

</TableCell>

<rd:DefaultName>textbox6</rd:DefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

</Style>

<Value>FontName</Value>

</Textbox>

</ReportItems>

</TableCell>

<rd:DefaultName>textbox7</rd:DefaultName>

<Style>

<Default>Solid</Default>

</BorderStyle>

<FontFamily>Tahoma</FontFamily>

<Default>LightGrey</Default>

</BorderColor>

<BackgroundColor>SteelBlue</BackgroundColor>

<Color>White</Color>

</Style>

<Value>DatabaseName</Value>

</Textbox>

</ReportItems>

</TableCell>

</TableCells>

</TableRow>

</TableRows>

</Header>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumn>

</TableColumns>

</Table>

</ReportItems>

</Body>

<rd:ReportID>abb14e58-fd36-495a-89ff-b66f29ef287b</rd:ReportID>

<Query>

<rd:UseGenericDesigner>true</rd:UseGenericDesigner>

<CommandText>SELECT 1

</CommandText>

<DataSourceName>AllReportParameters</DataSourceName>

</Query>

<rd:TypeName>System.String</rd:TypeName>

<DataField>ObjectName</DataField>

</Field>

<rd:TypeName>System.String</rd:TypeName>

<DataField>ObjectTypeName</DataField>

</Field>

<rd:TypeName>System.Boolean</rd:TypeName>

<DataField>Filtered</DataField>

</Field>

<rd:TypeName>System.String</rd:TypeName>

<DataField>ServerName</DataField>

</Field>

<rd:TypeName>System.String</rd:TypeName>

<DataField>FontName</DataField>

</Field>

<rd:TypeName>System.String</rd:TypeName>

<DataField>DatabaseName</DataField>

</Field>

</Fields>

</DataSet>

</DataSets>

</Report>

Share via

Using Custom Reports with Object Explorer Node Properties

Report Samples

Object Explorer Node Report Parameters

Object Explorer Node Report Parameters Example

Custom Report Code Sample

See Also

Tasks

Concepts

Additional resources