Can a report contain data from multiple datasources?
Virgil: Yes, BIRT has a join engine embedded. You can join a database query like you would expect to do with multiple tables by using a standard SQL query… but if you want to mix a bit of database data, with XML, or text data, or even Java Objects, then you can take these multiple data sources in BIRT and create a Joint dataset. You can choose which fields join for each dataset and combine the data sets into a single data set.
Related Questions
- The data standards do not contain some data elements that my program is required to report to US EPA. How should this be addressed?
- What if my School Level Report and Core School Performance Indicators Report contain data that is incorrect or incomplete?
- What type of software do we recommend agencies have to track and report on client-level data?
