Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Lost Foxpro index from Crystal 6 to Crystal 7

Lost Foxpro index from Crystal 6 to Crystal 7

Lost Foxpro index from Crystal 6 to Crystal 7

In a report written in CR 6, all but 2 indexes are lost when the same report is written anew in CR 7, pulling from 2 Foxpro 2.6 data bases. Either data base can be accessed alone in the CR7 report, but not both. This problem, though not the solution is recorded in Crystal Decision's web site. Any help would be appreciated.

RE: Lost Foxpro index from Crystal 6 to Crystal 7

Can't you manually assign the index to the tables that lose them?  That may have been how the V6 was created.  I think CR will only find the indexes automatically if they have the exact same file name as the DBF.

If you were to recreate the report in V6 using the same environment does it pick up the indexes correctly?  

Ken Hamady
On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

RE: Lost Foxpro index from Crystal 6 to Crystal 7

I tried to recreate the report after finally finding an upgrade copy of V6 and a computer to put it on. I tried adding the same two Foxpro databases to a new report. One data-base is fine. The other it won't allow me to add. It says that pdbbtrv.dll is missing, and that it is an unknown data base type.

RE: Lost Foxpro index from Crystal 6 to Crystal 7

Weird, that dll is for Btrieve, not FoxPro.  Are you sure you have FoxPro files (ending in DBF?  Do you have index files? what is the extension on the indexes?

Ken Hamady, On-site/Phone Crystal Reports Training/Consulting
Quick Reference Guide to using Crystal in VB

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close