Wednesday, October 27, 2010 5:34 AM
A report generated thru visual foxpro .frx is to the exported to Excel 2003 for further formatting and integration with other existing Excel file. kindly help
Or if the output is atleast generated as a plain txt file (as in the case of DOS FPD26), I can open the same in Excel and use further.
The report is generated after considerable process and hence suggestion to open the dbf itself in excel to accomplish the requirement is not expected.
Wednesday, October 27, 2010 8:19 AMModerator
Check the following link, it will give you necessary info: http://fox.wikis.com/wc.dll?Wiki~FRX2XLS
Demo is available.
Wednesday, October 27, 2010 1:00 PM
Good day Tamarapu,
Try this one if you have report to be generated just make also a database for the corresponding reports and export that on excel file. See example below:
set defa to c:\networks
copy to c:\networks\excelfile\nettlsp.xls type xl5
The example above to give you an idea to export the database to excel file and this will be connected at report .frx file by means of dragging all the fields on Report Generator, from Data Environment by adding the database.
Thanks and Regards,
I accidentally click the proposed answer, moderator please delete my message...apology for the clicking propose as answer...
- Proposed As Answer by radical93 Wednesday, October 27, 2010 1:00 PM
- Edited by radical93 Wednesday, October 27, 2010 1:39 PM Apology...
- Marked As Answer by Chao Kuo Wednesday, November 03, 2010 10:50 AM
- Unmarked As Answer by Chao Kuo Wednesday, November 03, 2010 10:50 AM
- Unproposed As Answer by Chao Kuo Wednesday, November 03, 2010 10:51 AM
Wednesday, October 27, 2010 1:06 PM
As the poster already said: Opening (or copying) the original DBF to Excel is not what he needs. He wants the XLS including all the grouping, aggregation etc he already did in the report. Thus your self-proposed (!) answer isn't really the answer, therfor please reset that assignment. Normally the poster itself decides what the most helpful answer is, and he will set that flag.
(¸.·´. (¸.·` *
.·`.Visual FoxPro: It's magic !
Friday, October 29, 2010 10:58 AM
I think the service/utility is not free.
Can I redirect the REPO FORM ... to a TXT file as in the case of DOS FOX.
Friday, October 29, 2010 11:27 AMModerator
Yes, you may export the report output to ASCII file:
REPORT FORM YourReport TO FILE SomeFile ASCII
- Marked As Answer by Chao Kuo Wednesday, November 03, 2010 10:52 AM
Friday, November 19, 2010 11:46 AM
thanq very much. TXT file generated which I could open in Excel.
Friday, February 25, 2011 8:32 AM
When the report form width is considerable (land scape 8.50 width), many fields appear truncated in TXT file, though the report is shown without any trucation in visual foxpro report form preview (REPO FROM rpt1 PREVIEW). Hence I am not able to open the output in Excel without truncation of data in various fields caputred thru FRX.
If I can give lot of space between the fields in the REPORT FROM (FRX), then they are appearing fully in the TXT file. But how to incerase the width of the FRX to any extent. Or is there any way to generate the TXT file as shown the PREVIEW without trucation.
The command I used is
REPO FORM rpt1 TO FILE file1 ASCII .. which generated a hightly trucated (every field is trucated, not end of line trucation) output TXT file. No trucation is report preview.