Home » Developer & Programmer » Reports & Discoverer » order in matrix report column
order in matrix report column [message #456998] Thu, 20 May 2010 11:15 Go to next message
cestsourire
Messages: 7
Registered: April 2010
Junior Member
I have to set a matrix report as follow:
- in the rows the machine_id.
- in the column the material_lib.
Table material ( material_id,material_lib,ordre)
- in the cells quantity.

I get successfully my matrix through the wizard of report, but i should display the columns sorted with the field ordre.

Please have you any idea how to get the columns of the matrix sorted.

Thank you,

Best regards.
Re: order in matrix report column [message #457088 is a reply to message #456998] Fri, 21 May 2010 00:54 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Did you include ORDER BY into the report query?

Also, I guess that you should set columns' "Break Order" property to Ascending (or Descending) - you'll know it is correctly set by an arrow sign:

/forum/fa/7828/0/

Re: order in matrix report column [message #457123 is a reply to message #456998] Fri, 21 May 2010 02:51 Go to previous messageGo to next message
cestsourire
Messages: 7
Registered: April 2010
Junior Member
Of course I have set an "order by" clause to sort my rows.
I can not introduce the field of order of my columns in the "order by" clause because it is not set in the select clause.

Concerning the "break order", it is about sorting the columns to ascending or descending. But I should, sort my columns by the field ordre.

So how can i introduce this order?


Thank you.
Re: order in matrix report column [message #457142 is a reply to message #457123] Fri, 21 May 2010 04:57 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
cestsourire wrote on Fri, 21 May 2010 09:51
I can not introduce the field of order of my columns in the "order by" clause because it is not set in the select clause.

Perhaps you could try to include that column into the SELECT statement, but - when wizard prompts which columns to display - omit that one?
Re: order in matrix report column [message #457197 is a reply to message #457142] Fri, 21 May 2010 14:24 Go to previous messageGo to next message
dude4084
Messages: 222
Registered: March 2005
Location: Mux
Senior Member
Basically, Littlefoot's idea is correct.


I suggest you following small steps. (tue it according to your needs)

1) Double Click Q_1 in data mode, and edit your query by introducing field ordre in select and order by clause. Click ok.

2) You will notice that the field "ordre" will appear in G_1. Just drag the field and move it in G_2 where field material_lib is present.


Thats All.

It will bring it in order of ordre.

--Good luck
Re: order in matrix report column [message #457377 is a reply to message #456998] Mon, 24 May 2010 02:47 Go to previous message
cestsourire
Messages: 7
Registered: April 2010
Junior Member
Thank you for your replies.

I have followed the steps suggested and it works fine.
Previous Topic: Data inserted twice in report
Next Topic: Oracle Reports with Java Barcodes.
Goto Forum:
  


Current Time: Fri Mar 29 07:46:16 CDT 2024