Anyone have problem with multi-select parameters in BIRT report (RTC 4.0.6) ?
Our server was just upgraded to RTC 4.0.6 and we have one of many BIRT reports that were working fine before the upgrade.
Anyone experience this as well?
One of the reports did not return any rows today. Turns out that when all values of a multi-select parameter are selected, when you try to look at the value inside the parameter, it is empty. As long as you don't select all values, it will be populated correctly.
Anyone experience this as well?
2 answers
Hi Paul, this is an optimization we did in 4.0.6. We looked at all of our out of the box reports and we noticed that selecting every value really meant you do not want to filter on those. So the report should produce the same results as selecting no value. This simplified the generated SQL and resulted in faster running reports.
Thanks for the info Rafik.
I've been wondering why some of our reports have stopped working after the upgrade and this atleast explains why and I can work around them.
That said I think this is a disruptive change. I believe users should be able to select none, few or all entries from a multi-select list and we should should filter results based on that for the report.
I've been wondering why some of our reports have stopped working after the upgrade and this atleast explains why and I can work around them.
That said I think this is a disruptive change. I believe users should be able to select none, few or all entries from a multi-select list and we should should filter results based on that for the report.