>i have two tables parent with names and child with orders and dates. i want a report filtered to a certain date with the names is alpha order. the dates is no problem i have just added 'for date=v_specaldate' to the report command, but i can not get the names in the alpha order.
>what do i need to do?
>
>thanks,
>jim
Either index the field you want ordered or put the results to an SQL cursor and order them.
HTH,
Tom