order my groups by another field?

[mgason]

Hi I have data like this

BatchID1
ingredient1 weight
ingredient2 weight
ingredient3 weight

BatchID2
ingredient1 weight
ingredient2 weight
ingredient3 weight

I group my weights by BatchID giving a report that looks like above.
Currently I have BatchID in ascending order.
The customer wants the BatchID's to be displayed in a different order. Each Batch ID has a timestamp field associated with it in the same table. I want my BatchID groups arranged by this timestamp in ascending order.

I want to sort the groups, not the data within the groups.

How do I achieve this?

thanks
mark

 

[lbass]

If the date is the same for all weights within the batchID group, then insert a minimum or maximum on the date at the group level, and then go to report->group sort->select the summary to do a group sort. Adjust the ascending/ descending order, depending upon the summary you use.

-LB

 

[mgason]

Thanks for the reply,
I took another approach. I used another table that had just one timestamp per batchID.

I linked BatchID, then grouped by timestamp from the new table in ascending order, then by batchID as before.

thanks again for the prompt attention
mark