BIRT has finally added a much awaited feature of been able to select multiple values in a report parameter.
However, I have not been able to find a way to use a report parameter that makes use of the "List Box" / "Allow Multiple Values" option in a SQL Query as a bind parameter.
Fortunately, it seems easy enough to use the "multiple value parameter" in the "Filters" section of the data set.
You can use the IN operator and build an expression to reference the report parameter.
Now if only there was an easy way to have multiple values selected by default. Oh well.. I guess there is always another release another day.
However, I have not been able to find a way to use a report parameter that makes use of the "List Box" / "Allow Multiple Values" option in a SQL Query as a bind parameter.
Fortunately, it seems easy enough to use the "multiple value parameter" in the "Filters" section of the data set.
You can use the IN operator and build an expression to reference the report parameter.Now if only there was an easy way to have multiple values selected by default. Oh well.. I guess there is always another release another day.
No comments:
Post a Comment