Multi tool use

how to conditionally hide a row in excel if condition is not met

I am using BI Publisher add-in in excel ,
and I want to hide a row of <?net_salary?> if the value equal 0
my code :

<?net_salary?>

<xsl:choose>
<xsl:when test="number(.//NET_SALARY) != 0"><xsl:value-of select="(.//NET_SALARY)"/></xsl:when>
<xsl:otherwise>
** hide row **
</xsl:otherwise>
</xsl:choose>


1 Answer
1

If you put an IF statement at the beginning of the row before anything else, and then end if at the end of the row after everything else, it will not render the row if the condition is not met. For more information, there's details in the BI Publisher Report Designer guide on IF statements.

IF

end if

Example:

<?if:net_salary<>'0'?>Table cells and data elements<?end if?>

<?if:net_salary<>'0'?>

<?end if?>

By clicking "Post Your Answer", you acknowledge that you have read our updated terms of service, privacy policy and cookie policy, and that your continued use of the website is subject to these policies.