Topic: Database Error: 4104 Posted: 27 Apr 2010 at 4:03am
Hello,
I am creating a new custom report for my company and I have run into an error. When Im in crystal reports XI, the preview run successfully with defaut data. When I try and run the report using my company's software, I get the following database error code (4104). Im not quite sure what you need to see to help me with my problem.
This is the SQL query that was created
SELECT "tblServiceOrders"."SONumber" FROM "Samplev10"."dbo"."tblServiceOrders" "tblServiceOrders"
Joined: 20 Nov 2006
Online Status: Offline
Posts: 3702
Posted: 27 Apr 2010 at 4:06am
What type of database are you connecting to? You need to look up the error number in the database documentation to determine what it means - it's an error that Crystal is just passing though from the database, so it won't be in the Crystal documentation.
I had the same problem using in the filter (and in the report) two or more tables.
I solved the problem placing in the report AT LEAST one field for each table used in the filter. It's not sufficient that tables are specified and relationed in the report but no field used.
PS Excuse my English
Ci sono due cose infinite: la stupidità umana e l'universo. E non sono sicuro della seconda (Einstein)
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
IP Logged
