Print Page | Close Window

Track-It Connection Error (Code 207)

Printed From: Crystal Reports Book
Category: Crystal Reports 9 through 2020
Forum Name: Data Connectivity
Forum Discription: How to connect to data sources and export reports
URL: http://www.crystalreportsbook.com/forum/forum_posts.asp?TID=15136
Printed Date: 28 Mar 2024 at 11:56pm


Topic: Track-It Connection Error (Code 207)
Posted By: little wing
Subject: Track-It Connection Error (Code 207)
Date Posted: 12 Dec 2011 at 5:47am
Hello Everyone,

I'm new to this forum and was hoping someone could help me with an error I am getting. When I try to open "Completed Work Orders by Department" or "Completed Work Orders by Technician", which are default reports in Track-It, I am able to enter values for the date parameters, but afterwards get the following error:

Failed to retrieve date from the database.
Details: '[Database Vendor Code: 207]'

And it says that 3 times. All other reports open beautifully, so even after researching the error code and some suggested fixes, I am still out of luck and am unsure of what to do! Thanks in advance for any help or advice.



Replies:
Posted By: CircleD
Date Posted: 12 Dec 2011 at 7:18am
If anyone has modified those reports then they need to be repointed to the DB.Hit Database>Set Datasource Location.This opens the "Set Datasource Location" box.make sure the top of the box matches the bottom and if not click on the source you need in the top box and the wrong table in the bottom box and hit Update button.Then you'll need to open the "Properties and change it from False" to "True".Even if they still match you may still need to change the properties.


Posted By: little wing
Date Posted: 12 Dec 2011 at 7:25am
Thanks much for the reply! I followed you up until the "open properties and change it from false to true" part. Which properties and how do I open them? Sorry I'm pretty new at this...


Posted By: little wing
Date Posted: 12 Dec 2011 at 7:27am
Sorry just figured it out, DSN Default Properties. Thanks again, I will post the result in a minute!


Posted By: little wing
Date Posted: 12 Dec 2011 at 7:31am
Same error... I'm using vTasks_Browse to create this report and it has a chart, everything displays correctly when I preview it in Crystal Reports so I don't understand what I'm doing wrong. Ouch



Print Page | Close Window