cancel
Showing results for 
Search instead for 
Did you mean: 

SQL definition file does not exist

Former Member
0 Kudos

Hello!

I have an issue - when I open one of the existing reports, save it with another name and try to open report with the new name in another program (Eci M1 ERP system), it show me a message "SQL definition fine for %path to report% does not exist". What cause this problem? Is there a way to fix it?

Thanks!

Accepted Solutions (1)

Accepted Solutions (1)

abhilash_kumar
Active Contributor
0 Kudos

Hi Alena,

What version of Crystal Reports is this?

Guessing by the error message it looks like you're using CR 8.5 or older. Those older versions supported reporting off of SQL queries via a definition file which I guess needs to be moved with the report.

I'm hoping would be able to assist.

-Abhilash

DellSC
Active Contributor
0 Kudos

Unfortunately, I never used this feature with older versions of Crystal.

I would take a look at the old rpt file in the file system and see if there is a file without a .rpt extension that has the same name as the report.  If it does, then copy that file and rename it to match the new report.

-Dell

Former Member
0 Kudos

Abhilash,

I'm using Crystal Reports 2013

DellSC
Active Contributor
0 Kudos

Was the original report written in an earlier version of Crystal?

-Dell

Former Member
0 Kudos

Dell,

Unfortunately, I don't know, but I can to figure that out!

Former Member
0 Kudos

Dell,

I wrote to ERP system support, they told me to copy and re-name couple more files (*.ttx and *.vbs). It helped.

Sorry for disturbing. And Thank You for your time!

Alena

Answers (0)