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,

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

quote:

ON TABLE HOLD FORMAT WP

Bear in mind that every line and every column will have leading spaces.

Thank you, your help was very valuable.

Greetings!