How to not display empty xml tags on the report
I am using oracle report 10.1.2.02 and I display the output in xml.
All the tags are showing up fine. But my problem is I dont want to display the empty tags, i.e., if a column value is null then no tag for that column on the output.
SRW.SET_XML doesn't work when used in BEFORE REPORT TRIGGER because I cannot reference a database column in the trigger
Doesn't work at GROUP LEVEL TRIGGER OR COLUMN LEVEL TRIGGER or FIELD LEVEL TRIGGER. an empty tag still shows up on the report output.
Appreciate your suggestions/solutions.
Thanks,
SS.