Hi Ko,

I think, I have a vague idea, why does it happen. I just checked it again, if I insert the Browse command just before REPORT FORM, it works fine. Otherwise it gives me this stupid error. I guess, it switches aliases somehow. The problem is, that this is a program, (Special app) which runs in a Form's DS. I believe Form uses a timer (this is not my application, so I don't know for sure). Therefore, this timer interfers with my program somehow. Now, does my explanation seem reasonable? What should be a workaround? In the meantime I ask my colleague, is it possible and what does she think. I probably would reorganize the special app to run in it's own DS by using session class (I already implemented it in another app with success).

>Just Trial and error, but what happes if you place go top before you print the report
>

---

>>Hi everyone,
>>
>>This is the piece of code:
>>

>>select pb_state_c+pb_st_mun as code, cnt(*) as deeds, sum(iif(!empty(pb_addruni),1,0)) as condos,;
>>	tn.fullname as town, mf.rec_end as highdate, mf.rec_beg as lowdate, ;
>>	pb_st_mun+strtran(str(cnt(*),6)," ","0")+dtoc(mf.rec_beg)+dtoc(mf.rec_end) as rpttext ;
>>	from (lcSrcTble) src, towns tn, mafiling mf;
>>	where src.pb_st_mun = tn.dortownnum ;
>>	and (tn.rcode+tn.townold = mf.rcode+mf.tcode) ;
>>	into table (lcOutTble) ;
>>	group by 1
>>	
>>if _tally>0
>>	set talk off
>>	wait window nowait 'Preparing data for the report...'
>>
>>	locate for code = "25020"
>>	if found()
>>		replace town with "Barnstable", ;
>>			deeds with deeds/6, ;
>>			condos with condos/6, ;
>>			rpttext with right(code,3)+strtran(str(deeds,6)," ","0")+dtoc(lowdate)+dtoc(highdate)
>>	endif
>>
>>	locate for code = "25035"
>>	if found()
>>		replace town with "Boston", ;
>>			deeds with deeds/13, condos with condos/13, ;
>>			rpttext with right(code,3)+strtran(str(deeds,6)," ","0")+dtoc(lowdate)+dtoc(highdate)
>>	endif
>>	copy field rpttext to (lcOutTble)+".dat" type sdf
>>    select (lcOutAlias)
>>	wait window nowait 'Now printing report...'
>>	report form MlsStat noeject noconsole to printer
>>	wait clear	
>>endif

>>When I executing it, it gives me an Error message: variable Deeds is not found. This error comes from the Report itself, there this field used. Hovewer, if I insert browse just before report form line, it works just fine. What am I missing here?
>>
>>Thanks in advance.