I see.
The easiest way is to do your SELECT in the calling program (this could be a PRG or a form method). First, remove the SELECT from your report. Be sure that
a) your report DataEnvironment is empty and
b) you have the Report DataSession as default (in the Report menu be sure that Private DS is NOT checked).

Then in the code that calls the program you put your SELECT statement:

cFilt = "StatusField = 'WORKING' "
Select ......   where &cFilt into cursor RptData order by .........

Select RptData
Report form MyReport Preview.......

Note that you can change the value of cFilt like any other variable to change the report output.

HTH
Barbara


>Hi Barbara:
>
>The report is working fine, the only thing I want to do is select out only WORKING status. My real question is where should I put my SELECT statement? It's
>currently trying to be run in command window of report designer. But this isn't
>working to good.