How to conditionally hide a column based on a parameter value in BI Excel Template?

Reena Agrawal

We have a requirement to dynamically hide a column in the excel report based on what input parameter the user selects. . I am guessing it should be done using <xsl: if test…?> clause, but not sure of. Need some inputs on this.

Mallikarjuna Kuppauru-Oracle

Hi @Reena Agrawal

Thanks for using Oracle Communities.

Yes, you can use the if condition to hide the same . Refer below MOS doc -

Display or hide columns depending on the parameter selected (Doc ID 2539753.1)

Regards,

Arjun

Reena Agrawal

Thank you for replying @Mallikarjuna Kuppauru-Oracle. This looks like the code to be used in rtf template. My requirement is in an Excel template.

Abhilash K - Deloitte USI

Conditional formatting is not supported in excel templates as its done for RTF. You will have to go via RTF route for conditional formatting requirements.

Reena Agrawal

Thanks for your response @Abhilash K - Deloitte USI .