Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Error in the document issue Post Reply Post New Topic
Author Message
free bird
Newbie
Newbie
Avatar

Joined: 08 Aug 2011
Location: United States
Online Status: Offline
Posts: 1
Quote free bird Replybullet 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!


IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
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



This page was generated in 0.012 seconds.