|
Hi, I created a simple report in Crystal Reports XI and it works just fine there, but when I load it to our database it sometimes works and sometimes gives me an error message: "Error in File C:\DOCUME~1\MyName\LOCALS~1\Temp\18\NameOfTheReport_3110 {lots of numbers}.rpt: The request could not be submitted for background processing."
The report only consists of the following command:
SELECT dm.DriveID, IsNull(a.InternalName, fssm.Description) as [Drive Name], dm.FromDateTime FROM DriveMaster dm LEFT JOIN Accounts a ON dm.AccountID = a.AccountID LEFT JOIN FixedSiteScheduleMaster fssm on fssm.DrawID = dm.DrawID WHERE dm.ExternalID = '' AND dm.StatusID <> 5 AND dm.FromDateTime >= {?StartDate} AND dm.FromDateTime <= {?EndDate}
And as you can see there are two prompts for a start and an end date.
I hope I provided sufficient details; thanks everyone in advance!
|