Database Reference
In-Depth Information
One of the main benefits of using a shared data source is that it makes managing
changes easier. This is especially true for large organizations, where you may
have hundreds of reports based on the same relational source system. Imagine the
headache and effort required to update the connection details for all of those reports
if the source system is migrated to a new server. However, there are certain scenarios
where an embedded data source is the only option. One example where the data
source must be embedded is when you want to use an expression to dynamically
control the destination of a data source object. Expressions will be covered later in
this chapter.
Dataset
A dataset is best thought of as a two-dimensional table structure based on the results
of a query that has been executed against a report data source such as that displayed
in the following screenshot:
Report dataset
