Discussions
Categories
Choose a Product
THRUST SERVICES
CORE APPS
CE PRODUCTS
...
Quick Links
POPULAR
HELPFUL TIPS
Groups
My Links
FOR SIGNED IN MEMBERS:
Back to website
Home
Designing Analytics Reports
order by and null value
Migrateduser
Hello all,
I've a parameter in birt report that dynamically orders my dataset result:
select *
from table
order by decode (?, 1, col1,
2, col2 || col1,
3, col3 || col1
)
Is it possible to do this order by somewhere else in the report? beforeOpen or something script? I just want to do this for performance improvements.
Something else:
How can I avoid the null value for a parameter that has been unchecked for required? If I uncheck required for a parameter of type listbox, automatically I get a null value as option. Can this behavior be influenced in means of not showing the null value in the list?
Thanks in advance!
Find more posts tagged with
Comments
There are no comments yet