How to hide multiple column in the RTF and XML BI template
Hello,
I tried to with the first zero amount column it is hiding <?if@column:BASIC_PAY !='0.00'?> <?BASIC_PAY?><?end if?> but in another column data in a few rows and used the same function for that column and I can see next immediate not null values are mapped to this column values wherever the amount is 0.00. how can I hide multiple columns if values are partially in the columns it is not working. Can anyone help me with this, this is a payroll report and need to be finished asap.
I am not aware of how to hide columns in the EXCEL template and I did see any docs related to those. pls, share if anyone has on this.