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!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Single Record in data file to multiple lines in report

Status
Not open for further replies.

anilbail

Programmer
Oct 2, 2000
2
US
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]
 
See Chapter 21 - Creating Free Form Reports.
Below is an example using Employee Info.

TABLE FILE filename
HEADING
&quot;<10> title of page&quot; -*Starts title in 10th column
&quot;</2&quot; -*Skip 2 lines
&quot;EMP.ID <EMPLOYEEIDFIELD>&quot;
&quot;NAME: <FIRSTNAMEFIELD> <LASTNAMEFIELD>&quot;
&quot;ADDRESS: <ADDFIELD> <CITY> <ST> <ZIP>&quot;
BY EMPID
WHERE EMPID = &EMP -*'&EMP' allows prompt of EMPID.
END
[sig][/sig]
 
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....
 
Send me an example in Excel/Lotus - eric.searing@wcom.com
show before and after results.

Eric Searing
eric.searing@wcom.com
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top