>>>>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

thanks for the quick reply, you must be on line. i am not using SELECT SQL. what do you suggest otherwise, or is using SELECT SQL my only option.

jim