BI Publisher (MOSC)

MOSC Banner

Display output for a single vendor with multiple rows -- Credit and Debit details in one stretch

edited Oct 15, 2013 2:57AM in BI Publisher (MOSC) 1 commentAnswered
 I have a requirement to display the output in XML like the below                                                                        Account                                             TrxAmt         FncAmt
Vendor Name           Venodr No      Dr.      BGB005XR8P.E00HQ9410000.80171   12,800.00      8,211.97
GENPACT             DANBURY117    Cr.      BGB005XR8P.E00HQ9410000.80171   12,800.00      8,211.97

A Single vendor 'GENPACT' has two rows : One for Debit amount and other for Credit amount

I was able to display the output in different table outputs  in  RTF  by grouping Vendor details in one group...and Debit and Credit information in another group like the below

for-each LIST_G_INVOICE

for-each G_INVOICE                                                                  
Vendor Name           Venodr No      Dr.    
GENPACT             DANBURY117    Cr.   

for-each LIST_G_DISB

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