Showing Deleted Records

[HowardHammerman]

I am using a FoxPro database (*.dbf) that has some deleted records. In FoxPro deleted records are not physically deleted untill you issue a purge command.

In Crystal 8.5 I want to showw ALL the records including the deleted ones. I tried to do this with the direct connection and with ODBC. I tried various options in the ODBC DSN.

I still only get the un-deleted records in my report.

Any ideas? Can this be done? Howard Hammerman,
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[Reebo99]

Have you tried the native connection? Reebo
Scotland (Going mad in the mist!)

 

[kenhamady]

Howard,

Have you tried R&R report writer?
I seem to remember that you can do this in RR...

Seriously, that is the one task that makes me keep RR around.
I don't think you can do this in Crystal. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[synapsevampire]

I even tried OLE DB and ADO, no luck...

Purdy annoying, the only option that comes to mind is to create a deleted flag and undelete the rows.

-k

 

[HowardHammerman]

Thank you everyone. Ken, yes I know that R&R can do it.

It is always interesting to find a feature that R&R can do that Crystal can't. Howard Hammerman,
Crystal Training and Crystal Material
On-site and public classes
Low-cost telephone/email support
FREE independent Crystal newsletter
howard@hammerman.com

http://www.hammerman.com

800-783-2269

 

[Shusha]

what is R&R?? Just point me to the site and I will learn more about it.. thanks.. usha

 

[kenhamady]

A report generator:

http://www.livewarepub.com/products.htm

Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[Shusha]

As always Thanks ken..
usha