>>>Hi,
>>>
>>>I am troubleshooting the following situation.
>>>
>>>When I call a procedure that creates a cursor and then prints a report based on this cursor, I get error:
>>>
>>>cannot find variable 'rec_type'
>>>
>>>REC_TYPE is actually a column in the cursor based on which the report is created.
>>>
>>>But when - right before I call REPORT FORM .... - I have the command BROWSE (which shows that the column REC_TYPE does exist), I have no problem/no error.
>>>
>>>The procedure is called from a click on a check box in a grid.
>>>
>>>Where do you suggest I look for the solution?
>>>
>>>TIA
>>
>>Can you access REC_TYPE like ?REC_TYPE w/o browsing?
>>Can you access like ?cursorAlias.REC_TYPE and cursorAlias.REC_TYPE in your frx?
>>
>>If you rename REC_TYPE, just for testing, does it help? At least the ReportBuilder uses this field name.
>
>I just tried and no problem getting the alias.rec_type value (in a messagebox). But then error again when executing REPORT FORM
>So far, I don't want to rename this from REC_TYPE to something different. I get an error, also missing a field, when I run a different report procedure from this check box Click in a Grid.
If the form you're doing this from has a grid, make sure to keep the grid from having focus when you run the report. If the grid gets focus, it changes the workarea to its underlying table.
Tamar