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 |
|
chriskhan2000
Aged Yak Warrior
544 Posts |
 Posted - 2005-09-13 : 14:41:05
|
| Anyone else has this issue. When I export my report to Excel, I get columns that are blank. This is extremely annoying in that the user has to go and edit or delete each column. Wonder if this is an issue or what I'm doing wrong. |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2005-09-13 : 15:17:22
|
| So does your report actually have data for those columns? Could you post a data example of what the report looks like and what the spreadsheet looks like.Tara |
 |
|
|
jhermiz
3564 Posts |
Posted - 2005-09-14 : 09:47:34
|
Chris,If you are referring to the export format in which the lines in excel disappear and one needs to delete and reformat to get the expected results then this is the major problem that a lot of people have discussed about. In fact on this forum it was brought up a few times.If this is the case (and if it isn't pardon me for not understanding), then their is no solution to this problem currently in RS. The problem is RS gives you the WYSIWYG so what you see is what you get, filtering modifying etc. after the export to excel is not fun. It is basically a way so that customers who only have office products can see that exact result in MS Office products such as excel. The notion of grouping and filtering becomes much more difficult because the report renders exactly as it would on a pdf or the actual RS component.I do not know if there is going to be a fix for this, they may just ask you to write an application that exports to excel using the excel object model :).Jon
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] |
|
|
|
|
|
|
Exporting to Excel issue