>>I want to use VFP 3.0 as a reportgenerator for a large Btrieve database. There's one problem, I can reach the Btrieve table's using a odbc-driver. The result is a remote view of the btr-table in FP. But I have to create a report out of an combination of btr-tables. Here the trouble starts. I have found a solution, but I think it is a workaround.
>>1. create remote view's
>>2. establish the links
>>3. define a query
>>4. output query is a dbf result table
>>5. create a report out of the result table.
>>
>>Can somebody tell if there is a better way to obtain the same result?
>
>Jan,
>
>If it works, it's ok no? Why do you think it is not ok? To use the report writer you would need your data in a dbf format. You might also want to apply an sql on your remote views(guess this is the same as define a query), and save the data in a cursor (i.o. in a dbf) and then submit the cursor to the report writer.
>
>Groetjes,
>
>Marc
if your remote views are defined properly (in enough detail), you may be able to skip 3 and 4, running the report directly from the view. if you'd rather not set up your remote views to that level of detail, i'd recommend Marc's solution of building a cursor instead of a table to run the report against. remember that using cursors means having nothing in the data environment of the report...