I want to filter the data in a report, to create various versions of data outout according to the filter creteria. I have a form that allows one to enter various filter criteria eg: sale date = 12/02/2001 or status = S and so on.

How do I send these values to the report from the form, so that I can filter my data. I use the REPORT FORM command to call the report from the main form. I have tried using the command as follows: REPORT FORM myRep TO PRINTER FOR status = "S". However when I compile the form, it gives my a type mismatch error. Does the field status in my example have to be on the report I am calling?

Is there any other way I can filter the data in the report. I do not want to create a different report for every filter condition.