Using variables to print other objects in Crystal

[Jefe999]

Hello - I'm a forum newbie - so please be gentle!

I'm trying to create a crystal reports (version 11.5.9.1076) with our Vantage (8.03.406a) ERP System. I'm trying to write a subreport which will print off attachments to our jobs through the job traveler report. I've got the query I need in order to get the full path name and file name of the file that has been attached. What'm i'm trying to do is figure out a way to insert the attached (object?) into the report file and have it the attachment print out right after the job traveler report. As additional information, in my current example, I have both JPG's and PDF files attached to a particular job record in our ERP system. When I run this report for the job, I see the specific JPG attachments; however, I do NOT see the specific PDF attachment.

When I inserted the object into the report, I defaulted it to a picture. When it tried to print the attachment, it printed a blank box. The pictures still printed out fine.

When I tried to change the object type to pdf, crystal requested me to insert a pdf file (which I did). I then when into the format graphic properties of the pdf object and tried setting the value of the filename to the variable I'm retrieving from the database (ERP) of the attachment. When I run the report in this manner; I get the default file I needed to supply to the report (in order to insert a PDF object) and not the actual files associated with the variables from the data records read. HOWEVER, this was ONLY TRUE FOR THE PDF FILE!!! The JPG file I attached to my ERP job record DID print! Go figure!

I'm thinking it may be something with our version of Crystal OR it may be just a limitation of Crystal and it's ability to interpret ADOBE files.

Has anyone else had experience with this?

 

[chelseatech]

A PDF is a document format, not an image format so it's not supported inside Crystal.

You can insert an OLE object, such as a spreadsheet, word document or maybe even PDF, so as long as the path is to the same location, you could change the contents and print that. Does that help?

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[IanWaterman]

I do not think Crystal can interpret pdf, currently only using CR10 and that is limited to RTF or HTML.

In format field go to paragraph and then open drop down window in Text Interpretation. you will be limited to what is there.

Ian

 

[chelseatech]

Inside Crystal Reports, when I go Insert/OLE object I get a list of all sorts of objects including Adobe Acrobat document, but then I do have a PDF creator installed.

Depends on what OLE objects windows supports on your machine.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm