Hi Sergey,
Yes, this is a great strategy for reports. Unfortunately, I don't think we can apply this strategy because we are working with Stonefield's new Query/Report tool. It runs off of a data dictionary and several hooks like OnSelect, DOQuery, etc. from which to jumb into the process.

Doug Hennig has also added a great feature in that he reads the report form and sets the order (based on the grouping) and filters the Filter List of Tables so that only the tables on the report show up. Great stuff but we now need to figure out how to step into his process, reset the group and then let his processes continue.

Thanks for the help.

Regards,

Jim Smith
>Hi Jim,
>
>You can go this way, or you can add one extra field to your reporting cursor for grouping, populate it with appropriate values and use it in the report group.
>
>
>>Dear Sergey,
>>
>>Thanks for the confirmation. Now, all I have to do to generalize a standard report is change the EXPR field (grouping condition) and change the sort order coming back from MS SQL and this report can handle any number of REPORT BY Work Order Type, Work Order Cost Center, etc. condtions.
>>
>>What do you think?
>>