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?
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.
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.
This page was generated in 0.031 seconds.