DBF()
>
>Can you tell me exactly how to do that - and in particular to make sure I get the full path of the alias
>
>Thanks
>
>>Add field to report with expression ALIAS() to see what the current alias is.
>>
>>>Yes I know but I deliberately selected the file vfp sql has just created but I will double check tomorrow
>>>
>>>Thanks Sergey
>>>
>>>>A report is driven by the alias that is current when report is launched. Do you have a timer or form with grid that could switch work area on you?
>>>>
>>>>>Yes driverpt and if I open the report and print it manually I get the right answer
>>>>>
>>>>>Thanks Sergey
>>>>>
>>>>>
>>>>>
>>>>>>It looks like wrong work area is selected when report is run. Do you have anything in reports DE?
>>>>>>
>>>>>>>
--sb--