BI Publisher (MOSC)

MOSC Banner

Group by with more than one column

edited Sep 9, 2016 5:00AM in BI Publisher (MOSC) 9 commentsAnswered

Hi

I have a requirement where the output should be like this.

Workarea
Logname
logdatecontract noMode payment
Count
Amount
ACQMTC0008529/09/20151000162258CN2100.000
MTC0008529/09/2015941856WV1150.000
AD1MTC0009929/09/20151000053103CN1230.000
MTC0009929/09/20151000241193WV1150.000

here the 'count' is the no of transaction group by  contract no then mode of payment.

I am using bip desktop where if I use the table wizard I am unable to to repeat the log name a log date .

And if I try with direct code like

<?for-each-group:Payments;./CBiO2AccountSequenceNumber?> and

count=<?count(current-group()/PaymentMethod)?>

I can group by the data only with any one of the element not more than that.

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