Discussions
Categories
Groups
Community Home
Categories
INTERNAL ENABLEMENT
POPULAR
PUBLIC CLOUD
PRIVATE CLOUD
Quick Links
MY LINKS
HELPFUL TIPS
Back to website
Home
Intelligence (Analytics)
ISALLNULL Aggregate Function extension
Megha Nidhi Dahal
Hello Community,<br />
<br />
The attached aggregate function extension returns true if all the values supplied are null.<br />
<br />
This becomes very useful while handling visibility expressions. Eg: If all values for a particular column are null, the
ISALLNULL("column")
will return true. This lets you hide the entire column along with the header.<br />
<br />
I'll be checking in the code along with some other set of functions in some weeks time.<br />
<br />
To make this function available for your use, download the attached jar and place it in the plugins/dropins folder of your eclipse (BIRT designer). Later while creating a computed column in dataSet, you can find the ISALLNULL function in the list.
<br />
<br />
Please evaluate it and let me know if you like to see any other aggregate function extension
.<br />
<br />
[Update: 05-Dec-2011:]
Added the source code.<br />
<br />
Best Regards<br />
Megha
Find more posts tagged with
Comments
There are no comments yet