Crystal Report Background processing Issue with .NET 2005

[Former Member]

We are getting following issue on few users machine whenever they click a button to view the report "The request can not be submitted for background processing"

The same report runs on other user machines and also works in dev environment. We have 10 reports and on one user issue is in 1 report and for other user that report works fine even with same data but there is issue in other report for other user.

Application development Environment:

Windows based application

Running in offline and online mode

Offline mode with local DB as SQL express MDF

VS 2005 -- .NET 2.0

SQL express 2005 MDF

SQL Server 2000

Crystal Reports DLL version -- 10.2.3600.0

*User Environment *

DOT NET framework 2.0

SQL Express

Crystal Reports DLL version -- 10.2.3600.0

To generate reports we are fetching data through Stored Procedures from database and pass this data to datasets, after that these datasets are used as a data source in the Crystal Report.

[Former Member · Accepted solution]

Hi,

Refer thread related to this issue - [;

Hope that would help you

Regards,

Amit

[Former Member · Accepted solution]

I already looked into this link and tried things mentioned there. But that is for ASP.NET. Ours is a windows application and each user has his own SQL express mdf and moreover same report run on other user with same data.

[former_member183750]

Vikas, I often recommend this approach to the issue:

When using datasets and you do not see the data as expected, 99% of the time is a data issue (usually a format issue).

Best way to troubleshoot ADO .NET dataset issues, is to save the dataset to an XML as:

myDataset.WriteXml(xmlPath, XmlWriteMode.WriteSchema)

I recommend doing this just before you set the dataset to the report. Then, open the repot in the CR designer. Go to the Database menu and select Set DataSource location. Point the report at the above exported XML using the ADO .NET driver (ADO .NET (XML)). See if the report runs in the designer. If you get Field Mapping dialog, this tells you that the report an not match the dataset to the fields it expects. You then have to modify your dataset to match the report.

See if the above helps,

Ludek

[Former Member]

This does not seems to be a data problem as after working on a quote user can check in the quote to server database and from there anyone can refer it. When other user tries to generate the same report on their machine for the same quote it works, again if first user tries, it fails.

It seems some setting issue may be registry setting on user machine as application and data are same for all users but report work for one user and gives this error for other user for same quote/data

[former_member183750]

You may want to do a SQL trace, or run a utility such as Process Monitor to see if there are issues with the registry or some files that need to be loaded. Process Monitor can be downloaded from here;

http://www.microsoft.com/technet/sysinternals/Utilities/SysinternalsSuite.mspx

Ludek