BI Publisher (MOSC)

MOSC Banner

BI Publisher not sorting data correctly

edited Jul 23, 2010 1:01AM in BI Publisher (MOSC) 7 commentsAnswered
 I have a RTF template which has the following sort order <?for-each:G_INVOICE?>
<?sort:SE_CLIENT_NAME?>
<?sort:SE_DIVISION?>
<?sort:SE_FILE_NUMBER?>
<?sort:TRX_DATE?>

When I review the excel output , It sorts correctly by SE_CLIENT_NAME and SE_DIVISION but it does not sort by SE_FILE_NUMBER within the SE_CLIENT_NAME and SE_DIVISION.

I also tried just sorting it by SE_FILE_NUMBER independently , still it does not work.

It shows the SE_FILE_NUMBER in the following order on the excel output

SE_FILE_NUMBER
8053341
8053151
a8026530
8047382
8052959
8052856
8050172
8050172
8052555
a8052883
8020433
8020433

If you observe , a8026530 and a8052883 should be at the bottom. Also 8052959 is coming before 8052856. It is not sorting correctly..

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