Wrox Programmer Forums
| Search | Today's Posts | Mark Forums Read
BOOK: Professional Crystal Reports for VS.NET
This is the forum to discuss the Wrox book Professional Crystal Reports for Visual Studio .NET by David McAmis; ISBN: 9780764544033
Welcome to the p2p.wrox.com Forums.

You are currently viewing the BOOK: Professional Crystal Reports for VS.NET section of the Wrox Programmer to Programmer discussions. This is a community of software programmers and website developers including Wrox book authors and readers. New member registration was closed in 2019. New posts were shut off and the site was archived into this static format as of October 1, 2020. If you require technical support for a Wrox book please contact http://hub.wiley.com
 
Old June 14th, 2004, 01:16 PM
Authorized User
 
Join Date: Jun 2004
Location: , , USA.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default request could not be submtted for background proce

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

 
Old September 9th, 2004, 02:50 PM
Registered User
 
Join Date: Sep 2004
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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.

 
Old September 9th, 2004, 03:12 PM
Authorized User
 
Join Date: Jun 2004
Location: , , USA.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old September 9th, 2004, 03:26 PM
Registered User
 
Join Date: Sep 2004
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old September 9th, 2004, 03:38 PM
Authorized User
 
Join Date: Jun 2004
Location: , , USA.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old September 9th, 2004, 04:16 PM
Registered User
 
Join Date: Sep 2004
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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?


 
Old September 9th, 2004, 04:39 PM
Authorized User
 
Join Date: Jun 2004
Location: , , USA.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old September 9th, 2004, 04:40 PM
Authorized User
 
Join Date: Jun 2004
Location: , , USA.
Posts: 21
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Here's the BusOb link

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

 
Old September 10th, 2004, 08:35 AM
Registered User
 
Join Date: Sep 2004
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

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

 
Old December 10th, 2004, 04:11 AM
Registered User
 
Join Date: Dec 2004
Location: , , .
Posts: 6
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hi

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

and what is this?


Quote:
quote:Originally posted by polofson
 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





Similar Threads
Thread Thread Starter Forum Replies Last Post
request forwarging & request redirection hafizmuhammadmushtaq Servlets 2 April 24th, 2008 12:42 AM
The request could not be submitted for background mvilas Crystal Reports 2 November 1st, 2006 08:20 PM
The request could not be submitted for background thlaing Crystal Reports 1 July 3rd, 2006 03:01 PM
request.qurystring vs. request.form Durwood Edwards Classic ASP Databases 3 June 18th, 2004 12:09 AM
request.querystring() , request.form() alyeng2000 ASP.NET 1.0 and 1.1 Basics 1 December 30th, 2003 12:07 AM





Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright (c) 2020 John Wiley & Sons, Inc.