Creating report from MDF and DBF

Meeting place for R&R customers and clients to share tips and ideas. Post your questions, messages or problems here.
Post Reply
jefffried
Posts: 16
Joined: Tue Oct 10, 2017 12:44 pm

Creating report from MDF and DBF

Post by jefffried » Thu Dec 07, 2006 6:38 pm

With Reportworks Infinity (v 12), can you create a report that pulls from MDB (MS Access) and DBF files? There would be key fields in each that would form the basis of building a relationship, so I wonder if, for example, the master file is an MDB file, can a relationship be set up with a DBF file. And vice versa, can a master be a DBF with relationships set up with MDB tables?____I assume if this can be done, it can be done with the SQL version.____If you know the answer, please advise. Thanks.____Jeff Fried

kfleming
Posts: 5795
Joined: Tue Oct 10, 2017 12:44 pm

=> Creating report from MDF and DBF

Post by kfleming » Mon Dec 11, 2006 1:07 pm

You would need to create a SQL report against the Access table and export the results to DBF. You can then use the Xbase version to combine the exported DBF with your existing DBF tables.____Kathleen__R&R Support

Jeff_Fried_(Guest)
Posts: 55
Joined: Tue Oct 10, 2017 12:44 pm

==> Creating report from MDB and DBF

Post by Jeff_Fried_(Guest) » Mon Dec 11, 2006 1:40 pm

Kathleen,____First, let me express my sorrow on your loss. This is an especially difficult season for this, and I hope you manage your way through it with a minimum of difficulty.____Thank you for your reply. I thought this might be the case, i.e., using the SQL version of R&R to then export Access data to DBF, then to combine with the DBF data.____Jeff Fried

Post Reply