Use a custom SQL query in a cross-table
Use a custom SQL query in a cross-table
Technologies > User Interface Add-Ins > Grouping Views> Cross-table view with custom SQL query
A custom SQL query may be defined in a cross-table as in any report view.
This example cross-table view is grouped by one criteria, which also happens to be a calculated SQL field:
<field name="bu_dv_dp" dataType="text" groupBy="true" baseField="gp.dp_id">
<title translatable="true">Business Unit, Division, Department</title>
<sql dialect="generic">RTRIM(gp.bu_id)${sql.concat}'-'${sql.concat}RTRIM(gp.dv_id)${sql.concat}'-'${sql.concat}RTRIM(gp.dp_id)</sql>
</field>
Define your own SQL query in a view datasource
Use binding expressions in the datasource