Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

ssrs 2008 export to excel sort not working Expand / Collapse
Author
Message
Posted Friday, October 25, 2013 2:08 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 8:17 AM
Points: 362, Visits: 422
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?
Post #1508589
Posted Monday, October 28, 2013 5:17 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Friday, May 9, 2014 11:34 AM
Points: 128, Visits: 489
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



Post #1508811
Posted Monday, October 28, 2013 9:09 AM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Tuesday, July 22, 2014 8:17 AM
Points: 362, Visits: 422
My users have excel 2013. I am using the interactive sorting that is available on SSRS reports
Post #1508948
Posted Friday, November 1, 2013 2:14 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: 2 days ago @ 8:04 AM
Points: 17, Visits: 81
This may be an Excel issue itself, my recommendation is to test the excel output in different Excel(s), 2007,2010,2013.
Post #1510805
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse