Send Report Output to a file

[Gordonk]

In Foxpro 2.6a (windows) I need to send report output into a file not just print it out. Excel 2.0 is one output option. Is there a way to output the report with formatting to word or excel or even a text file?<br><br>Thanks, GordonK

 

[dgrewe]

To export to a word document <br>report form xxx to c:\mydocuments\word\ file yyy.doc&nbsp;&nbsp;(it is a post script file but word reads it)<br><br>To export to excel<br>do not use the report form<br>use the database(s)<br>set relation(s)<br>copy to c:\mydocuments\excel\filename.xls fields xxx, xxx ,xxx type XLS (or) XL5 delimited with tabs&nbsp;&nbsp;&nbsp;<br><br>To export to a acsii file, <br>Use Foxpro 2.6 dos and create the report form<br>use Foxprow anddo <br>report form fpd to file c:\mydocuments\ascii\yyy.txt<br> <p>David W. Grewe<br><a href=mailtoave@internationalbid.net>Dave@internationalbid.net</a><br><a href= > </a><br>

 

[Gordonk]

Thanks for the information. Unfortunately, the Word option does not work - &quot;Unrecognized phrase/keyword in comand&quot;. Is there a patch or a program that I can download? Is this perhaps a feature ot newer versions?<br>Thanks for your help.<br><br>GordonK

 

[dgrewe]

It might work if I typed it right the first time<br>report form xxx to c:\mydocuments\word\ file yyy.doc&nbsp;&nbsp;<br>should be <br>report form xxx to <font color=red>file</font> c:\mydocuments\word\yyy.doc <p>David W. Grewe<br><a href=mailtoave@internationalbid.net>Dave@internationalbid.net</a><br><a href= > </a><br>

 

[Gordonk]

OK Thanks, now I can get an output file. Now perhaps you could help me to read it. Word 95 does not recognise it, nor does Wordpad. It looks like this:<br>&nbsp;E *t600R &u600D *r0F &l0O &<br>It does mention this:&nbsp;&nbsp;&nbsp;language = PCL. Any ideas?<br><br>GordonK<br>

 

[dgrewe]

Strange, My copy of 2.6 lets me do it.<br>Try <br>use the database(s)<br>set relation(s)<br>copy to c:\mydocuments\acsii\filename.txt fields xxx, xxx ,xxx type SDF<br><br>I have jury duty next week so if the thead is still active when I get back we can try something else.<br><br> <p>David W. Grewe<br><a href=mailtoave@internationalbid.net>Dave@internationalbid.net</a><br><a href= > </a><br>

 

[skelly]

This is just a shot in the dark, but I believe when you do a REPORT ... TO FILE it saves it in whatever format the default FoxPro printer is set to - David's is set to a PostScript printer, so it saves as PostScript and is therefore readable by Word - yours saves as PCL (Laserjet default?) so it saves in PCL.<br><br>I suppose you *could* set up a bogus PostScript printer... otherwise you could take his other suggestions - copy the database to an Excel or ASCII file (not the report format) using the COPY TO..., or save it as ASCII report using the REPORT FORM... TO FILE ASCII method. Good luck - SKELLY

 

[Guest_imported]

I have tried setting up a dummy Post Script printer, and using it as the default printer when trying this process.<br>I am also unable to read the reports in MS Word.<br>I need to find a way to get an electronic copy of these reports (with the graphics)... after a little research I found some mention of a program called FOXWORD that converts foxpro reports to ms word rich text format. Unfortunately all the links I Can find for this are dead.<br>Any suggestions?<br>Thanks!<br>John

 

[dgrewe]

Can not find FoxWord but Crystal Reports states it is fully MS Office compatible<br><A HREF="

http://www.hallogram.com/crstlrep/index.html"

TARGET="_new">

http://www.hallogram.com/crstlrep/index.html</A><br>

<p>David W. Grewe<br><a href=mailtoave@internationalbid.net>Dave@internationalbid.net</a><br><a href= > </a><br>

 

[skelly]

I played with FoxWord when the links were still warm (*s*) a couple years back - looked OK but not as good as I wanted at the time... it was quite a while ago. That's probably why the idea kind of died though - reports didn't translate cleanly between output and .RTF formats.<br><br>Crystal sounds like it might work for what you're doing though, also. There's also other report writers that have been around with FoxPro forever, although I've never used them - R&R Report Writer I believe, and FoxFire also. But if you can use Crystal that's probably your best bet.<br><br>skelly