That sounds a good idea
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?
>>>>>
>>>>>>
Specialist in Advertising, Marketing, especially Direct Marketing
I run courses in Business Management and Marketing