cheerfulskeptic
Programmer
I am using Crystal 7.
ODBC is very slow to the Pervaisve SQL server 2000, so I decided to switch to the Crystal Btrieve Driver. Performance within Crystal was significantly improved. Here is my report structure
Main Report
3 groups of fields
innrmost group, account ID has a subreport in the group footer
the subreport contains the report data connecting to Pervasive SQL. Just one table, Invoice Detail (We're using MAX).
Here's the problem: in the subreport, I then specify the f:\MAx\sales\file.ddf location as the definition location.
The database table location (just 1 table) is f:\max\sales\invdet.dat alias Invoice_Detail.
Everything works great inside crystal. I used Recrystallize Pro to generate the ASP to display the report, but when I use the web activex viewer to view it, it gives me a CRAXDRT error. If I dont trap it, I get an ASP error saying "server threw an exception".
here's my logon info in my asp file:
crtable.SetLogonInfo cstr("f:\max\sales\field.ddf"), cstr("Invoice_Detail"), cstr(""), cstr("")
I even tried changing this code to UNC naming, ie, \\SPIRIT\MAX\SALES\field.ddf and \\SPIRIT\MAX\SALES\invdet.dat and changed to UNC inside crystal as well.. Same issue...
What am I doing wrong?
thanks!