Wednesday, 8 February 2023

BI Publisher- Excel Template - Print rows conditionally

When using excel template in BI Publisher, there are times when we want to print certain rows in output file based on the value of a column. Instead of the normal group tag, add the group tag as below in XDO_METADATA sheet.





Sample XML Data:
<DATA_DS>
<G_1>
<emp_no>101</emp_no>
<emp_name>Arjun</emp_name>
<ENROLLED>yes</ENROLLED>
</G_1>
<G_1>
<emp_no>102</emp_no>
<emp_name>Bharat</emp_name>
<ENROLLED>no</ENROLLED>
</G_1>
<G_1>
<emp_no>103</emp_no>
<emp_name>Charan</emp_name>
<ENROLLED>no</ENROLLED>
</G_1>
<G_1>
<emp_no>104</emp_no>
<emp_name>Dinesh</emp_name>
<ENROLLED>yes</ENROLLED>
</G_1>
</DATA_DS>


No comments:

Post a Comment