All Option On Dynamic Parameter

JasonW

This example adds an all option to a dynamic parameter by using a Joint Dataset. The Joint DS combines a reqular SQL ds with a scripted dataset that returns one row labeled all. The join is a full outer join and a computed column is added to combine the columns. This joint dataset set is used by a dynamic parameter. The beforeOpen script is used to modify the query of the dataset OrderDetails based on the values selected in the dynamic parameter. This version was done in BIRT 2.5. A similar approach should work in 2.3. <br />
<br />
Simpler approach is located here:<br />
<br />
http://www.birt-exchange.org/devshare/designing-birt-reports/1025-all-option-on-dynamic-parameter-pt2/#description