Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jassie
Constraint Violating Yak Guru
332 Posts |
 Posted - 2013-10-25 : 16:10:41
|
| 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? |
|
|
James K
Master Smack Fu Yak Hacker
3873 Posts |
Posted - 2013-10-25 : 17:04:49
|
| I have run into this usually when there are merged columns. That can happen depending on how your report is defined and in many cases you can change the report to avoid that (but not always). See if your report when exported to Excel has merged columns. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-26 : 08:07:26
|
quote:
Originally posted by jassie
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?
for graphic column to sort you need to sort on its actual value field.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-10-28 : 11:14:27
|
| The actual database column values are not what is appearing on the report. Just the graphic is being displayed. Thus how would you suggest that I obtain the actual column values? |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2013-10-28 : 13:10:50
|
quote:
Originally posted by jassie
The actual database column values are not what is appearing on the report. Just the graphic is being displayed. Thus how would you suggest that I obtain the actual column values?
bring it in the dataset, use it for sorting alone whilst displaying graphic content------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/https://www.facebook.com/VmBlogs |
|
|
|
jassie
Constraint Violating Yak Guru
332 Posts |
Posted - 2013-10-29 : 11:11:21
|
| Thanks! |
|
|
|
|
|
|
|
|
ssrs 2008 export to excel sort not working