Hi There,

I have a bunch of reports I use in a .net web app. The reports work in Crystal Reports 9. They work most of the time in the web app, but after viewing a few reports I get the error "The request could not be submitted for background processing."

Additionally, sometimes I get the error "Ssystem.OutOfMemoryException was thrown."

I have already updated the computer with all the latest patches and service packs.

Any ideas?

Thanks.

Sincerely,

Paul O

Hello, Have you solved the problem. I'm receiving this message for the report developed in crystal 9 and while running in crystal enterprise 9 standard, the report fails after 10 minutes with the same message "The request could not be submitted for background processing File ...". Any help would greatly be appreciated.

Hi There,

...and the answer is...

When using a dataset in .NET the app will download all the data to the local machine. You can view the impact by loading the report and pressing ctl+alt+del and viewing the task manager process aspnet_wp.exe. Notice the memory, mine would go from 80,000k to 320,000k and the quit. To solve the problem I got in touch CR and then sent over the following code. What you need to do is create a parameter in your rpt file and then set the record filter in Report/Selection/Record and enter something like this:

{VW_recordsource.fname}={?param1}
and
{VW_recordsource.lname}={?param2}

        Dim strRpt As String
        strRpt = "report.rpt"

        Dim map As String = Server.MapPath(".")
        rpt.Load(map & "/" & strRpt)

        Dim crDB As CrystalDecisions.CrystalReports.Engine.Database
        crDB = rpt.Database

        Dim crTable As CrystalDecisions.CrystalReports.Engine.Table
        Dim crTables As CrystalDecisions.CrystalReports.Engine.Tables

        Dim crTableLogOnInfo As CrystalDecisions.Shared.TableLogOnInfo

        Dim crConnInfo As New CrystalDecisions.Shared.ConnectionInfo

        With crConnInfo
            .ServerName = "server"
            .DatabaseName = "database"
            .UserID = "name"
            .Password = "password"
        End With

        crTables = crDB.Tables

        For Each crTable In crTables
            crTableLogOnInfo = crTable.LogOnInfo
            crTableLogOnInfo.ConnectionInfo = crConnInfo
            crTable.ApplyLogOnInfo(crTableLogOnInfo)
        Next

        crTableLogOnInfo = crTable.LogOnInfo
        crTableLogOnInfo.ConnectionInfo = crConnInfo
        crTable.ApplyLogOnInfo(crTableLogOnInfo)

        rpt.SetParameterValue("para1", 1)
        rpt.SetParameterValue("para2", 2)

        Me.CrystalReportViewer1.DisplayGroupTree = False
        Me.CrystalReportViewer1.ReportSource = rpt


Hope that helps.

Pbo

Hello,
I don't understand what you are doing with the input parameters for the record selection. I'm more of a DBA than crystal reports developer so bear with my ignorance of the crystal syntax. Is there an issue with too many rows begin returned causing the report to crash or is it allocated too much memory?
Thanks
Bill

By not using a dataset you let the server do the data processing. If you want the report to filer you need to create parameters in the report and then pass the appropriate parameters. If you don't need to filter the report you don't need parameters or the record selection filter.

pbo

Ok, Our report in question has 4 input parameters to limit the data set returned. The report works for small date ranges but when we specify the input parameters for date start and date end to run for an entire month the server chokes and its not apparent why. For a month's data, the data set is huge so I think the problem could be related to the size of the data result set. What I don't understand is error message. It sounds like the report never ran but indeed it ran for several minutes before failing. So when you limited the data result set using input parameters to filter the data , the error message went away and your report completed successfully?

Hi There,
You keep saying dataset. Are you still using the the .NET dataset object or have you changed to the other model? If you're using .NET datasets you will probably continue to have the problem. If you have switched to the example I posted and still have memory problems I don't have any new ideas except call BusinessObjects (Crystal Reports). We have a boatload of data for our reports and it worked here. Like I said, when as were using .NET datasets our asp process went up from 80,000 to 320,000. Now the asp process doesn't move from 80,000.

good luck.

pbo

Here's the BusOb link

http://support.businessobjects.com/l...s/c2010275.asp

We are not using .NET . Our crystal report calls a stored procedure passing several input parameters and returning the data via the reference cursor.

Hi

i could't understand this :
{VW_recordsource.fname}={?param1}
and
{VW_recordsource.lname}={?param2}

and what is this?