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 |
|
gashdc
Starting Member
12 Posts |
 Posted - 2004-11-18 : 10:09:28
|
| I have a report that is made up of several smaller reports. My main report has a main list and then an inner list. I have this set up so that the entire report is repeated for each individual product campaign, one per page (in other words, I have 20 or so pages of the same report, populated with different data on each page). This report contains tables, matrices, and pie charts. I can get it to eventually display fine through the Report Manager, however when I try to export the file to an Excel document it gives me a me an Internal Error. When I click on export, a blank pop-up window appears which is normal for exporting to any other type. However instead of asking me whether I want to Open or Save the document it gives me the following error; “Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.” And when I go to the online help it tells me I had an internal error on the report server. But there are several other reports on the same server all of which are able to export to Excel. The only difference that I can see is that my report contains pie charts. If any one can help me out with this it would be greatly appreciated. Thanks! |
|
|
jhermiz
3564 Posts |
Posted - 2004-11-18 : 20:04:57
|
quote:
Originally posted by gashdc
I have a report that is made up of several smaller reports. My main report has a main list and then an inner list. I have this set up so that the entire report is repeated for each individual product campaign, one per page (in other words, I have 20 or so pages of the same report, populated with different data on each page). This report contains tables, matrices, and pie charts. I can get it to eventually display fine through the Report Manager, however when I try to export the file to an Excel document it gives me a me an Internal Error. When I click on export, a blank pop-up window appears which is normal for exporting to any other type. However instead of asking me whether I want to Open or Save the document it gives me the following error; “Exception of type Microsoft.ReportingServices.ReportRendering.ReportRenderingException was thrown.” And when I go to the online help it tells me I had an internal error on the report server. But there are several other reports on the same server all of which are able to export to Excel. The only difference that I can see is that my report contains pie charts. If any one can help me out with this it would be greatly appreciated. Thanks!
Usually this error is a problem with the report itself, it could be a mistake in your rdl / procedures / function calls / etc.You did mention this is a list report with sub reports with charts and stuff, I think you may have to look really close at the report.I wish you could send reports to others but unfortunately one needs the db :(Jon |
 |
|
|
gashdc
Starting Member
12 Posts |
Posted - 2004-11-19 : 13:27:02
|
| Jon,Sorry to not get back to you earlier, but the exact error it says when in the .NET IDE is "An unexpected error occured in Report Processing. Object Reference not set to an instance of an object." Any ideas on what exactly that means? Let me know if you can, thanks for all your help.David |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-11-19 : 13:48:51
|
| Yes this is an error generally due to the graphs / charts. Try it out for yourself. In VS.net double click the graph or chart that you have. You will notice this error message come up. I read that MS is releasing some sort of fix for this in the next version.Jon |
|
|
|
gashdc
Starting Member
12 Posts |
Posted - 2004-11-19 : 13:56:44
|
| Jon,I double click and get no error message? The graph appears to be working fine, besides the whole exporting to excel thing. But it appears in the preview just fine and when published I can view it through the report manager. Just when I go to export to excel I get that error. Any idea where you read about this potential fix?David |
|
|
|
jhermiz
3564 Posts |
Posted - 2004-11-19 : 13:59:03
|
| Argh Ill dig it out.I seem to always get an "Object reference not set to an instance of an object" for any type of chart or graph when you double click on it. I have a feeling some where on that report that excel doesnt like something just not sure what. I don't think I can help without looking at it.SorryJon |
|
|
|
gashdc
Starting Member
12 Posts |
Posted - 2004-11-19 : 14:02:04
|
| Jon,Thanks for your help anyways, I was reading the Online Book some more and do you think it could have something to do with the page breaks that I have? It says that Excel does not support "pagination" but I guess I made the assumption that it would just skip those or at worst give me a more "friendly" error? Any thoughts?Thanks again,David |
|
|
|
|
|
|
|
|
Not able to export to an Excel file