>>>>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
I think you are on to something. But I need to figure how to "keep the grid from having focus." I am not doing anything to set the focus into the grid. So, how do I keep the focus out?
Thank you.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham