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

Discussion in 'Microsoft Dot NET' started by patrice.pare@gmail.com, Apr 12, 2007.

  1. Guest

    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
     
    , Apr 12, 2007
    #1
    1. Advertisements

  2. Amit Modi Guest

    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 ***
     
    Amit Modi, Apr 20, 2007
    #2
    1. Advertisements

  3. Pat Guest

    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.
     
    Pat, Apr 20, 2007
    #3
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Gary Bagen

    ASP .NET 2003 install breaks ASP page processing.

    Gary Bagen, Aug 29, 2003, in forum: Microsoft Dot NET
    Replies:
    0
    Views:
    174
    Gary Bagen
    Aug 29, 2003
  2. Alex Stevens
    Replies:
    1
    Views:
    1,696
    Alex Stevens
    Jun 30, 2004
  3. Kalpesh
    Replies:
    0
    Views:
    4,014
    Kalpesh
    Jul 28, 2006
  4. Guest
    Replies:
    2
    Views:
    659
    Guest
    Sep 13, 2006
  5. Sunshine
    Replies:
    0
    Views:
    444
    Sunshine
    Aug 8, 2007
Loading...

Share This Page