BIRT Adding 'All' Value to Your Result Set Through SQL Example

mwilliams

This example report uses two dataSets. One for the report parameter values and one for display in the report. The one for the parameter values fetches the column that will be used for the parameter and uses a union to add an extra row with the value of '(All)'. The query is then modified in the beforeOpen script of the report display dataSet depending on whether '(All)' was selected or not.<br />
<br />
This report was designed in BIRT 2.3.2.2.