I have two database:
FoxPro database - contains client info (name, address)
SQL Server database - contains appointmetns, orders, jobs etc.
How can I create reports using both databases
Thank you
SQL Server Reporting Services
I have two database:
FoxPro database - contains client info (name, address)
SQL Server database - contains appointmetns, orders, jobs etc.
How can I create reports using both databases
Thank you
Is there a way to have data from both databases in one dataset
I need to provide reports like: weekly sales by consultant - it has to be a list of customers (names) and total $ amounts sold grouped by product category.
I