>>>Help!
>>>
>>>I have a report generated from a genxtab result. When I ran from foxpro 2.6 integrated environment, it was working fine. However When I distributed it using the distribution kit (make exe), the executable couldn't run the report properly. If I ran the executable file in the integrated environment, it worked fine.
>>>
>>>I cannot figure out what is wrong. It seems to be some setup that needs to be done. Anyone can help?
>>>
>>>I patched my genxtab using the file downloaded from MS.
>>>I
>>
>>You don't necessary need to include the program in your project. In this case, you should have a copy of the compiled program (FXP file) that's pointed to by the _GENXTAB system variable. You can initialize this in your CONFIG.FPW file with:
>>
>>_GENXTAB = C:\FOXPROW\GENXTAB.FXP
>>
>>Naturally, the directory should reflect the actual current location of the file.
>>
>>When you wish to execute the program, use:
>>
>>DO (_GENXTAB) WITH 'QUERY'
>>
>>HTH,
>>
>>George
>
>The code in my program.
>
>SELECT FISH_CODE, SIZE_NO, SIZE_DESC ;
> FROM FISHSIZE ;
> ORDER BY FISH_CODE, SIZE_NO ;
> GROUP BY FISH_CODE, SIZE_NO ;
> INTO CURSOR SYS(2015)
>DO (_GENXTAB) WITH "QUERY1"
>
>My config.fpw.
>
>KEYCOMP = WINDOWS
>MVCOUNT = 512
>CATMAN=OFF
>_GENXTAB=C:\FPW26\GENXTAB.FXP

Are you sure that your query (in production) is returning records? I'd add IF _TALLY > 0...ENDIF around the call to the crosstab generator. You might also take a look at the actual program code in GENXTAB.PRG. You'll find a description of the allowable parameter list. The program will create the same type of output as input. In other word, if a cursor is the input, a cursor will be the output.

George
>
>As I said, it worked fine when I ran my problem within Foxpro environment but once I ran executable from windows, it wouldn't work (for example, use Start-run or create a program item in win3.11). Normally, I would see the thermometer followed by the report. But no thermometer or report comes out and when I get out of the form, it comes out with 'LOCATE QUERY1.DBF'.
>
>Anyone knows what is the problem? I am stuck...... help!!!