I am using PB6.5 on NT4.0 with Sybase 11.
I have a datawindow that summarized dollar values at the divisional level, and
therefore has a group by in the SQL statement. The datawindow itself has a division
group with subtotals in the group footer. I am using the PFC sort service.
When I change the sort, even if I select division and some_dollar_value as the sort
fields, the divisional groupings get mixed up. (ie. records for division one appear
in division 3, etc.)
Is it possible to use the sort service on datawindows that have a group by in the SQL
and a group in the datawindow?
Any help would be greatly appreciated.
Thanks,
Jill
> [EMAIL PROTECTED] HOSTED BY IIGG, INC. FOR HELP WITH LIST SERVE COMMANDS, ADDRESS
> A MESSAGE TO [EMAIL PROTECTED] WITH THE FOLLOWING MESSAGE: help pfcsig
> SEND ALL OTHER INQUIRES TO [EMAIL PROTECTED]