Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Export Report to Excel 2000

Status
Not open for further replies.

pwomack

Technical User
Apr 16, 2005
121
US
Using SQL Server 2005 SP1 and Excel 2000.

I have three reports with matrix controls. When I attempt to export the reports in Report Manager to Excel, I get a Windows dialog prompt to 'open' or 'save'. When I choose 'open', Excel opens, I get a brief flicker in Excel, but the report does not export to Excel. When I choose 'save', the report does save to Excel.

I would like for the report to export when the user chooses 'open'. Anyone have an idea what the problem might be?

Thanks.
 
We see this a bit - the report does go into excel but you have to click on it twice (excel) to see it - seems to be some form of automation glitch that doesn't hand the focus back to excel properly after sending the data

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Geoff, No amount of clicking by me in Excel makes the report appear.
 
hmmmm - I get exactly the same situation except that after I have clicked on excel in the taskbar twice, the file pops up. Sorry - not sure what else to suggest...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
This probably doesn't help, but it seems to work fine both ways with Excel 2007.

When you say flicker, maybe the font is exporting as white. Look at some of the cells and see if there is anything in them.

Good luck!
Brett

--------------------------
My new website coming soon!
 
Brett, when I say flicker I mean the area of Excel where the workbook should appear is white for a split second, then turns to grey.
 
Have you tried doing this with excel open initially and closed intially? Have you tried doing it when there is a workbook already open and when there isn;t?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
Geoff has a good idea. When I did a project using the Office Interop over Sharepoint, the version of Word on SharePoint was not opening correctly. I had to tweak the registry on the SharePoint server to get it to work correctly. Hopefully doing this test will eliminate that possibility. Please let us know what you find out.
Brett

--------------------------
My new website coming soon!
 
Geoff, What I've just discovered is that when I close Excel after the export fails, and then export again to Excel (a second export), it works. Any comments?
 
Certainly sounds like some form of automation error but what exactly I can;t say - my setup is slightly different - SSRS 2000 and Excel 2003 so I don't get quite the same issue as you - poss to do with excel's ability to read the xml that is generated...

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question
 
I've found on occassion that when excel is shutdown the process remains running in the background (only sporadically). If you open task manager, and look for excel.exe it may be worth tracking what is happening to this process when you're trying to open the report.

If the excel processs is still running from a previous instance, the report may not be able to open a new instance for viewing. This certainly would explain it working after shutting excel down manually
 
I know when I was doing this through .net code and Word, you would have to close the object before creating a new one. I'm wondering how you would force that in your situation though. Maybe somehow check first to see if Excel is open and if it is, close it? You may have to create your own Excel export function though.

--------------------------
My new website coming soon!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top