Suppressing rows in BI Pub Excel template

Question

Summary

Need to figure out how to suppress rows in a BI Publisher Excel template

Content

I am following the instructions found here:

https://docs.oracle.com/middleware/12211/bip/BIPRD/GUID-30710EE5-ED97-4489-8E48-642BCACD1837.htm#GUID-88EDBF14-41BC-48AE-A869-496BC7F39E8B

in an attempt to suppress rows in an Excel-template for BI Publisher. However, I am unable to get the appropriate row to suppress.

I have attached the .xml data file that I am using, as well as the .xls file.  As far as I can tell, I have followed the instructions to the letter, but no rows are suppressed.  I still see all three employees.

Can someone who has the BI Publisher add-in for MS Office open this xls, attach the xml, confirm that you see three rows, and possibly tell me what I am doing wrong?  (I am using the add-in for BIP 11.1.1.9, but I would probably be satisfied with an answer on any version.)

Thanks!!

SKIPROW.xls

skiprow.xml

Mark.Thompson · Answer

I would be quite happy to use an RTF.  My client really, really wants to use XLS.

Noelle Bartlam-Oracle · Answer

Is it necessary to use an excel template for this?  Could you use an rtf instead?

Mark.Thompson · Answer

Thank you, Noelle. That gives me another path to explore to try to figure this out.  The document mentions that XSLT can add style attributes to data elements, which sounds like what I might need.  But alas, it does not provide an example, so I will have to add that to my ever-growing list of things to figure out.

I really would like to know if the @attribute method is truly the only way to accomplish my goal.  I don't know very much about XSL, but it just seems odd that a comparison against a data element value would not be a valid method of determining a true/false condition.

Thanks again!