Pictures on a Crystal Report

[labninja]

I would like to add a picture on a report and then change it dynamically via code (VB6). What I mean is, imagine you have a database containing people, as well as a filename to a picture of each. Then you want to print a report with a picture on, which should change depending on the person. Anybody with some ideas?

 

[johnk]

I have the very same question as labninja. In my case I am printing instructions for a manufacturing shop using 8.5. I want to add an illustration to each page. The illustrations can be stored in any format but must be dynamicallly selected at run time to match a specific part.

Does Crystal Reports have such a capability?
John Kisner

 

[chelseatech]

The best way is to store the images in a DB table. An OLE field works fine.

Do a report off the Employee table in the Xtreme sample DB that is included with the CR install to see an example. Editor and Publisher of Crystal Clear

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

 

[johnk]

I received this information from Ken Hamady, an educator specializing in crystal Reports.

http://support.crystaldecisions.com/library/kbase/articles/c2004336.asp

contains a paper on this subject. I haven't tried it yet, but looks like a good solution.
John Kisner

 

[labninja]

Thank you for your responses. I actually found a VB 6, Crystal 8.5 sample application, which does exactly what I wanted! Let me know, if you want me to forward it to you. Take it easy!

 

[kenhamady]

For others of you looking at this same issue, you have to use the RDC to integrate your report, and you have to make the RPT into a DSR object in the project. That is the only way to get access to the section event that allows the object path to change on the fly. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com

 

[labninja]

Hi Kenhamady - sounds like you know what you are talking about, 'cause that was exactly what solved it for me! You don't perhaps know how to fix the exporting of these documents to either Word or PDF - the pictures all shows as the first picture, although it previews fine withing Crystal. Thanks

 

[kenhamady]

Never tried that, but if you find the solution, post it here. Ken Hamady, On-site Custom Crystal Reports Training & Consulting
Public classes and individual training.
Expert's Guide to Formulas / Guide to Crystal in VB

http://www.kenhamady.com/

- tek@kenhamady.com