×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
  • Students Click Here

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Jobs

Displaying Reports

Displaying Reports

Displaying Reports

(OP)
In a VFP 6.0 system, I create and print invoices. I would like to save the invoice print image and later be able to re-print the invoice or display it on the screen. Currently, I print the report to a file and copy the file to the printer (via DOS) to print the report. I can then display a reasonable image of the report on screen by parsing the PCL in the image file. However, this is not a very satisfactory solution. Is there a better solution?

RE: Displaying Reports

Why not save the data into table that can be used later to reprint the invoice.

RE: Displaying Reports

Saving the data in a table is not feasible because we have so many different invoice formats which change from time to time. If our invoices were the standard "description, quantity, price, total" invoice, then we could do something like that. Some of our invoice formats have twenty or thirty fields in the body of the invoice. And the format and headings change from time to time.

What we want is for our billing clerks to see on their screen the exact invoice that was sent to the customer some time ago. Our sales people drive the invoice format, so we never know what they are going to come up with next.

Parsing the PCL format works pretty well until we change to a printer with a different PCL. Then we scramble to retro-fit. If we talk about eliminating this display feature, the billing clerks threaten us with bodily harm or worse!

RE: Displaying Reports

You might explore the possibility of using Adobe's Acrobat Writer and Reader. The writer can create exact images of your report in .PDF format and follows the MS object model to allow you access through the VFP IDE. The writer is about $215. The reader is free (therefore can be easily distributed to whoever needs it). Go to the Adobe web site for more info.

RE: Displaying Reports

Going back to saving the report to a database.

Have you tried saving it in text format to it to a memo field or graphics format to a General field??

What I do here is to:
Print the report to a TIF printer and save the TIF file to a network drive and place a record in a database that contains the Drive and directory location. When needed, make a Active X call to the tif viewer.
(Basicly the same as what prangster suggested without the PDF files, but without the cost of the Adobe program and Windows has a TIF viewer.)

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close