Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Output of a report to a specific file format
Message
From
11/12/1998 15:42:36
 
 
To
11/12/1998 15:10:42
General information
Forum:
Visual FoxPro
Category:
FoxPro 2.x
Miscellaneous
Thread ID:
00166289
Message ID:
00166769
Views:
13
>>>>>Hello Chuck!
>>>>>
>>>>>>The only way to do this in FPW is to make a duplicate report in DOS and when you want to print the report to ascii then run the dos report. The other option is to load the generic print driver and print to it. I know that there are other print drivers out there for like RTF and AcroBat. You might want to check into these. If you want to upgrade to VFP there is a command called REPORT FORM myReport TO FILE ASCII, which doesn't format it quite right.
>>>>>
>>>>>Alot of our customers want to have it in Excel format so that they can play around with it. I found FoxWord which will output it to RTF format. But is there something like that for Excel format?
>>>>>
>>>>>Thanks in advance!
>>>>
>>>>The only thing I can think of is to run the report to a file. then create a table and append from the file and then export the file to excel
>>>>
>>>>REPORT myDosReport TO FILE myTextFile.TXT
>>>>CREATE myTable (line C(254))
>>>>APPEND FROM myTextFile.txt
>>>>COPY TO myExcel.xls TYPE XLS
>>>>
>>>>There might be a better way I don't know of. There is always more than one way to do skin a Fox.
>>>
>>>The first line would work only if you have selected a text printer driver for output. Otherwise it will print a file with embedded printer commands, depending on the currently selected printer.
>>>
>>>Assuming that your output to text file is ready, the rest of the lines will put everything into a single column in excel.
>>>
>>>See my previous reply to this thread if you care to.
>>
>>In my previous threads I told him in FPW for windows to get the report to ASCII you need to have a report in Foxpro for Dos before you do this. If he wanted to get multi colums he could open up the report and make the columns from the detail band.
>
>Not necessarily. You can have a text printer driver selected under FPW. I'm sure one can be found at some shareware download site.

Right and that is what I said here "The other option is to load the generic print driver and print to it. I know that there are other print drivers out there for like RTF and AcroBat. " in the first message I posted to him.
Charles

"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers
Previous
Reply
Map
View

Click here to load this message in the networking platform