[SOLVED] Export the fields in the HEADING to an ALPHA file

Hi!
I´m learning web focus 7.6.1.

I'm trying to export a report to a flat file type ALPHA.

I have 2 problems:

1 .- I place some fields in the HEADING AREA and when exporting the file type ALPHA, only export the data that is in the DETAILS AREA of the report, not those who are in the HEADING AREA. How to export the data that are in the HEADING AREA and in the DETAIL AREA?

2 .- In the fields that are in the DETAIL AREA of the report, I put at the end of the sentence, the statement "OVER ", to be displayed on the next line, but when export to an ALPHA file, the data displayed on a single line. How to export the data in a line each?

Thanks for your help!

This message has been edited. Last edited by: Kerry,

WebFocus 7.6.10, windows 7, win server 2003-2008 PDF, TXT, XML, html, xls, doc

Posts: 22 | Registered: January 06, 2011

posted

anrix,

The code below could be something you are looking for.
The format of the output is WP and this format will save the data
including all heading/footing stuff.
In this example, the file will be saved in the baseapp directory.

-Fred-

  
FILEDEF HOLD DISK BASEAPP/OUTPUT_AS_ALPHA.TXT
-RUN

TABLE FILE CAR
ON TABLE SUBHEAD
"--------------------------------------------------"
HEADING
"Country in heading = <COUNTRY "
"--------------------------------------------------"
SUM DEALER_COST AS ''
BY COUNTRY AS ''
BY MODEL AS ''
ON COUNTRY SUBHEAD
"Country in subhead = <COUNTRY "
"and some more text ....................... "
ON COUNTRY SUBFOOT
"Country in subfoot = <COUNTRY "
"--------------------------------------------------"
ON COUNTRY PAGE-BREAK
ON TABLE HOLD FORMAT WP
ON TABLE SET PAGE NOPAGE
END
-RUN

<JG>

posted