>First as an introduction you may be receiveing many "uninformed" questions from me, what with Budget cuts our group of programmers have been tasked to rewrite all of our MIS in Visual FoxPro from DbaseV, without benefit of any formal training....so here goes the first one:
>I have read as many manuals as I can find and have producted the following SQL progarm to select my data (query) and feed it to a report , but the final output looks as as if no query/selection has occurred....help:
>

>CLOSE DATAB
>SELECT Reforg.code, Reforg.dept, Reforg.ccloc, Reforg.ccadmin,;
>  Reforg.divtitle, Reforg.activeflag, Reforg.bldg, Reforg.delflag;
> FROM reforg;
> WHERE Reforg.activeflag = "Y";
>   AND Reforg.delflag = "N";
> ORDER BY Reforg.code;
> INTO CURSOR Refcmdorg
>IF _TALLY < 1
>   MESSAGEBOX ("No Records selected, No report Generated")
>   USE
>   CLOSE DATAB
>   RETURN
>ENDIF
>SELECT Refcmdorg
>REPORT FORM refcmdorg.frx NOCONSOLE PREVIEW
>USE
>CLOSE DATAB
>RETURN
>

>Any help is most appreciated! Thanks

Few 'debug' ideas:
1. Issue Browse command before REPORT FORM just to check that you really grabbed data into cursor. If data is there, then the problem is inside REPORT Form.
2. If problem is in SELECT..., it might be that CLOSE DATA before SELECT creates problems: SELECT will automatically open table Reforg on default path (may it should go to another one?).

Edward Pikman
Independent Consultant