Doug,

The second suggestion is a bit complex even for me. The users of the program are not programmers, they have VFP based application, that does the job, but it's not designed with the good relational database and therefore we have to suffer trying to produce the reports we need.

>Hi Naomi.
>
>>1. On some reports today when I tried to go to Advanced option for the select, pressing the Advanced button freeze the application and I had to kill it. It happened two or three times during this evening.
>
>The only time I've seen that happen is when you have a cyclic relationship in your data dictionary, such as A -> B -> C -> A. Even then, though, Stonefield Query will stop when the number of levels it recurses gets too deep. That can take a while, so it may look like it's hung but it's still traversing the relationship tree.
>
>>2. Is there a way to group by certain fields but only when another field from the table has some particular value?
>
>You could add code in the AfterData event that does a conditional INDEX ON or SELECT based on the field's value. That would only change the order of the records. You'd also have to used the Advanced Report Designer to change the group expression.
>
>>3. In the original tables we don't have necessary indexes and the reports take a long time to preview. Would it make sense to try to change the tables and add the indexes? This is not my application, so I don't know if anything would be affected.
>
>Yes, anything you can do to optimize the query would help performance.
>
>Doug