Sorting on discoverer Pivot Tables

From: simbob <simon.flowers_at_networkrail.co.uk>
Date: 24 Feb 2006 04:02:10 -0800
Message-ID: <1140782530.817740.315740_at_i39g2000cwa.googlegroups.com>

Hi,

I am a bit of a beginner on Oracle Discoverer and need to sort with by a field (months, years)but not actually show the information on the sheet/graph.

For example: I want to show Dec Jan and Feb in that order, but it sorts by Dec Feb Jan!!
When I put in the month MM(12, 01,02) it sorts fine but it also shows that data and it looks quite crap! 2005, 01 JAN 15 for example. I just want it to say 2005 JAN 15 or even better 15 JAN 2005!!!

Thanks Received on Fri Feb 24 2006 - 13:02:10 CET

This message: [ Message body ]
Next message: vm.shinde_at_gmail.com: "Bind Variables Using ODP.NET"
Previous message: simbob: "Sorting on discoverer Pivot Tables"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message