>I know I saw this somewhere, but I can't remember how to do this. I've got a report that was designed using table field names directly. I need to change it to a view instead. I don't want to have to manually edit every field to change (Table1.field1 to v_Table1.field1). Is there an easier way?
>
>Thanks
use myview alias "Table1"
is the easiest solution as long as aliasname not in use. Or modify the frx to remove alias so it will use whatever current alias is (report would have no table in its DE for this to work):
use myreport.frx
replace all expr with stuff(expr,1,at(".",expr),"") ;
for expr = "table1."
Cetin