Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Downloads
Search: 

CM FrxExport - export FRX reports in other formats
Nikolay Petkov, Compumotor
CM FrxExport is a FoxPro utility to export FRX reports in other formats: XLS, DOC, HTML, TXT and others. You can further manipulate data from output file as a table. Works quickly. First plane file is created (works in VFP, FoxPro 2.6). Next this file optionally is enhanced in VFP with Excel/Word automation. This version 2.0 is with many enhancements and new features: added support for summary band exportation and formatting, improved rounding, new type of export is introduced – simple HTML (compact HTML code, no need of external application and automation) and more.
Created on
21 years ago
Downloads
4136
File type
Rating
4.00/5.00
General information
Rating:
4.00/5.00 (1 rate) Rate this item
Description
It is well known that REPORT command has little possibilities to save output in a file: REPORT FORM ReportName TO FILE FileName ASCII where ASCII clause can be used in VFP only. Our wishes are to mimic clauses like XLS, DOC, RTF, HTML. There are some utilities that with the help of MS Word or other automation produce output to file in other formats. Generally their target is to generate exact representation of the report output, as in previewing or printing the report. Because of this in output file are placed many frames with text, instead of table, as in original report. In some circumstances this approach is suitable, in some – not. Also this approach works very slowly – in some cases it is impossible to wait so many time. One example when mentioned approach is not applicable is if we want to generate XLS or DOC file with report results, which contains data in table, and it is possible to manipulate the data afterwards (edit, or perform some more calculations for example). CM FrxExport utility attempts to solve above problems and to generate output file in reasonable time. It consists from two parts: · Function RepExpFl – generates plane output in Excel or other file (see help for COPY TO command for all possible formats and limitatons). This program works in nearly all (!) FoxPro versions (VFP, FoxPro 2.6 for DOS, FoxPro 2.6 for Windows), and don’t need external programs to be installed, as Excel or Word. From version 2.0 simple and direct HTML export is added; · Function RepEnhance – enhances generated plane file with automation. This program works in VFP only. Depending to the desired output format different automation is used (Excel 97, Word 2000). Limitations · If data environment is stored in the FRX file – it is not restored in CM FrxExport engine. That means that you have to open all needed tables in advance. · Pictures are not exported. · We adopt that data in detail and group bands looks like a table. · Examples are in VFP only, but RepExpFl can be used in FoxPro 2.6 DOS/Windows. Compiled program in FoxPro 2.6 is also included (sub-folder FoxPro26). History Function RepExpFl is written in 1995/1996. Some enhancements are made in next years. Function RepEnhance is written in 2002. Version 1.00 (15 October 2002) Version 1.01 (3 November 2002) – added NULL support for values in the table. Version 1.02 (25 June 2003) – improvements and bugs removal. Version 2.0 (10 June 2004) · many formatting improvements (especially for rounding) · added support for summary band exportation and formatting · tested with VFP 9 (but no support for multi detail bands yet) · simple HTML export is added – quick, without complex formatting codes and works without need of other programs like Excel or Word
Created by
Nikolay Petkov, Compumotor
Working with all FoxPro versions from 1993. Software for office automation, store management and accounting systems, optimization of analytical and mathematics data, design in electrical machines area.

Comments
This one was faster then the ones using word automation. It is my choice without using printer drivers right now. However it suffers from an inability to support some report formating options, like headers, and such. Once these issues get resolved this will be a great program to use. Mike Privott, November 8, 2002

Add a comment
More downloads created from this member
Nikolay Petkov, Compumotor
Checks and repairs DBF tables. This is APP for FP 2.6 Dos/Win. It was prepared because of interest from those downloaded same utility for VFP 6.
Created on
24 years ago
Downloads
1463
File type
Rating
5.00/5.00
Nikolay Petkov, Compumotor
Compare utility for FoxPro tables - structures and indexes. How to compare two tables for structure or index differences? Not so easy, but you can - DISPLAY STRUCTURE and so on. For two tables - OK. But if you want to compare two FOLDERS table by table for structure or index differences - generally ...
Created on
25 years ago
Downloads
2376
File type
Rating
5.00/5.00
Nikolay Petkov, Compumotor
A bug fix release: Extensivelly tested with Visual Foxpro 6, 7, 8, 9 - proper usage of respective commands. Siutable implementation in Windows 7 environment. . This is checking, repairing, comparing and exporting utility for Visual Foxpro, Foxpro and other dbf-type tables.
Created on
25 years ago
Downloads
13146
File type
Shareware
Rating
5.00/5.00