Sage 100

Has anyone ever successfully linked a PDF to a Crystal Report or Form to print? Has anyone heard of a feature in Crystal that allows you to link a file within the form/report and it would print that file with the form/report when printed?

I have never heard of this before but if you get it working, I would love to learn how.

Kellie, I've done it. It actually can work fairly well. I've only been able to do it by turning the form into an image though. Not a PDF file.

I'm not sure I understand what you mean.

If you think of your pdf file as an image file(Which it sort of is.) I've made Crystal reports that print a specific image file. That's what i mean. What is your pdf file? Is it always the same or is it unique to the customer or order or whatever it is you are printing?

We are trying to print Jobops Attachements at the same time the work tickets are printing. The attachements are AutoCad Drawings in PDF format. They would be unique to order and work ticket number.

Wow! Ok, you're bringing back some memories for me. Non-Mas90 related I created some crystal reports for a client that dynamically print autocad drawings, too. My drawings were saved as images(not pdfs) and i used a crystal addon from http://www.crystalkeen.com.

We had created a button for one of our customers that prints JOB-OPS attachments when clicking on a button in the work ticket. However it doesn't print them at the same time as the work ticket.

That might be a good solution, Dawn can you elaborate for me? Not that I didn't like your option Brett, it's a bit pricy.

No problem, it is expensive, but I did a little more poking around and with Crystal Reports XI you can do dynamic images directly with Crystal Reports. That might be worth looking into to.

Meaning, this was done through scripting. You need to add a button to a work ticket screen then script looping through the work ticket attachment file names (for the work ticket you are referencing) and then display them using the normal viewer program that windows uses.

In Crystal XI you can insert OLE Object and then do a formula at the graphic I think to create the logic to pull the right PDF.

Johnny, that sounds pretty cool. I did some quick testing and a formula works real well to dynamically set an image but I can't get it to change the OLE Object. It still displays the original pdf that I selected when setting up the report. Any ideas?