>>>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
>thanks Tom, but i have indexed the last name and placed the index in the 'order' under the names cursor of the report dataenviornment but it does not work. maybe i am not give the order in the proper location or i am missing something.
>
>jim
If your using a SELECT SQL then make sure your ORDER BY clause is set right.
Tom