O'Reilly logo

Oracle BI Publisher 11g: A Practical Guide to Enterprise Reporting by Daniela Bozdoc

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Correcting the error

In order to correct an error, all we have to do is to rewrite the trigger and the XLS_FO. The following are the alternatives depending on the XML structure:

  • In the case the element is not present:
    <?if:not(element_name)?>
    
  • (desired behavior)
    <?end if?>
    
  • The element is present and the value is not null:
    <?if:element_name!=?>
    
  • (desired behavior)
    <?end if?>
    
  • The element is present, but is null:
    <?if:element_name and element_name="?>
    
  • (desired behavior)
    <?end if?>
    

As the first case is the suitable match in this example, the XSL-FO code will be as follows:

Correcting the error

According to your data, many other more or less complicated situations can be encountered. ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required