In an existing SSRS 2008 r2 report, the reports can be exported to excel successfully. However the users telling me they can not sort some of the columns in excel. Thus can you tell me what can cause the columns not to sort? Also can you tell me how to fix the sorting problems?
In addition, one of the reports that are exported have a column where there is a grahic that points up, points down, or looks like '-'. Can this column be sorted in an excel column? If so, can you tell me how this 'graphic' column can be sorted in excel 2007 toi current version?