Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Exporting report to text file
Message
From
19/09/2007 16:18:19
Hilmar Zonneveld
Independent Consultant
Cochabamba, Bolivia
 
General information
Forum:
Visual FoxPro
Category:
Reports & Report designer
Miscellaneous
Thread ID:
01255515
Message ID:
01255613
Views:
30
I got tired of trying to make things fit with the ASCII clause, so I used @...say commands; later I found ?/?? to be more flexible. Eventually I ended up creating a special class for text reporting; now it supports text reports, and Excel reports.

If you are interested, a version is available as download #9991; the disadvantage is that you have to program the report specifically, instead of re-using your existing FRX files.

>Hi:
>
>I have a weird problem when exporting a report to a text file. I'd like to know if anybody else experienced this, and how it got resolved.
>
>****
>THE REPORT:
>It is laid out with a group header and a group of detail records for each header. E.g. CUSTOMER in the group header and INVOICE records in the detail.
>
>****
>THE PROBLEM:
>On SOME groups, the GROUP HEADER overlaps the first line of the details. It is like having no carriage return/line feed at the end of the group header line, resulting to the first detail line being exported into the same line as the group header.
>
>****
>HOW THE REPORT IS CALLED in code
>I do this via a command like the ff...
>
>REPORT FORM reportname.frx TO FILE export.txt ASCII NOCONSOLE
>
>I set _asciirows = 63 and _asciicols = 256
>
>
>Any information that sheds light on this problem is highly appreciated, and i thank you in advance.
>
>regards
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)
Previous
Reply
Map
View

Click here to load this message in the networking platform