>When I created the Reort using the report designer I did add the table to the data enviroment. I can not seem to figure out how to add an alias to the data enviroment (Alias instead of the name of the table on disk).
>
>I also do not have much luck using a sql statement and sending the output to a cursor or a report. When I create a report I need to have a file to use as the data source in report designer.
>
>Our system is an old DOS application. I wish to change it to VFP but I cannot use Data Base Containers because of the need to stay compatable with DOS 2.6 Foxpro. What I am now trying to do is start using VFP for reports and learn from there. I think VIEWS would do what I want but if I am understanding what I am reading the Views are only available when the dataenviroment is a Database Container not Free Tables.

Delbert,

The obvious solution, and my first pass at finding a solution, would be to keep the temp.dbf name constant. Is there some reason it has be be a unique name each time the report is run?

If the table does have to be a variable name, take the table name out of the data environment. In the routine that calls the report, open and select the table. This should permit your report to run.

I am not certain that you can run 2.6 and VFP using the same tables because of the codepage problem -- I have had some trouble using a table with VFP then trying to open it again in 2.6. "Not a dbf" is the usual error.

It may be that you are going to have to maintain two set of tables. A happy prospect, I'm sure?

regards,