OraFAQ Forum: Reports & Discoverer » Month Sequence in Matrix Report

Home » Developer & Programmer » Reports & Discoverer » Month Sequence in Matrix Report (Report 10G, 2012r2)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Month Sequence in Matrix Report [message #677589]

Sat, 28 September 2019 06:46

hissam78
Messages: 193
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 3005 times)

Report message to a moderator

Re: Month Sequence in Matrix Report [message #677599 is a reply to message #677589]

Mon, 30 September 2019 03:23

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

Report message to a moderator

Re: Month Sequence in Matrix Report [message #677603 is a reply to message #677599]

Mon, 30 September 2019 06:00

Littlefoot
Messages: 21823
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'))

Report message to a moderator

Re: Month Sequence in Matrix Report [message #677625 is a reply to message #677603]

Tue, 01 October 2019 08:38

shahzad-ul-hasan
Messages: 643
Registered: August 2002

Senior Member

You can save the these month by month id to order by asc.

Report message to a moderator

Re: Month Sequence in Matrix Report [message #677641 is a reply to message #677625]

Wed, 02 October 2019 04:44

hissam78
Messages: 193
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.

Report message to a moderator

Previous Topic:	multiples rows into one row.
Next Topic:	Command line optional parameter

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 02 16:55:58 CST 2025