We are using APEX 24.2 and Oracle Cloud Document Generator function. We are using MS word Templates to generate PDF reports. For the most part it is working. We need help with a particular conditional looping in MS word Template. One of the report I want to print a table header with Titles only when there is data for that sub query.
FOR Example : In the report below , I want to print the Dept id | Dept Name | Title header only if there is a department record. If no dept record exists , I dont want to print the title.
How can I achieve this in MS word Template ? what Tags will I use in the Word Template ? any help appreciated. thanks.
Report output example :
Employee id | Employee name | Address |
_ABC | John Doe | XYZ … |_
**Dept id | Dept Name |**
_10 | Purchasing |_