I am using crystal with ASP.NET 2003 ( This is crystal 9.0 , I believe ). I run a crystal report using the crystal viewer control, then export into Excel ( Excel 2000 ), using the export icon . As some of the columns are created as Merged cells, Excel will not sort them.
I understand that this problem was raised in this forum but the advice was to upgrade to Crystal 9.0. ( which I am using ) - but I still have this problem - is this a known limitation, is there a workaround ?