BI Publisher (MOSC)

MOSC Banner

How do you sort a field in a <G_STATEMENT> e;e,emt? Say FIELD_DESC needs to be sorted in that group

edited Jan 19, 2016 10:04AM in BI Publisher (MOSC) 5 commentsAnswered

The Template looks like this -

//  Need to sort this Statement by SEND_TO_COUNTRY_DES

// Can you advise as to how I could do that?

SEND_TO_CUSTOMER_NAME

<?xdofx: if SEND_TO_ADDRESS4 !='' then SEND_TO_ADDRESS4 ?>

<?xdofx: if SEND_TO_ADDRESS1 !='' then SEND_TO_ADDRESS1 ?>

<?xdofx: if SEND_TO_ADDRESS2 !='' then SEND_TO_ADDRESS2 ?>

<?xdofx: if SEND_TO_ADDRESS3 !='' then SEND_TO_ADDRESS3 ?>

SEND_TO_CITY, SEND_TO_STATE SEND_TO_POSTAL_CODE

<?xdofx: if SEND_COUNTRY !='US' then SEND_TO_COUNTRY_DESC ?>

Statement Date

Statement Date                                    Customer Number CUST_NUM

For Each

If Not Summary

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