Property Binding in a Dataset

I have a report where there is a parameter of Branch
the parameter has the values for example
0001
0002
9999 (where all branches are to be used)

in the dataset I have the branch which is only ever 0001 or 0002

In the dataset under Propery Binding tab I need to have a script that selects only the data for branch 0001 if parameter is 0001 or only the data for branch 0002 if parameter is 0002. This works ok for now.

My problem is getting the syntax in the script for the case where the parameter is set to 9999 in which case I want all records.

Any Birt superstars out there can lend me an answer as soon as possible as I am on vacation from Friday 3rd October

Find more posts tagged with

Comments

mwilliams

Hi Lesbea,

Can you attach your report design so I can see how you're doing your current parameter handling? This way I can try to suggest something similar to get all of them.

Lesbea

Found a solution by using two 99% identical Datasets in the report the 1% being the filtering by Branch equal to parameter. I put a script into the beforeFactory to switch datasets depending on content of the branch parameter. This works fine at present.

mwilliams

Lesbea,

Glad you found a solution!