SAP Knowledge Base Article - Public

1216897 - Can you insert a picture into a report based off a file path?

Symptom

A database field contains file paths that point to

pictures you would like to use in your report file

(RPT). The pictures are stored outside of the

database that Crystal Reports (CR) is reporting

from.

 

Can you add picture files by inserting a database

field that stores a file path to the picture rather

than the actual picture file?

 

Resolution

New Feature in Crystal Reports XI

--------------------------------

 

Dynamic Image Location:

 

In Crystal Reports XI, pictures and graphics can now be placed in a report through a link in the database so that it is no longer necessary to store images within the database. This supports the common practice of storing images on the web server and storing references to those images in the database. For more information on Dynamic Image Location in CR XI refer to the Crystal Reports Online Help by pressing the 'F1' key.

 

 

Crystal Reports 10 and Lower:

-----------------------------------

 

In the Crystal Reports designer, version 10 and lower, you cannot insert

images into a report by adding a database field

that has the file path to a picture stored in it.

To be available in Crystal Reports, the pictures

must be physically stored within the database field.

 

====================

NOTES:

 

It is possible to do this through an application

written with a development language such as Visual

Basic. This requires the Developer or

Advanced edition of Crystal Reports.

 

Sample applications that detail how to load a

picture at runtime can be found at the following

links:

 

CR 8 and CR 8.5

For more information, search our support site at

http://service.sap.com/sap/bc/bsp/spn/bobj_download/main.htm for the

following:

 

RDC Sample app in VB - Load Picture at runtime(cr8_vb_rdc_loadpic.exe)

 

CR 9

For more information, search our support site at

http://service.sap.com/sap/bc/bsp/spn/bobj_download/main.htm for the

following:

 

RDC Sample app in VB - Load Picture at runtime(cr9_vb_rdc_loadpic.exe)

====================

 

MORE INFORMATION:

 

The procedure for inserting pictures into a database

depends on the type of database you are working

with.

 

For more information, search our support site at

http://www.sdn.sap.com/irj/boc/articles for the

following:

 

Insert Images Into a Database for Use with Crystal Reports

and the following link as What’s New in Crystal Reports XI

http://help.sap.com/businessobject/product_guides/crxi/en/crXI_WhatsNew_en.pdf

 

Keywords

INSERT IMAGE OLE OBJECT PICTURE DATABASE FILE PATH Crystal Reports Image files File path in database , c2014707 , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem

Product

SAP Crystal Reports 8.0