BI Publisher (MOSC)

MOSC Banner

How to Group by multiple Elements in a .RTF template?

edited Feb 4, 2022 7:11AM in BI Publisher (MOSC) 18 commentsAnswered

Hi Gurus.

I have following requirement:

consider following select:

select sum(hours), period_end_Date, payment_date, hours_type from labor_table
group by period_end_Date, payment_date, hours_type;

How can I achieve above select result in .rtf template.

It only allows me to group by one element/column.
<?for-each-group:Run_Result_Rec;./PERIOD_END_DATE?><?sort:LAST_NAME;'ascending';'text'?>

If I put something like following in the next loop, its not working. Meaning, it is only resulting rows at PERIOD_END_DATE level.

<?for-each-group:current-group();./PAYMENT_DATE?>

How do I achieve this?


Please advise.


Thanks,

Darsh

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