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 SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How do I make a text file from a report?

Status
Not open for further replies.

Guest_imported

New member
Jan 1, 1970
0
0
0
Hi:

I'm trying to create a text file from the report. If possible, how can I do it?
 
From the help:
REPORT FORM FileName1 | ? [ENVIRONMENT] [Scope] [FOR lExpression1]
[WHILE lExpression2] [HEADING cHeadingText] [NOCONSOLE]
[NOOPTIMIZE] [RANGE nStartPage [, nEndPage]]
[PREVIEW [[IN] WINDOW WindowName | IN SCREEN] [NOWAIT]]
[TO PRINTER [PROMPT] | TO FILE FileName2 [ASCII]] [NAME ObjectName]
[SUMMARY]

Try:
Report form myReport.frx to <filename> ASCII
 
Syntax is

Report Form [ReportName] to File [TextFileName] Ascii

Please note the text file generated may not be aligned properly. So try altering the variables _asciirows & _asciicols.

Before running the report to text file type

_Asciicols=[Value between 100-150 will do]
_Asciirows=[Value between 60-100 will do]

All the best
 
Ganeshg, that's for the whole document right? Can I do that with each textbox?
 
Those settings are for the whole document. I've found that if you plan on creating a text file from a report, that you should either design it with a fixwidth font (like Courier New) or create two separate reports one designed for printing and one for text files.

Rick


 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top