Wrox Programmer Forums

Need to download code?

View our list of code downloads.

Go Back   Wrox Programmer Forums > .NET > .NET 1.0 and Visual Studio.NET > BOOK: Professional Crystal Reports for VS.NET
Password Reminder
Register
Register | FAQ | Members List | Calendar | 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 tens of thousands of software programmers and website developers including Wrox book authors and readers. As a guest, you can read any forum posting. By joining today you can post your own programming questions, respond to other developers’ questions, and eliminate the ads that are displayed to guests. Registration is fast, simple and absolutely free .
DRM-free e-books 300x50
Reply
 
Thread Tools Display Modes
  #1 (permalink)  
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

Reply With Quote
  #2 (permalink)  
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.

Reply With Quote
  #3 (permalink)  
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

Reply With Quote
  #4 (permalink)  
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

Reply With Quote
  #5 (permalink)  
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

Reply With Quote
  #6 (permalink)  
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?


Reply With Quote
  #7 (permalink)  
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

Reply With Quote
  #8 (permalink)  
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

Reply With Quote
  #9 (permalink)  
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.

Reply With Quote
  #10 (permalink)  
Old December 10th, 2004, 03: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

Reply With Quote
Reply


Thread Tools
Display Modes

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 Off
HTML code is Off
Trackbacks are Off
Pingbacks are On
Refbacks are Off

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 07: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 29th, 2003 11:07 PM



All times are GMT -4. The time now is 01:10 AM.


Powered by vBulletin®
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
© 2013 John Wiley & Sons, Inc.