Single Record in data file to multiple lines in report

anilbail · Oct 2, 2000

I have a database with many defined fields.
A single selected record's fields have to be reported one under the other. i.e different rows.
How can I achieve this by using a single TABLE FILE request?
Will mail more details if necessary.
Regards,
Anil Rao
[sig][/sig]

esearing · Oct 3, 2000

See Chapter 21 - Creating Free Form Reports.
Below is an example using Employee Info.

TABLE FILE filename
HEADING
"<10> title of page" -*Starts title in 10th column
"</2" -*Skip 2 lines
"EMP.ID <EMPLOYEEIDFIELD>"
"NAME: <FIRSTNAMEFIELD> <LASTNAMEFIELD>"
"ADDRESS: <ADDFIELD> <CITY> <ST> <ZIP>"
BY EMPID
WHERE EMPID = &EMP -*'&EMP' allows prompt of EMPID.
END
[sig][/sig]

Guest_imported · Oct 20, 2000

Did that work for you? There are many techniques to accomplish printing fields over one another. These include the OVER command, the technique already shown and redefining the master file description....

esearing · Oct 30, 2000

Send me an example in Excel/Lotus - eric.searing@wcom.com
show before and after results.

Eric Searing
eric.searing@wcom.com

Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Single Record in data file to multiple lines in report

anilbail

Programmer

esearing

IS-IT--Management

Guest_imported

New member

esearing

IS-IT--Management

Similar threads

Part and Inventory Search

Sponsor