Oracle Reports (MOSC)

MOSC Banner

How to not display empty xml tags on the report

edited Sep 11, 2012 2:44AM in Oracle Reports (MOSC) 1 commentAnswered

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center