crystal not seeing table

[mollie]

Hello -

I use crystal to read many tables in an accounting system (sagepro). We recently upgraded the accounting software, and I believe it's now in vfp9 -

Problem is that some of the crystal reports bomb because one of the tables is now not recognized by crystal as being a table.

example:

A report might be reading -

icitem - - - inventory item file
itran - - - inventory transaction file
arcust - customer file

when the report gets refreshed, it says icitem has changed, do you want to update (or whatever) - - -same thing for ictran. HOWEVER, when it gets to the arcust, it comes up with an ODBC error saying that it's not a table. There is absolutely nothing different other than the upgrade, and the other files seem ok.

any ideas?

thanks very much!

Mollie

 

[synapsevampire]

It'sprobably an unsupported data type.

Ask the vendor for an updated ODBC connection and use Database->Set Location to repoint the report to the tables if need be.

-k

 

[dgillz]

Is this an issue on existing reports, or new reports or both?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[mollie]

hello -

I will respond to both in this message.

1) I have done the set location to no avail. And the odbc driver is ok because it is reading the other tables (from same accounting system)

2) this is on both new and existing reports - - - crystal just will not see this arcust table.

thanks!

 

[synapsevampire]

Try changing your ODBC driver to one that supports the later version of dbase.

-k

 

[dgillz]

Are you sure arcust is not a view? Some versions of crystal - note that we don't know yours, since you didn't post it - don't see views automatically.

So what is your crystal version?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[synapsevampire]

btw, reading other tables doesn't mean anything if they don't have anything unsupported, the table you are trying probably has an unsupported data type.

-k