Dynamic data views in FoxPro - How to access from Crystal Reports?

[groundclutter]

I am developing fairly complex reports in Crystal Reports 8.5 against an accounting software package called "ProcessPro" which integrates with AccPac Pro Series erp systems.

It utilizes several Visual FoxPro (vers 6) free tables that reside in folders on the database server. I have made connections through ODBC looking at each folder (and its subsequent tables found therein).

Due to the number of folders (broken out by functionality), such as AP, AR, GL, SO, etc, report development has become a pain due to the number of data sources, etc.

Now, to my question!!!!

Can I create an SQL view, such as one you can create in larger DBMS software such as Informix, Sybase, DB2, etc.?

I need to combine the data of two tables (using a union query I am thinking) and have been able to view the query on the server but the report does not access it. So my two questions are:

1) Can I create a dynamic sql view in FoxPro, and if so, how?

2) I created a view in FoxPro, albeit maybe incorrect, but Crystal says "no fields available". What's up with that?

Sorry for the long explanation but thank you in advance for any help you provide. Also, I am cross-posting this to FoxPro group as well.

Thanks again!