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 |
|
Jatsie
Starting Member
15 Posts |
 Posted - 2008-11-17 : 03:28:16
|
| HiI am trying to export reports from my SQL2005 report manager. If the report is bigger than about 40 pages, it will not export or open in Excel. It brings up the save or open box and then just dissapears when you click open or save. I can still export if I run on the server directly, but no clients can export reports bigger than that.Please help with any suggestions.Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 04:44:32
|
| i think that because the size of data exceeds the maximum available size for excel sheet. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-11-17 : 04:59:03
|
| Why dont you try exporting it to multiple sheets by putting page break after each table. |
|
|
|
Jatsie
Starting Member
15 Posts |
Posted - 2008-11-17 : 05:40:32
|
| But it works on the server. I go to http://localhost/reports on the server and it exports any report to excel. From my own computer it give me the open/save screen and then does nothing. I find no error in event log either.... |
|
|
|
Jatsie
Starting Member
15 Posts |
Posted - 2008-11-17 : 05:41:29
|
| Report is also just one table... |
|
|
|
Jatsie
Starting Member
15 Posts |
Posted - 2008-11-18 : 04:51:51
|
| I found the problem. Bitdefender business client was stopping the export. Uninstalled anti-virus and tested - working. I will play with AV setting and resolve, thanks for help. |
|
|
|
|
|
|
Excel export fails