4GL Reports to user defined files
Posted in 1992
Topics: Connectivity: ESQL/C, 4GL & Embedded SQL
>I am running INFORMIX 4GL Version 1.10.03J/2.10.03J on >and AT&T 386WGS under AT&T SYS V Release 3.2.1 >I would like to have my 4gl reports print out >to a file specified by the user. Not hard coded >like: > OUTPUT TO "file" >I want file to be whatever the user enters, within reason. >I have checked the 4GL manual I tried everything I could >think of, to no avail. Any ideas? >Thanks >Peter >(peter@miller.cs.uwm.edu) Yes, the following changes to a 4gl report will accomplish what you want. DATABASE db_name MAIN --> DEFINE rpt_name CHAR(40) --> PROMPT "Enter report name: " FOR rpt_name sql statements, etc deleted.. --> START REPORT report_name to rpt_name ^^^^^^^^^^^ remainder of report deleted.. Define the variable name, prompt for it and just add the to 'variable name' in START REPORT statement. You can even enter full path names for the variable name, ex. (/work4/acct/bsoren/testreport.out). Hope this helps. Robert ........................................................................... Robert Sorensen Internet: bsoren@mainz-emh2.army.mil (IP 26.7.0.186) Mainz Army Depot Unit 24218, P.O. Box 44 APO AE 09185-5000 Int. Phone: 011-49-6131-696438 ...........................................................................