October 25, 2013 at 2:08 pm
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?
October 28, 2013 at 5:17 am
Did the user explain what happens when they try to sort the data? Are you able to see if yourself?
I run SSRS 2k8 R2 and my users have Excel 2007 and I haven't heard anything about sorting issues.
Mark
October 28, 2013 at 9:09 am
My users have excel 2013. I am using the interactive sorting that is available on SSRS reports
November 1, 2013 at 2:14 pm
This may be an Excel issue itself, my recommendation is to test the excel output in different Excel(s), 2007,2010,2013.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply