Reporting from multiple tables

[AngusCampbell]

I have a project where I must report on multiple tables at once for a singel report. The tables are practically identical in structure and are each in different directories (the client has their own reasons for this).

How would you approach this?

What comes to my mind is 1) multiple sup-reports or 2)Creating a script to append all tables to one master table for reporting and differentiating respective data with a field for name of originating directory.

Tables are .DBF and are on a Linux box using SAMBA to provide a Windows share.

Thanks for any suggestions

 

[synapsevampire]

Post your Crystal version and connectivity used.

If you use ODBC you may be able to manually create a UNION query on them.

Otherwise, using an Append in dbase or Fox (you didn't even state the database type) and creating a single table makes sense.

-k

 

[AngusCampbell]

Thanks, Vamp and sorry for the sketchy details.

I can use any version of Crystal for this new project, but might choose v.9 since they may be aquiring other software that uses that version.

It will be an ODBC connection, most likely, since I will also need to link with a companion MS Access table (data comes from 2 vendor applications), but that's another issue.

As stated the tables are in .DBF format, in this case using Advantage Database Server, probably v.6

 

[synapsevampire]

If you're including an MS Access table, you have a cleaner solution by LINKing (not importing) the DBFs into the MS Access database, generating the query in MS Access (Union them together), and using the MS Access query as the data source for Crystal.

This will remain dynamic and should simplify your life as all of the heavy lifting and SQL will be in MS Access.

-k