Databases Reference
In-Depth Information
Property
Description
Prompt User
You can hide parameters from users by selecting this check box. This is a great
way to provide data-specific reports for different users.
Display Text
Allows you to change the prompt for improved readability and user
comprehension when running the report.
Subscriptions
Using the subscription properties of a report, you can configure how users view a report. Subscriptions
can be set up for an individual user or broadcast to many users. For example, Report Server administra-
tors can create subscriptions that automate report execution and deliver rendered reports to user e-mail
inboxes or posted to file shares on the company network. The types of subscriptions and working with
them are covered later in this chapter.
Data Sources
Data sources are used to specify the sources of data to be used in the report. For example, you can indi-
cate that the queries in a report connect to a SQL Server or Oracle database. Data sources are wrappers
for connection strings. A
connection string
tells the server what server the source database is on, and what
database on that server to reference.
Credentials are an important data source property. Depending on your execution requirements, you
can specify whether or not the login credentials should be stored in the Report Server database. Finally,
reports can use a shared data source or a data source that is specific to an individual report. Figure 10-13
shows the Data Sources property page for a report.
Data sources are covered in more detail in “Working with Data Sources” later in this chapter.
Security
As you learned earlier in this chapter, you enable end user access to specific reports or folders using the
security properties for a folder or content item. When working with reports, you can also control which
data an end user can view within that report. For more information on working with security settings in
Report Manager, refer to “Securing Report Server Content” earlier in this chapter.
Linked Reports
Linked reports are extensions of standard, published reports. They're a reliable, flexible way to cus-
tomize report output for different users. For example, you can use linked reports to create regional sales
reports based on the national report. Simply create a linked report for each region, and then specify
unique parameter values for each linked report.
A linked report is a configuration profile for a report that can store a separate set of configuration settings.
Because they're based on already published reports, you can leverage that report design to create different
views of the same source data. They use the parent report data source and
rdl
file, but you can modify the
execution, parameter, subscription, and security properties without affecting the parent report. Creating a
linked report is done from the General property page of the report you want to use as the base report.
Provide a new name for your report, and modify the report parameters as needed for the target users.
Search WWH ::
Custom Search