Strange date vale in DBF database.

[former_member1173617]

Hi All,

I have exported data from our accounts package iris Exchequer as a .dbf file. I am then trying to import it into crystal reports but the date crystal reports shows me is 40,389.00 or 20/08/1901. The actual date is 01/08/2010.

Can anyone help.

Thanks

[former_member1173617]

Hi Don,

Thanks for your reply,

If I use the official Exchequer ODBC Driver the date is pulled out correctly how the problem if that the way Exchequer works is it uses double intergers as explain below. The upshot of this is that it takes an absolute age to run any report using the ODBC drivers. iris exchequer has its own report writer so i have written a report to show the raw data need for my crystal report and there is an export feature to save to a .dbf file. I therefore was hoping to creat a mini database in effect that i could then use with crystal reports. But when I open the date field in crystal reports is seems to get scrambled??

"Due to the data structures used by Exchequer most of the floating point numbers are not directly accessible using DDFs. To overcome this problem we have split the numbers into 2 fields, a 2-Byte Integer and a 4-Byte Integer, these are indicated by a '_1' and a '_2' after a shared field name. We have provided a function EntConvertInts in EntFuncs.Dll to convert these to a standard Double type which can be used in most programs.

EntConvertInts is accessed in Crystal Reports via the add-in function EntDouble"

[former_member11696]

Hello,

Try using the Native Btrieve driver in Crystal Reports to see if you can report off the database file.ddf directly. May be security built in but worth a try. If you don't see Btrieve list in the Database Expert then go to Add/Remove Programs and select the options to edit the CR install and choose Custom and expand the database drivers and select Btrieve.

So we did see those field types but we may have problems reporting directly off of them. They were for internal Pervasive use only I recall. They may or may not work....

Not sure what the add-in function is so I can' t help you there...

Thanks again

Don

[former_member11696]

What database driver are you using?

What happens if you use a third party ODBC test tool to see what format it is in?

Thank you

Don