Home » Developer & Programmer » Reports & Discoverer » Month Sequence in Matrix Report (Report 10G, 2012r2)
Month Sequence in Matrix Report [message #677589] Sat, 28 September 2019 06:46 Go to next message
hissam78
Messages: 109
Registered: August 2011
Location: PAKISTAN
Senior Member
Dear Experts
we have designed one matrix report but matrix month column not showing in correct order. somebody can help us to correct this problem. please find the attached .png file for your kind reference.



thankful
  • Attachment: scr.png
    (Size: 12.11KB, Downloaded 242 times)
Re: Month Sequence in Matrix Report [message #677599 is a reply to message #677589] Mon, 30 September 2019 03:23 Go to previous messageGo to next message
Neveen2019
Messages: 13
Registered: February 2019
Junior Member
Hi

please share your query.
example:
select to_char(month,'MONTH')month
.....
Advice: use month in ORDER BY it references the month string.

Amatu Allah
Re: Month Sequence in Matrix Report [message #677603 is a reply to message #677599] Mon, 30 September 2019 06:00 Go to previous messageGo to next message
Littlefoot
Messages: 21517
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
If you'll order them by their name, you'll need DECODE (and quite a lot of typing).

Consider ordering them by month number, e.g.

order by to_number(to_char(date_column, 'mm'))
Re: Month Sequence in Matrix Report [message #677625 is a reply to message #677603] Tue, 01 October 2019 08:38 Go to previous messageGo to next message
shahzad-ul-hasan
Messages: 561
Registered: August 2002
Senior Member
You can save the these month by month id to order by asc.
Re: Month Sequence in Matrix Report [message #677641 is a reply to message #677625] Wed, 02 October 2019 04:44 Go to previous message
hissam78
Messages: 109
Registered: August 2011
Location: PAKISTAN
Senior Member
very Much thankful to all of you for sharing brilliant solutions, will try.

Grateful to all of you.
Previous Topic: multiples rows into one row.
Next Topic: FRM-41214: Unable to run report
Goto Forum:
  


Current Time: Wed Dec 11 16:23:38 CST 2019