Thanks, second way works fine for me.

>>I have a parent and child table.
>>
>>I have created query in which there are that parent and child table (in relation).
>>
>>I have made report that contains that query.
>>In report I have made group by field (field that is used for relation).
>>Now I want to sort details (by date) in every group but I can't do that!
>>I have put Order by (date) in query but it doesn't work.
>>
>>How to sort details?
>
>You mean you're using 2 tables for this? Easy solution would be a single SQL select where dat ais already sorted on groupfield and then by date.
>Using a2 tables and relation however you can do it using a compund index on child. ie:
>consider parent table id fiedl name is myID (integer) and child relation field name is myParentID and a date field named myDate.
>
>use myChild
>index on padl(myParentID,10,'0')+dtoc(myDate,1) && dtos() and optionally descending clause
>
>Your relational expression would be padl(myID,10,'0'). ie:
>select myParent
>set relation to padl(myParentID,10,'0') into myChild
>
>PS: Prior to VFP9 thiswould also work reversing the child and parent.
>
>Cetin