Home » Developer & Programmer » Reports & Discoverer » unable to sort date function (report-6i)
unable to sort date function [message #291637] Sat, 05 January 2008 10:43 Go to next message
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
hello sir,

i m having a query in which date function is sorted by
order by to_date(document_date) desc. which works fine on toad
but when that query run on report it will fail to sort.
date column comes hapazardly.
then i edit on registry of application server as nls_date_format 'DD-MMM-YYYY' but nothing going to hapen.

on that field's property i found date database length as 9.
i unable to recognise from where it come, even i format date mask as dd-mm-yyyy but no conclusion.

sir please help me how could i do to sort it.

Re: unable to sort date function [message #291641 is a reply to message #291637] Sat, 05 January 2008 10:58 Go to previous message
Messages: 20847
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Open Property Inspector window for the 'document_date' field and set its 'Break Order' property to 'Ascending'. Also, you might want to take care about field order in its group.
Previous Topic: Problem with Save Workbook
Next Topic: 2 Records in 1 Row
Goto Forum:

Current Time: Fri Oct 28 00:09:14 CDT 2016

Total time taken to generate the page: 0.15050 seconds