multiple connections

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

multiple connections

Post by jlassell » Fri Aug 08, 2008 2:41 pm

Can R&R SQL version connect to 2 different data sources in the same report and relate data between them -- ie, a SQL Server database and .dbf tables?__Thanks,__-Jeff

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

=> RE: multiple connections

Post by kfleming » Tue Aug 12, 2008 2:49 pm

Not in a single report. But what you can do is use the SQL version to create a report and then use File Export to export the results to a DBF file.____You can then use the Xbase version of R&R to combine that exported DBF with any other DBF that is available to you. The Xbase version will allow you to create an index on the fly so that you can set a relation to the exported table.____Hope this helps.____Kathleen__R&R Support

Post Reply