Home » Developer & Programmer » Reports & Discoverer » ordering columns and rows in a matrix report (oracle10g R2, windows7)
ordering columns and rows in a matrix report [message #558199] Wed, 20 June 2012 03:50 Go to next message
7anona
Messages: 57
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
Re: ordering columns and rows in a matrix report [message #558200 is a reply to message #558199] Wed, 20 June 2012 03:57 Go to previous messageGo to next message
Littlefoot
Messages: 19648
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
See whether the break order is correctly set.

./fa/10258/0/
Re: ordering columns and rows in a matrix report [message #558201 is a reply to message #558200] Wed, 20 June 2012 04:08 Go to previous messageGo to next message
7anona
Messages: 57
Registered: February 2012
Member
The colums I want to order are based on their code not their values
Re: ordering columns and rows in a matrix report [message #558244 is a reply to message #558201] Wed, 20 June 2012 06:51 Go to previous messageGo to next message
cookiemonster
Messages: 10981
Registered: September 2008
Location: Rainy Manchester
Senior Member
And that prevents you following littlefoots advice because?
Re: ordering columns and rows in a matrix report [message #558494 is a reply to message #558244] Fri, 22 June 2012 22:48 Go to previous messageGo to next message
7anona
Messages: 57
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
Re: ordering columns and rows in a matrix report [message #558499 is a reply to message #558494] Fri, 22 June 2012 23:07 Go to previous message
7anona
Messages: 57
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
Previous Topic: Columns don't align on 10g Reports off Reports Server
Next Topic: Discoverer - 'Running Total' calculation
Goto Forum:
  


Current Time: Tue Sep 30 23:52:44 CDT 2014

Total time taken to generate the page: 0.09906 seconds