Crystal-The request could not be submitted for background processing.

[ebonaba]

Since I have upgraded from Crystal 9 to XI, I have been having nothing but problems and I am sure a lot of you out there have too.

Error message:
Error in File C:\DOCUME~1\NORRIS\ASPNET\LOCALS~1\Temp\rptOnTimePerformanceByLocationReport {44C7095F-C2B3-471B-AEC1-69474A8936A0}.rpt: The request could not be submitted for background processing.

It took me 2 days to figure out that the reason for this error message was because my report did not like to accept blank strings as parameters.

In Crystal 9, this wasn't an issue. All of the sudden in XI, its an issue. So if any of you have run into this problem, check to make sure that you are not passing in blank parameters from your code into a Crystal Report. I am now passing in a string that looks like this: " " instead of this "" and it works fine.

It would be helpful if Crystal actually had some error messages that related to the problem at hand. It seems as though they have this one generic message for all sorts of errors.

 

[dgillz]

Somehow I think this is a crystal enterprise or crystal reports server issue, not a crystal reports issue.

Where are you running the report? In the crystal reports designer?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[MJRBIM]

If it is an Enterprise or Server issue - the "background processing" error is related to using the CUSTOM database settings in CMC when the RPT file has sub-reports with LINKED parameters.

You can fix it by updating the ORIGINAL database settings, instead of using the CUSTOM database settings in CMC.

 

[ebonaba]

I dont have sub reports in my report.

I have my reports in my web project in Visual Studio. I have a c# file which calls on the RPT and passes it parameters.

Like I said, this worked fine in Crystal 9.

My issue has been resolved but I know there are a ton of people out there who are getting the same error message and have no idea what it is. I think crystal uses a generic error message in some cases. It would be nice if they were a little more specific.

I have read so many forums and support topics on Crystal and it seems like no one ever really gets their questions answered.

My solution might not be the same for someone else but at least this is one thing you can try.

 

[dgillz]

Again, this really isn't crystal per se, this is Visual Studio. I have been working with Crystal for 10 years and have never seen or heard of such a message.

Take the .rpt file and run it in crystal reports designer. Does it run? If it does, it is not a crystal reports issue.

In any case, the best forum to post this in is Business Objects Crystal Reports 3: Integration, which is specifically here to deal with integrating crystal reports with Visual Studio, VB, and other languages:

http://www.tek-tips.com/threadminder.cfm?pid=768

Also, thousands of questions get sucessfully answered here every day. I personally have answer over 5,000 questions here on tek-tips. So your comment is way off the mark, and it is not going to help you.


Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[ebonaba]

I did try to run this same report in Crystal with a blank string as one of the parameters and it would not generate an excel file, it actually crashed the whole program.

When I passed in a character, it was fine.

 

[dgillz]

If you are running crystal reports stand alone, how did you "pass" a parameter value? Did you manually key it in, or select it from a drop down list?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[ebonaba]

In Crystal, I selected File --> Export --> Export Report. I then chose Excel from the list of menu items.

Once I chose this, I got a dialog box which allowed me to enter in all the values of the parameters that the report takes in.

Behind the scenes, I have a stored proc which dumps values into a table that this crystal report reads off of. This was necessary because the query was very complicated and doing it in crystal with my limited experience proved to be really frustrating. So this report is a simple select ALL from a table.

Most of these parameters that are passed in from my c# code are just for display purposes only. I have 2 different web pages which use this same (RPT) report and the parameters passed in change depending on what page generated it.

That being said, one of the reports has a blank string as a parameter. This is the report that was causing the problem. The other report always had all parameters loaded and this report would run fine both in my web project and in stand alone Crystal.

I even tried using a different report, one that was totally not related and one that didn't require me to use a stored proc to get data. I passed in a blank value as one of the string parameters and Crystal crashed each time. When I supplied a character, it generated the file fine.

It gives me this error: crw32.exe has encountered a problem and needs to close. It gives you those options to send the error file to Microsoft or not. Then it closes the program.

Is this not a crystal problem?

Thanks.

 

[dgillz]

What you do with your report afterwards, export to excel, print, whatever, is irrelevant.

When you hit refresh in crystal, any parameter fields in crystal should pop up and ask you for the value. Did this happen?

If so, did the report successfully execute and return the desired results?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[ebonaba]

Yes I said in my last post that I got a dialog box which prompted me for the reports parameter values.

When I entered in the information, I left one of the string parameters blank.

The report did not execute and Crystal reports crashed.

When I did enter in a value the next time, it worked fine.

Did I not say this in my previous post?

This didn't happen in Crystal 9.

 

[dgillz]

No, you did not say that in your previous post.

You started by telling me you exported data, and THEN you choose parameter values.

This is the opposite of the way things happen in Crystal. You get prompted for parameters, then the report executes, THEN you can export it.

So please try hit in order and see if you get the same results:

1) click on the refresh button
2) enter the parameter values
3) look at the report results (if any) on the preview pane, to see if the correct data is returned.

DON'T EXPORT, it is irrelevant.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[ebonaba]

Well obviously we misunderstood eachother.

I tried refreshing and I did get output. This error only happens when I export the file to excel, which isnt irrelevant to me because exporting to excel is a feature that I need.

I can generate a PDF fine too.

I dont have an issue anymore so I am not even sure what you are trying to get at here. I just posted what I did to get my report working in case someone else was in the same situation as I was. Its hard to find help with crystal issues.

 

[dgillz]

Ok, now go download the latest export driver hotfix from the BO website, and try it again. Obviously there is something wrong with the export functionality.

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry