Joined: 08 Aug 2011
Location: United States
Online Status: Offline
Posts: 1
Topic: Error in the document issue Posted: 16 Sep 2011 at 3:19am
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!
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum