thanx Barbara,

In the case I needed, I have the same table for 2 reports. Both reports use the same information, but 1 is more detailed than the other, requiring me to group cells of one field with different values, into a general value, depending on the user.



>Perry,
>I saw that Ed Pikman gave you a good solution, but you might consider running your reports from a cursor instead of the base tables. That way you can add an ORDER BY clause and don't need an index.
>
>There are other advantages, too which have been reported often here.
>
>Barbara
>
>
>>Hi all,
>>
>>I have a report that I created, but I didn't set an index tag for the field I want ordered in the grouping. Ex.
>>
>>Field 1 Field 2
>>1 a
>> b
>>
>>and so on...
>>
>>I tried SET ORDER TO TAG Field2 before I execute my report and did not get the results I wanted.
>>
>>Can I set a primary and secondary oder in hard code such as:
>>
>>SET ORDER TO TAG Field1,Field2 OF MyCDX
>>
>>or something similar???
>>
>>
>>TIA