>If you want to use FRX2Word, try making tables with your SQL output in a prg before issuing REPO FORM. My report is also built on SQL queries (of a Sybase back end via ODBC and remote views), but I create temporary tables and put them in the data environment of the VFP report refreshing them just before running the report shell program. That is, of course, if you want the FRX2Word functionality. Personally, when it works, I love it. I made a HTML also, and it worked just peachy.
>
>Jim
Jim
I made a test report and got your error. I fixed it by changing CURDIR() to SYS(5) + SYS(2003). On a large table though it ran VERY slowly. Seemed like about ten minutes to list about 400 names. Also, there are no progress messages or thermometer to let the user know to be patient. I will now try HTML.
Terry
It is impossible to make programs idiot proof. Idiots are too cleaver.
MCP( Tcp/Ip )