Brio Software
Technical Publications
Home Previous Next Index Glossary
Data Analysis and Reporting with Intelligence Clients

Using Multiple Data Sources in a Report

You can create reports that contain data from multiple queries that use a wide range of data sources (relational database queries, OLAP server queries, imported data sets, and local join queries).

In a sense, the data in a single table correlates data across queries in a report, retrieving all rows from the table on the “left” and any rows from the table on the “right” that have matching values. Unlike actual joined topics in the Query section, the tables are not linked in the same sense. In the Report section, data is only in the report.

The rules for using multiple data sources in a single report are:

To build a multiple data source report:

  1. Build the queries that you want to include in the report:
    • Verify item data types and associated data values in source documents so that you know how to correlate them when creating the reports.
    • Build the Request line, and add server and Local limits, data functions, and computations to the query as needed.
  2. Click Process.
  3. Choose Insert then New Report.
  4. A new report section appears.

  5. In the Catalog pane, click the expand file button of the Results or Table set that you want to include in your report.
  6. If necessary, click Groups on the Section title bar to open the Group Outliner.
  7. A group header categorizes data into repeating collections of records in a header band.

  8. If necessary, click Table on the Section title bar to open the Table Outliner.
  9. The Table Outliner shows two panes: Table Dimensions and Table Facts. Use the Table Dimensions pane to build the column dimensions (labels) in the report. Use the Table Facts pane to build the numeric values in the report.

  10. Build the group header band by dragging the item(s) from the Results sections of the Catalog pane to the Groups Outliner.
  11. Build the column dimensions of the report, drag the item(s) from the Query sections of the Catalog pane to the Table Dimensions in Outliner pane.
  12. Build the column numeric values of the report by dragging the item(s) from the Query sections of the Catalog pane to the Table Facts in Outliner pane.

Home  |  Previous |  Next  |  Index |  Glossary

Privacy/Legal | Copyright 2002 Brio Software, Inc.