Joined: 27 Dec 2007
Location: United States
Online Status: Offline
Posts: 2
Topic: Adding PDF files to Report Posted: 27 Dec 2007 at 6:38am
I created a report which is sucessfully pulling data from my database. In addition, I would like the report to include a "pdf" file which is stored on the server. Is it possible to have the the name of the pdf file stored in the database so that when the report is run it will insert a different pdf depending on what name is in that database field?
Joined: 14 Nov 2007
Online Status: Offline
Posts: 377
Posted: 27 Dec 2007 at 6:50am
Well, I know that you can add an OLE object to a report. Which may be an option. I've never done it, but it seems like it should be possible.
Another option, depending on how you are set up, is to simply set a hyperlink to the PDF files, so that they open in a separate window. This may not be as pretty, is obviously not effective for printed reports, may be an issue if you have end users who are trying to read reports while disconnected from the network (e.g., on a Blackberry), and may run into security issues on your network. But, if those aren't issues, hyperlinking is a much cleaner solution to the issue.
Joined: 27 Dec 2007
Location: United States
Online Status: Offline
Posts: 2
Posted: 27 Dec 2007 at 6:55am
I definitely need to print the reports. Ideally I want to run the report for 1,000+ clients at a time. The report would then print a cover letter which pulls client specific names from the database and then attach a pdf file which is specific to that client. I can store the name of the pdf file in the database and I would then need the crystal report to print the cover letter and then print that specific pdf file. It would then move on to the next client and repeat the process.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
