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

Report Snapshot?

Status
Not open for further replies.

mcoupal

Technical User
Jul 9, 2001
61
US
I have a report that is created via multiple tables (with relationship links) in a data environment and a few variables. I would like to save this report to a file so I could reprint it again, just the way it looked originally.

I tried using the REPORT FORM .. TO FILE command, but it gets highly distorted when re-printing (copy using the to LPT /B method). Using the "ASCII" type REPORT FORM is useless too. I considered doing a select statement to save a snapshot of the dataset (the displayed field from the various tables), but this is unweildy. Any suggestions?
 
mcoupal,

one suggestion would be the following.

use [filename] order [indexname]
copy to [backup filename].[backup extention] for [fieldname] = [filter information]

then create the report with a file you can zap and replace the information in the file with the following.

use [filename] order [indexname] excl
zap
append from [backup filename]
report form [reportname] to printer preview

I do this on several reports to allow for multiple monthly reports.

Thanks,

jspellman
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top