Database Reference
In-Depth Information
Though not a requirement, when the data source is a relational
database, it is considered good practice to use a stored procedure to
retrieve data for the dataset instead of a query embedded in the report.
This offers an additional layer of encapsulation that comes in handy if/
when minor changes are required at a later point in time. There may
also be potential performance benefits through query parameterization
and planned cache reuse on the source system, although thorough
testing is the only way to be sure.
The
Query Designer
window is as follows:
Graphical query designer used to help construct SQL queries for datasets
Just as with the data source component, a dataset component can be shared or
embedded. A shared dataset exists as a standalone object and can be referenced by
multiple reports, while an embedded dataset is specific to a single report. A shared
dataset cannot be based on an embedded data source; it must be based on a shared
data source.
