[sqr-users] PDF Files created by SQR

["Penny J. Heeren" <PHeeren@newtonmfg.com>]

We are creating several PDF files from various SQR programs with the
following code section:

  declare-report report7          ! Image file report .pdf format
    printer-type=pd
    layout=layout7
  end-declare

This file is then picked up by another process, and emailed to a
recipient. Occasionally, the file received by the user is unable to be
opened by Adobe Reader, with an error "Unable to open file, file has
been corrupted". If we rerun the SQR program to generate the file again,
the emailed file works this time. Since my manager has handled this in
the past and not gotten me involved, I haven't had a chance to look at
the file before it gets rewritten to see if it's corrupted on our server
before it goes out in the email or if it's corrupted by the email/by
sending the email/by receiving the email. I've made sure he knows that I
want to see the file before it's replaced the next time this happens, as
it's entirely possible this isn't an SQR issue, but an email issue...
however, he wanted me to ask for feedback from the user group in case
someone else has encountered this.

Additionally, if the recipient has a Yahoo mail account, that software
treats the attached file as part of the body and displays the binary
data in the body of the file. I'm 99.9% certain that has nothing to do
with SQR nor the content of the file, but the way the file is attached.
It's been a problem for some other email programs, but, for example,
works fine consistently on Hotmail. The program that actually identifies
that there is a file to be emailed and generates the email is a custom
application built by a coworker using ASP running on Windows 2000, and
interfaces with Microsoft Exchange to create the email from data stored
in a flat text file that contains sender, recipient, subject, body, and
if there is an attachment, the file path for the attachment file.

SQR version is 8.0, running on RedHat Advanced Server Linux box.

Has anyone else had issues like this or any ideas of a better way to do
this? 

Penny Heeren
DBA/Programmer Analyst
Newton Manufacturing Co
e-mail: pheeren@newtonmfg.com
phone: 641-791-4242

_______________________________________________
sqr-users mailing list
sqr-users@sqrug.org
http://www.sqrug.org/mailman/listinfo/sqr-users