Default ALL in a multiple values report parameter

Hi,

I am pretty new to BIRT (v2.3.2), and I have hit a roadblock. I want to default all items in a synamic list. In short, I have a report on orders, and the table runs off a dataset which has 4 filters, Customer, product, depot and status.

My users typically want all of the above to start with, then whittle down as they see fit. To do that, they have to go to each parameter and select every entry in the list (using the shift key etc). They want each list fully selected by default. Can this be done? I did find a post that said it could be done with a work-around to an earlier version, but it did not work in v2.3.2.

Any assistance much appreciated.

Find more posts tagged with

Comments

mwilliams

Hi bluespud,

You could create a flat file dataSet or scripted dataSet with the value "All" in it. Then, create a joint dataSet with a full outer join between your current parameter dataSet and the new one. Then, make a computed column joining those two columns into one. Hope this helps.

mwilliams

bluespud,

Or you could just set the default parameter to 'All'. With the options in the above post and this post, you'll need to modify the query to add the where clause if 'All' is not selected.

mwilliams

bluespud,<br />
<br />
Check out the following example as one way to do it:<br />
<br />
<a class='bbc_url' href='http://www.birt-exchange.org/devshare/designing-birt-reports/952-birt-adding-039-all-039-value-to-your-result-set-through-sql-example/#description'>BIRT Adding 'All' Value to Your Result Set Through SQL Example - Designs & Code - BIRT Exchange</a>

bluespud

Michael,

You are a star!
What are you?
You're a star!

Exactly what I was looking for, thanks.