REPORT TO FILE 1

[Loompa]

I am attempting to send a report out to an ascii file by using the &quot;REPORT FORM xxxx TO FILE xxxx&quot; command.&nbsp;&nbsp;The output comes back with too much junk (</i> example: %-12345X@PJL SET PAGEPROTECT=OFF
@PJL SET DENSITY=3
@PJL SET RET=OFF
@</i>).<br><br>I realize there is the COPY TO option, but that will only leave me with detailed information and I need subtotals and totals.&nbsp;&nbsp;<br><br>Any help would be appreciated

 

[skelly]

You have to use REPORT FORM xxxx TO FILE xxxx ASCII - without the ASCII clause it includes PCL codes, etc. for the current Windows printer. <br><br>SK<br>

 

[Loompa]

Thanks for the response skelly.&nbsp;&nbsp;I did not mention that this is in FP 2.6.&nbsp;&nbsp;When I added the ASCII clause, I get &quot;Unrecognized phrase/keyword in command.&quot;&nbsp;&nbsp;<br><br>Any way around this (short of upgrading foxpro)??

 

[skelly]

Hmm... well one possible way is to setup a generic printer in your Windows setup. Go into &quot;Add Printer&quot; and select &quot;Generic&quot; printers, then &quot;Text Only&quot; as the type. Set this as your default printer in FoxPro. Then run the report as before - it should put only generic print codes into the report file. Good luck-<br>

 

[dgrewe]

Another thing you can do.<br>If you have a copy of FoxPro DOS 2.6, You can create the report form in DOS and then in windows 2.6 call that report with REPORT FORM XXXXX TO FILE XXXX <p>David W. Grewe<br><a href=mailtoave@internationalbid.net>Dave@internationalbid.net</a><br><a href= > </a><br>