Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 40 Oracle Analytics and AI Sharing Center
- 20 Oracle Analytics and AI Lounge
- 276 Oracle Analytics and AI News
- 50 Oracle Analytics and AI Videos
- 16.2K Oracle Analytics and AI Forums
- 6.4K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 102 Oracle Analytics and AI Trainings
- 17 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
How to Hide any Row if any Column value is Blank in the Table in oracle BI Custom Print Report (rtf
Vivek Tiwari
Rank 3 - Community Apprentice
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
0
Answers
-
Vivek
What template format is this for?
Tim
0 -
In the table row you can put if condition after for each <?if:XYZ != ''?> at the first column in the row.
Sample :
0 -
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
0