Home » Fusion Middleware & Colab Suite » Business Intelligence » BI Publisher RTF Template Builder (BI Publisher)
BI Publisher RTF Template Builder [message #687529] Tue, 28 March 2023 15:59 Go to next message
VariableReset
Messages: 3
Registered: November 2016
Junior Member
Does anyone know how to suppress duplicate rows from a for-each loop? I can't touch the underlying xml data, nor can I edit the sql that produces the xml file, so I am stuck with duplicate rows in one of the tables generated.

Any guidance on this?

Report message to a moderator

Re: BI Publisher RTF Template Builder [message #687548 is a reply to message #687529] Fri, 31 March 2023 00:14 Go to previous message
Littlefoot
Messages: 21765
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Quote:
nor can I edit the sql that produces the xml file
And that's exactly what I first thought when I read you have duplicates. Unfortunately, I wouldn't know how to do it (or whether it is possible!) in tool you use; it's just data you get, and that's more or less garbage in, garbage out.

If you can't edit query, ask the ones - who can - to do it.

Report message to a moderator

Previous Topic: group every 5 records
Next Topic: oca user session information
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 28 04:52:56 CDT 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.