Quick Tip: Check for NULL with BIRT reports in expression data binding

Written by Chon Neth, Editor-in-Chief

Checking for NULL values in BIRT can sometimes be tricky but here is an easy way to quickly replace NULL values from your dataset’s with any value you want without any if/else statements.  Since javascript is the core of BIRT, you can use logical or operators in your data binding expressions like so:

Data bind expression

When the dataSetRow for “craft” is NULL or undefined, it will automatically use “N/A” as a replacement.  You can use this concept within your scripts as well.

Did You Know...

As Maximo Experts, we have developed several add-on products for Maximo that mobilize the work force, simplifies assignments, provides ad-hoc reporting capabilities and facilitates the seamless integration of Service Requests into Maximo.

Check out our products by clicking on the following links: EZMaxMobile, EZMaxPlanner and EZMaxRequest.

Find Out More

One thought on “Quick Tip: Check for NULL with BIRT reports in expression data binding”

  1. Pingback: Grouping on a NULL field in BIRT | MyGeekDaddy

Leave a Reply