| order in matrix report column [message #456998] |
Thu, 20 May 2010 11:15  |
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 #457123 is a reply to message #456998] |
Fri, 21 May 2010 02:51  |
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 #457197 is a reply to message #457142] |
Fri, 21 May 2010 14:24 |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
