Solved

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

Posted on 2006-11-27
8
5,710 Views
Last Modified: 2008-01-09

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 !!!!!!
0
Comment
Question by:sakira0006
  • 2
  • 2
  • 2
8 Comments
 
LVL 5

Accepted Solution

by:
reku631 earned 500 total points
Comment Utility
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!
0
 
LVL 42

Expert Comment

by:frodoman
Comment Utility
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
0
 
LVL 42

Expert Comment

by:frodoman
Comment Utility
Sorry reku - stale browser and I didn't see your post. - frodoman
0
How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
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
0
 
LVL 5

Expert Comment

by:reku631
Comment Utility
Very Strange my answer was not accepted ???
0
 
LVL 100

Expert Comment

by:mlmcc
Comment Utility
Question reopened

sakira0006 - PLease accept an appropriate comment as the answer.

mlmcc
Crystal Reports Page Editor
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Hot fix for .Net Crystal Reports 10.2.3600.0 to fix problems with sub reports running on 64 bit operating systems ISSUE: Reports which contain subreports fail with error "Missing Parameter Value" DEPLOYMENT SERVER OS: Windows 2008 with 64 bi…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This video discusses moving either the default database or any database to a new volume.
Access reports are powerful and flexible. Learn how to create a query and then a grouped report using the wizard. Modify the report design after the wizard is done to make it look better. There will be another video to explain how to put the final p…

728 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now