dynamic & static data in report parameter??

Rocker

Hi, I am using BIRT 2.2.2 on XP. My report shows a product catalog with fixed number of categories. I have an input report parameter 'param1'
(a combo box) which takes from the user input on what category does he want to see all the products. The report parameter is a dynamic one & takes all the existiing categories from a table to fill in the combo box.
The problem here is that I need along with all the categories, another entry callled 'All' in the combo box. The easy solution of adding a row called 'All' in the table from which the report parameter fetches data from in not possible in my case. Is there a way to add a static field called 'All' to the existing dynamic data in 'param1' ??
am stuck badly here, would really appreciate any help.

Thanks

mwilliams

Hi Rocker,

There's probably a simpler way to do so than this, but you could create a flat file dataSource from a file that contains one field with a value of 'All' or a scripted dataSource with the same. Then, you could join that dataSet with your current dataSet using a full outer join and create a computed column that meshes those columns together for you to pull in to the parameter. This should work. I'll look for a more direct way of achieving this as well.