PC Review


Reply
Thread Tools Rating: Thread Rating: 2 votes, 3.00 average.

ASP.NET 2.0 vs. Crystal Report "The request could not be submitted for background processing"

 
 
patrice.pare@gmail.com
Guest
Posts: n/a
 
      12th Apr 2007
Hello,

Here is a summary of my Dev Environment:
I use Visual Studio 2005 Team Suite SP1 with Crystal Report XI SP1 on
a Windows XP SP2 development workstation. I also use SQL Server 2000
SP4.

And here a summary of what is the problem:
I have a web application that has a web form into which I read data
from a SQL database and load them in a ReportDocument of Crystal
Report.

The objective of this web form is to export the data into different
file format : .PDF, .DOC, .XLS.

I have no problem exporting the data to a PDF or DOC file. Neither I
get problem with the XLS (DATA ONLY). The files are created and I can
work with them.

The Error:
My problem is when I try to Export to a Excel file. I get the
following error :

The Stack Trace:
Error in File C:\DOCUME~1\HOME\ASPNET\LOCALS~1\Temp\ReportContact
{5B6B59D4-D2C1-403A-B717-3C32790340E7}.rpt:
The request could not be submitted for background processing.
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.Runtime.InteropServices.COMException: Error
in File C:\DOCUME~1\HOME\ASPNET\LOCALS~1\Temp\ReportContact {5B6B59D4-
D2C1-403A-B717-3C32790340E7}.rpt:
The request could not be submitted for background processing.

[COMException (0x800002ad):
Error in File C:\DOCUME~1\HOME\ASPNET\LOCALS~1\Temp\ReportContact
{5B6B59D4-D2C1-403A-B717-3C32790340E7}.rpt:
The request could not be submitted for background processing.]

CrystalDecisions.ReportAppServer.Controllers.ReportSourceClass.Export(ExportOptions
pExportOptions, RequestContext pRequestContext) +0

CrystalDecisions.ReportSource.EromReportSourceBase.ExportToStream(ExportRequestContext
reqContext) +260

[InternalException:
Error in File C:\DOCUME~1\HOME\ASPNET\LOCALS~1\Temp\ReportContact
{5B6B59D4-D2C1-403A-B717-3C32790340E7}.rpt:
The request could not be submitted for background processing.]

CrystalDecisions.ReportAppServer.ConvertDotNetToErom.ThrowDotNetException(Exception
e) +700


/*/*/*/*/*/*/*/

Looking for a solution:
The problem happens when this line is hit:

objReport.ExportToHttpResponse(ExportFormatType.Excel, Response, True,
sFileName)


I don't get why the three other export works and this one does not. It
is the same code safe from the line above where the parameters differ
for the obvious reasons.

Can someone explain me how to export to a Excel File please ?


Pat

 
Reply With Quote
 
 
 
 
Amit Modi
Guest
Posts: n/a
 
      20th Apr 2007
I am also facing the same error.... As per diffrent findings on net, i
think its error of framework. It can be only solved if you redsign your
report



*** Sent via Developersdex http://www.developersdex.com ***
 
Reply With Quote
 
 
 
 
Pat
Guest
Posts: n/a
 
      20th Apr 2007
I thought about it over and over and I might have found some reasons
why it does not work:

1. There are some formula fields in my report where I concatenate
fields together (ie: {Table1.field1} + ' ' + {Table1.field2} + ' ' +
{Table1.field3} + ' ' + {Table1.field4}) whose fields are large
varchar fields (varchar(250) and over);

2. Some of these fields are treated like HTML (see Format object
contextual menu, paragraph tab, Text interpretation);
{Table2.field1} + '<br />' + {Table2.field2}

3. There might be a limitation on Excel cell length (no more than 255
characters per example) (?);

4. The Detail section is composed of 4 or 5 DetailSections (Details
A,B,C,D,E...) (?)

I am only guessing here, hoping someone has answers to my questions.

Thanks a lot Amit Modi for your reply.


 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Crystal Reports .NET Error - "The request could not be submitted for background processing." Sunshine Microsoft Dot NET 0 8th Aug 2007 03:28 PM
Crystal Report "The request could not be submitted for background processing." Rocio Microsoft ASP .NET 0 28th Oct 2005 06:49 PM
Crystal Report "The request could not be submitted for background processing." Rocio Microsoft VB .NET 0 28th Oct 2005 06:49 PM
Crystal error The request could not be submitted for background processing Ahmed Hashish Microsoft VB .NET 0 27th Apr 2005 03:30 PM
Crystal Reports For .Net - Error in File. The request could not be submitted for background processing. =?Utf-8?B?QXVndXN0aW4gUHJhc2FubmEuIEo=?= Microsoft ASP .NET 1 20th May 2004 05:16 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 04:31 AM.