Useing Diffrent Tables in 1 Report.

[bill993]

Hello All,
I am again, I Have an project and now i am converting this project in visul foxpor, i am have problum in reports. I am sucessfull Done my all Input Forms, Now i want to convert my Reports, in VFP,
Here is Example of Mathord that i am useing.

Report form my repo.frx to file abc.txt
it is sucessfull working when i have first time run this command, and show me all report with records.
but
when i am close the TEXT file and re run the report, its show me an variable ERROR. that variable is not found
infact i am useing 2 diffrent Table in 1 report and that variable come from 2nd database file.
please guide me what i do?
I hope to see your best comments.

 

[ajoyk]

In my opinion its always advisable to use one report cursor to generate the report.
In your case maybe the wrong cursor is selected so it will be proper to see that the correct cursor is selected and all field names are prefixed with alias name since you are using two cursors.
Try and use one cursor.
Hope this helps
AjoyK