OraFAQ Forum: Reports & Discoverer » ordering columns and rows in a matrix report

Home » Developer & Programmer » Reports & Discoverer » ordering columns and rows in a matrix report (oracle10g R2, windows7)

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

ordering columns and rows in a matrix report [message #558199]

Wed, 20 June 2012 03:50

7anona
Messages: 72
Registered: February 2012

Member

hello to all,,,
I am having a matrix report, which has its column cells from table A
and row cells from table B
when I run the report the columns and rows are not ordered
I wrote the order by statement in the report query but there was no defference.
I also wrot a subquery like
select column1, column2, (select column3 from table1 order by code)
from .... but it seems I can not order in a subquery
Is there any way to do that
help please

Report message to a moderator

Re: ordering columns and rows in a matrix report [message #558200 is a reply to message #558199]

Wed, 20 June 2012 03:57

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

See whether the break order is correctly set.

/forum/fa/10258/0/

Attachment: break_order.png
(Size: 2.19KB, Downloaded 2272 times)

Report message to a moderator

Re: ordering columns and rows in a matrix report [message #558201 is a reply to message #558200]

Wed, 20 June 2012 04:08

7anona
Messages: 72
Registered: February 2012

Member

The colums I want to order are based on their code not their values

Report message to a moderator

Re: ordering columns and rows in a matrix report [message #558244 is a reply to message #558201]

Wed, 20 June 2012 06:51

cookiemonster
Messages: 13965
Registered: September 2008
Location: Rainy Manchester

Senior Member

And that prevents you following littlefoots advice because?

Report message to a moderator

Re: ordering columns and rows in a matrix report [message #558494 is a reply to message #558244]

Fri, 22 June 2012 22:48

7anona
Messages: 72
Registered: February 2012

Member

I tried what littlefoot adviced. but it ordered the cells based on their value.
I want to order them based on their primary key.
the primary keys of both tables are not included in my report query

Report message to a moderator

Re: ordering columns and rows in a matrix report [message #558499 is a reply to message #558494]

Fri, 22 June 2012 23:07

7anona
Messages: 72
Registered: February 2012

Member

thanks littlefoot it worked .
I included the primary key in the query previously and set the break order on the primary key
but the ordering seemed wrong because I forgot that it was saved as a varchar so I used to numbers(to_number(code))
and it worked. thanks again

Report message to a moderator

Previous Topic:	Columns don't align on 10g Reports off Reports Server
Next Topic:	Discoverer - 'Running Total' calculation

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 18 13:17:43 CST 2025