how to display image on report when i stored image's path in database

sakira0006
sakira0006 used Ask the Experts™
on

Hi everybody !!

I am using Crystal Report for Eclipse 3.2 (CR4E) . I stored image's path in database (mysql), now i need to get path and display image in report . How can i do it ? , please help me , thanks very much !!!!!!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Commented:
Hi sakira0006,
> image's path in database

You can change an image from your calling application if you're using the RDC ( http://support.businessobjects.com/library/kbase/articles/c2004336.asp )

If you are using just Crystal then AFAIK you cannot change the image based on a path stored in the database.  You can store the image itself in the database and display it, but not a path to the image.
===
With Version 10 you are limited to inserting pictures (.jpg or .bmp files) or inserting/linking OLE Objects (bitmaps) from a static location.  For that reason, it is recommended that you store the actual image in a database field.  CR XI allows you to point to a location (on a web or file server, for example) for images.

====
Also try
http://support.businessobjects.com/communityCS/FilesAndUpdates/cr9_vb_rdc_loadpic.exe.asp


Cheers!

Commented:
You won't be able to do that - this feature is only supported in the newest versions of Crystal.  For older versions, the only way to handle this is to actually store the image itself (as a binary object) in the database and display it on the report that way.  The of course add a tremendous amount of size to your database and I don't know how well mySql will handle it.

frodoman

Commented:
Sorry reku - stale browser and I didn't see your post. - frodoman
Exploring SharePoint 2016

Explore SharePoint 2016, the web-based, collaborative platform that integrates with Microsoft Office to provide intranets, secure document management, and collaboration so you can develop your online and offline capabilities.

Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Crystal Reports for Eclipse is a free Eclipse plug in that allows you to create reports and embed them into your Java applications.  What version of Crystal do you have?  If it is CR10 or before then reku's link should resolve the issue.  If you have CR XI then you should be able to use the path straight from the database.

mlmcc

Commented:
Very Strange my answer was not accepted ???
Mike McCrackenSenior Consultant
Most Valuable Expert 2011
Top Expert 2013

Commented:
Question reopened

sakira0006 - PLease accept an appropriate comment as the answer.

mlmcc
Crystal Reports Page Editor

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial