Hello,

is it possible to use a text file(.txt) as report output?

thanks

i don't recall having heard about this format in webfocus...
but we can do it Unix/Oracle...why webfocus...

You mean, place the output data into a .txt file? Yes -

FILEDEF myoutput DISK [path on reporting server]/myfile.txt
-RUN
TABLE FILE [filename]
PRINT etc.
ON TABLE SAVE AS myoutput
END
-RUN

If you mean you want a formatted report into a text file then try looking at DOC or WP format output.

T

I prefer the ON TABLE HOLD AS fn FORMAT WP NOCC as being the cleanest option

Thanks it works fine...

Can you tell me whether the WebFocus supports something like templates for the output?

For example:

-----------------
xxxx|xxxxxx|xxxxx


Where the 'xxxx' is the field that will be replaced with the field from the data table.

and what is the "|" supposed to be? ";" or "," Or "tab" or.....

BTW I would suggest to look for some basic training.

"|" is a part of the template, it just separate the fields

Here is some example of the template output:


----------------
1111|2222|3333


Thanks for the suggestion, currently I am reading the WF documentation but I can read all documentation because there is not much time...

quote:

because there is not much time...

Setting a target completion date without considering the developers training requirements would appear to be a poor planning situation by management?

T

Make a field that contains the delimiter character and you can use it to format your output however you want. Pretty basic stuff.

LG, this is from old FOCUS days, but we still have a lot of reports that do this.

 OFFLINE
 FILEDEF OFFLINE DISK &&RPTPATH..yi649.out ( LRECL 160 RECFM V
...
 TABLE FILE XYZ
 PRINT F1 F2
    BY S1
    BY S2 PAGE-BREAK
 END
-*
 OFFLINE CLOSE

In our environment, this builds a text file with the need mainfram printer page breaks.

I haven't tested this, but I think what you are wanting is:
DEFINE FILE CAR
BAR/A1='|';
END
TABLE FILE CAR
PRINT
MODEL
BAR
SEATS
BAR
DEALER_COST
HEADING
"-------------------------------"
END

Try this to achieve the column heading 'look' you've shown. I'll use Alpha columns, but integer, etc. can be used, but would require experimentation to get the correct column widths.

DEFINE FILE CAR
BAR/A1='|';
END

TABLE FILE CAR
PRINT
MODEL/A4 AS '----'
BAR AS '-'
COUNTRY/A4 AS '----'
BAR AS '-'
WEIGHT/A4 AS '----'
ON TABLE ... FORMAT WP
END

Although you might find this kind of column heading more informative:
PRINT
BAR AS '=,|,-'
MODEL/A6 AS '======,Model,-----'
BAR AS '=,|,-'
etc.