Groups are not working properly on server

[syncdba]

Hi All,
I have created a report in CRXI with 3 GROUP's in it.
1st GROUP BY app_date like Today,1 days,2days,3days...1 week,2week..1month.
2nd GROUP BY date
3rd GROUP BY app_name. Its working fine in CRXI.
Apps_date & date are different dates.The report shows data as follows:
App_name Apps_date Date
aaa Today 05/31/2007
bbb Today 05/30/2007
ccc Today 05/22/2007
aaa Today 05/21/2007

aaa 1day 05/31/2007
bbb 1day 05/30/2007
ccc 1day 05/27/2007
aaa 1day 05/26/2007 ....

When I saved report in Crystal Enterprise XI. The report shows data differently(seems groups are not working properly on server)..
App_name App_date Date
aaa Today 05/31/2007
bbb 1day 05/30/2007
ccc 1day 05/22/2007
aaa Today 05/21/2007

aaa 1day 05/31/2007
bbb 2day 05/30/2007
ccc 1day 05/27/2007
aaa 1week 05/26/2007

I'm trying to fix the group data on server. Does anybody has any idea how to solve this.

Thanks in advance.

 

[Madawc]

Please don't cross-post. This is anyway an Enterprise question, since it works in Crystal Reports.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10