Use a UNION of two tables in a view datasource
Use a UNION of two tables in a view datasource
Technologies > User Interface Add-Ins > Parts for Reports > Report with Two Tables in One Datasource
Use a UNION of two databases in a view datasource. Grid Report with Custom SQL Query and data from multiple tables in a single data source
<dataSource id="reportGridSqlUnion_ds">
<!-- Custom SQL query is used as a data source for all displayed grid records.
It can include calculated fields. -->
<sql dialect="generic">
SELECT 'Lease' AS src_table, ls_id AS id_field_1, '' AS id_field_2, date_start, date_end
FROM ls WHERE date_start < ${sql.date('2009-01-01')} AND date_end > ${sql.date('2009-01-01')}
UNION
SELECT 'Option' AS src_table, ls_id AS id_field_1, op_id AS id_field_2, date_option AS date_start, date_review AS date_end
FROM op WHERE date_option < ${sql.date('2009-01-01')} OR date_review < ${sql.date('2009-01-01')}
</sql>
<table name="ls" role="main"/>
<!-- All database fields used in the SELECT caluse must be declared here. -->
<field table="ls" name="src_table" dataType="text"/>
<field table="ls" name="id_field_1" dataType="text"/>
<field table="ls" name="id_field_2" dataType="text"/>
<field table="ls" name="date_start" dataType="date"/>
<field table="ls" name="date_end" dataType="date"/>
</dataSource>