How to Hide any Row if any Column value is Blank in the Table in oracle BI Custom Print Report (rtf

Vivek Tiwari

Summary

How to Hide any Row if any Column value is Blank in the Table in oracle BI Custom Print Report (rtf template)

Content

Hi All

In Oracle Custom BI report . i want to make custom print for line item detail tab of unifier. i want if one value is blank in that line item whole row will hide.

Regards

Vivek

timdexter

Vivek

What template format is this for?

Tim

Brajesh Shukla-95078

In the table row you can put if condition after for each  <?if:XYZ != ''?> at the first column in the row.

Sample :

timdexter

If it is an RTF template you could use an XPATH expression to test the elements in the row.

ROWSET

ROW

  COL1

  COL2

  COL3

  COL4

for-each:ROW[COL1!='' or COL2!='' or COL3!='' or COL4!='']

This will be more efficient that using an if statement testing each column.

Tim