Select worked in V7 but not in V8

[Rena]

I have discovered two reports that worked in V7 but now that I have "upgraded" to V8 they don't work. These reports access a VFP database via ODBC. The problem seems to be with selecting on date fields. In VFP if the date is blank you have to select date(1899,12,30). I have worked around this by putting the date parts of my select in the suppress in the Format Section on the detail line. This was acceptable for one of the reports but the other one had a total field that is incorrect. Has anybody else run into this problem? Got any other suggestions?

TIA!
Rena

 

[LoaferMan]

You may want to try rebuilding the reports using OLE DB instead of ODBC. With NT and SQL Server 2000 we have had much better data access with OLE DB.

LoaferMan

 

[Rena]

I was able to discover a solution to my problem by writing a formula and then using that in the select. However, I am interested in your suggestion. How do you access a report using OLE DB?