Problem exporting to excel

Hello,

Im using SSRS and i made a report that has a huge quantity of data, and when i want to export it to excel i got the following error.

Server Error in '/Reports' Application.

---

For more information about this error navigate to the report server on the local server machine, or enable remote errors

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[Exception: For more information about this error navigate to the report server on the local server machine, or enable remote errors]

[Exception: An error occurred during rendering of the report.]

Microsoft.Reporting.WebForms.ServerReport.ServerUrlRequest(Boolean isAbortable, String url, Stream outputStream, String& mimeType, String& fileNameExtension) +489

Microsoft.Reporting.WebForms.ServerReport.InternalRender(Boolean isAbortable, String format, String deviceInfo, NameValueCollection urlAccessParameters, Stream reportStream, String& mimeType, String& fileNameExtension) +959

Microsoft.Reporting.WebForms.ServerReportControlSource.RenderReport(String format, String deviceInfo, NameValueCollection additionalParams, String& mimeType, String& fileExtension) +84

Microsoft.Reporting.WebForms.ExportOperation.PerformOperation(NameValueCollection urlQuery, HttpResponse response) +143

Microsoft.Reporting.WebForms.HttpHandler.ProcessRequest(HttpContext context) +75

System.Web.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() +154

System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) +64

---

Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.210

I can export other reports to excel, but not this one. Can anyone help me here?

Thank you

Does your report have more than 65,536 rows in it?

Jarret

|||

Hi,

No it hasn't, i found out the problem. It was two cells in the matrix that were hidden, once i made them visibile again, it worked.

Thanks for the work anyway

Problem Deploying Subreports with Main Report

Hi All,

Here's my problem. I have an SSRS report with subreports on it. The main report and subreports work fine on my machine when I run the main report. However, when I deploy them to our test server and change the server name of the shared datasource, only the main report brings back data. The subreports show an error of something like "Error in displaying the subreport" for each subreport. The subreports require parameters that I believe I am supplying from the main report. What am I doing wrong? Is it really necessary to deploy the subreports with the main report to the new server. With Crystal Reports, I didn't have to do this. Any thoughts or suggestions would be appreciated.

Are you sure that the subreports are using the shared datasource? Can you run any of the subreports by themself?

|||

SteffoS,

Thanks for replying. Yes, I can run the subreports individually and get data. Thanks again. Any other suggestions?

|||

Hi All,

I found the answer to my problem. When I right clicked on the subreport and chose properties then went to the parameters tab, I chose the Fields.fieldName.Value for the the value of my parameter. This is incorrect. What I needed to do and did was choose the <expression> item in the dropdown box then click on parameters and choose the correct parameter from the main report to be the value for the parameters in my subreport. Worked like a charm, but I'm not getting too excited. I've read too much that things just started working for people and they could not explain why. That's scary too. Thanks.

Problem Deploying Subreports with Main Report

Hi All,

Here's my problem. I have an SSRS report with subreports on it. The main report and subreports work fine on my machine when I run the main report. However, when I deploy them to our test server and change the server name of the shared datasource, only the main report brings back data. The subreports show an error of something like "Error in displaying the subreport" for each subreport. The subreports require parameters that I believe I am supplying from the main report. What am I doing wrong? Is it really necessary to deploy the subreports with the main report to the new server. With Crystal Reports, I didn't have to do this. Any thoughts or suggestions would be appreciated.

Are you sure that the subreports are using the shared datasource? Can you run any of the subreports by themself?

|||

SteffoS,

Thanks for replying. Yes, I can run the subreports individually and get data. Thanks again. Any other suggestions?

|||

Hi All,

I found the answer to my problem. When I right clicked on the subreport and chose properties then went to the parameters tab, I chose the Fields.fieldName.Value for the the value of my parameter. This is incorrect. What I needed to do and did was choose the <expression> item in the dropdown box then click on parameters and choose the correct parameter from the main report to be the value for the parameters in my subreport. Worked like a charm, but I'm not getting too excited. I've read too much that things just started working for people and they could not explain why. That's scary too. Thanks.