>Hi All
>I have using Visual Foxpro 6.0 and I have designed a report using report designer. I am accessing two files which I have added with the help of "Data Environment". Main file is having a field rocode which I have mapped with another file which has roname (rocode is common). There is one more field in the main file called sacode. I want my user to pass the value for this field and only generate report where sacode = code supplied by user. Can I do that ? Pl. help.
>
You can do this in a number of ways; the easiest might well be to simply add a FOR clause to the REPORT statement:
cSACodeToMatch = 'Foo'
REPORT FORM MyReport TO PRINTER FOR Main.SACode = cSACodeToMatch