Specific sort order

[Kozbot]

Hello

I have a query that is returning running conditions for a machine over multiple shifts. the table is set up like this

date            shift    parameter      condition
09/13/13        1         front            500
09/13/13        1         middle          450 
09/13/13        1          back           475
09/13/13        2         front            510
09/13/13        2        middle           460  
09/13/13        2         back            490

this is just a small example. there are about 24 different parameters reported on in a shift

I want the query to sort by date ascending, shift ascending, and then by parameter in a specific custom that i define. I want it ordered "front, middle, back" for each shift. Again this is just an example, there would be 24 parameters I want in a specific order. Then do I need to define the sort order again for the report based on this query?

Thank you!

 

[namliam]

if you want to define your sort order, the easiest solution is to create a sorting table.
SortOrder - Parameter
10 - Front
20 - Middle
30 - Back
etc...

Join this table to your values and sort on the (hidden) column of sort order (asc or desc) and you should be golden
The reason for keeping 10 numbers available in the SortOrder is that you can more easily move around stuff in the future by inserting a 15 or 17 value....

 

[Kozbot]

if you want to define your sort order, the easiest solution is to create a sorting table.
SortOrder - Parameter
10 - Front
20 - Middle
30 - Back
etc...

Join this table to your values and sort on the (hidden) column of sort order (asc or desc) and you should be golden
The reason for keeping 10 numbers available in the SortOrder is that you can more easily move around stuff in the future by inserting a 15 or 17 value....

Thank you!

Now how do I apply to this a report?

 

[namliam]

I think I told you that already? its a basic query that you can simply use as a source for your report.... unless I am misunderstanding your question