Database Reference
In-Depth Information
You will notice that the folder and file names as well as the controls used to define your
report parameters are much less comprehensive than when the reports are consumed
through the Service Manager console.
When you use the web browser to navigate the reports, SQL Server Reporting Services
shows the actual file and folder names, and also renders the default controls for the report
parameters.
This behavior can be overridden when accessing reports through the Service Manager
console, using directives in management packs.
If you want to provide reports to users through the web browser, we recommend that you
create custom reports for your end users who do not make use of advanced management
pack features but are instead tailored to be consumed through the web browser. You can
create your own folder and report file structure in SQL Server Reporting Services and
limit access to only the folders you want your users to see.
Creating favorite and linked reports
Service Manager allows you to save the selections you make in the
Parameters
section of
the report window for future use. You can save settings for just yourself or create a linked
report that will also be available to other users. Perform the following steps:
1. Open the Service Manager console, navigate to the
Reporting
node, and open the
report of your choice.
2. Make the desired selections in the
Parameters
section of the report window.
3. On the right-hand side tasks pane, click on
Save as Favorite
, enter a name for the
report, and then click on
OK
.
4. The report will now appear under the
Favorite Reports
folder in the
Reporting
section of the Service Manager console.
A linked report is a favorite report that can be accessed by other users. You can create
linked reports only from reports that were imported through management packs. Follow
these instructions to create a linked report:
1. Open the report of your choice in the Service Manager console.
2. Make the desired selections in the
Parameters
section of the report window.
3. On the right-hand side
Tasks
pane, click on
Save as Linked Report
.
