Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Convert txt file to report
Message
From
02/04/2017 02:23:49
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Environment versions
Visual FoxPro:
VFP 9 SP2
OS:
Windows 10
Database:
Visual FoxPro
Application:
Desktop
Miscellaneous
Thread ID:
01649638
Message ID:
01649651
Views:
414
Hi!

>Hmm, I understand.
>
>If your source text contains text formatting, then is problem.
>
>XFRX 17.1 will be/have engine for the case.

Using report layout for this is not ideal: fields width will vary and this causes extra spaces between fields and text.
ods format and LibreOffice automation for merge and printing can probably bet used but I want to avoid LibreOffice/Word dependency.

Solution would be to create html file from FoxPro, place fields between taga and use wkhtmltopdf to create pdf from this html.
Or maybe xfrx can embed this html to FoxPro report or print it directly.

Customer requires solution immediately: She wants that in merged document fields whose content is read from
database should appear in bold.
If xfrx has good solution I can consider buying xfrx upgrade.

For automatic report creation text file should split into paragraphs with size less that 255 characters.
Those paragraphs should intserted into frx file as label objects with proper vpos value.
Each document has 2-4 pages and every page whould placed into separate band since in Foxpro band height must be less that page height or "band to large to fit into page" error appears.


Is there some sample code fox this ?

I have created FoxPro frx report designer in javascript and frx report previewer in ASP.NET MVC but using this code for txt ->frx conversion requires lot of work.

Attachment contains sample report. I have 4 word text files, 2-4 pages each.
If there is no better solution I will convert them manually to something like in attached report.
Andrus
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform