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

Question

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

Brajesh Shukla-95078 · Answer

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

Sample :

timdexter · Answer

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

timdexter · Answer

Vivek

What template format is this for?

Tim