Multiple Data Sources
Most reports rely on a single data source. All of the display elements (display tables, crosstabs, and various charts) in the report will display data from that source. Logically this makes sense because analytical reports are typically used to make a point, tell a story, or reveal information about the data. However, there are often scenarios that require using data from multiple sources. For these scenarios you can add multiple data sources to a report, configure the display elements to use a specific source.
To create a new data source, click on the Modify Data Source button. The Select or Modify Data Source dialog is presented.
The dropdown list of data sources will appear at the bottom of the dialog along with a Save as New button. Select the data objects for the new data source from the data objects tree and click on the Save as New button. Enter a name for the data source in the Save as New dialog and click on the OK button to confirm it.
The Data Sources panel will reflect the new data source by having an entry in a dropdown list in the header of the Data Sources panel. This dropdown list may be used to assign a data source to a display element.
As data sources are selected from the dropdown list, the tree displayed in the panel content will be refreshed.