Dynamic image display in WebI

[former_member212706]

Dear Experts,

     I have a requirement whereby i should display the images in each filed which changes with respect to another field in the record.

Consider i have the employee report.

My report should look like

Employee_ID	Name	Image
1001	AAAA	AAAA's Image
1002	BBBB	BBBB's image

and so on...

Is this possible in WebI?

Please guide me.

Thanks,

Rajesh.

[Former Member · Accepted solution]

There are two ways to dynamically display images.

method one (use
boimg://):

1. Create a new Web Intelligence document using eFashion universe.
2. Insert [State], [City], [Store Name] objects into the Result
   Objects and click Run Query.
3. Click Variable Editor.
4. Type Name (e.g. the picture of city) and select "Dimension" in the
   Qualification.
5. Type formula as below.

e.g. ="boimg://" + [City] + ".jpg"

6. Click Validate and click OK.
7. Insert above variable object into the report.
8. Select variable object and click Properties.
9. Select "Image URL" in the Read cell content as.
10. Place the image files (e.g. jpg file) in the following folder. (e.g. the
    image file names use the value of [City] such as Boston.jpg)

C:\Program Files\Business Objects\BusinessObjects Enterprise 12.0\images

11. Click Refresh Data.

method two (use URL):

1. Create a new Web Intelligence document using eFashion universe.
2. Insert [State], [City], [Store Name] objects into the Result
   Objects and click Run Query.
3. Click Variable Editor.
4. Type Name (e.g. the picture of city) and select "Dimension" in the
   Qualification.
5. Type formula as below.

e.g.

="http://<YourServerName>:<PortNumber>/InfoViewApp/" + [City] +

".jpg"

6. Click Validate and click OK.
7. Insert above variable object into the report.
8. Select variable object and click Properties.
9. Select "Image URL" in the Read cell content as.
10. Place the image files (e.g. jpg file) in the following folder. (e.g. the
    image file names use the value of [City] such as Boston.jpg)

e.g. C:\Program Files\Business Objects\Tomcat55\webapps\InfoViewApp

11. Click Refresh Data.

[former_member212706 · Accepted solution]

Hi Bisham,

     Thanks a lot for the quick reply.

I just tried the methodology that you have mentioned. I did not know hoe to change the properties of the variable object. Can you please guide me if formatting on the variable is a wrong way.

Also if i format the images dont appear in the table , rather it appears right at the top of the report.

FYI,I am using BO 4.0.

Please help me.

Thanks,

Rajesh.

[Former Member · Accepted solution]

Hi Rajesh,

Can you create a varible with alerter.

create an alerter,

in alterter mention images that require in conditions when that conditions is true it will display respective image. Images need to be placed in \\Images folder in server.

Apply this alerter to the column in report or if you create varible use that varible in report.

Thanks and Regards

Narayana Varma

[Former Member · Accepted solution]

Hi Rajesh,

Can you create a varible with alerter.

create an alerter,

in alterter mention images that require in conditions when that conditions is true it will display respective image. Images need to be placed in \\Images folder in server.

Apply this alerter to the column in report or if you create varible use that varible in report.

Thanks and Regards

Narayana Varma

[Former Member · Accepted solution]

Hi Rajesh,

Can you create a varible with alerter.

create an alerter,

in alterter mention images that require in conditions when that conditions is true it will display respective image. Images need to be placed in \\Images folder in server.

Apply this alerter to the column in report or if you create varible use that varible in report.

Thanks and Regards

Narayana Varma

[Former Member · Accepted solution]

Hi Bisham,

I tried your 1st method against a eFashion universe for few of the states ex: Texas, California, DC.

For other states, I get a X mark since there is no image for those values and also i have changed the cell properties to "Read as Image URL".

I could not find an alternative way to stop displaying the X mark. May be we can enter some text saying some related info.

Do you have work around for this?

Regards

Shreyas

[omacoder]

For those still following this post, I'd suggest voting up the idea to make this more user friendly

https://ideas.sap.com/D4663

[former_member817653]

Hi Rajesh,

I am looking at a similar requirement. I am interested to know if you implemented this and what sort of performance were you able to achieve? How many images were you able to link to in a report and what was the load time? Thanks!

Regards,

Mathangi K

[Former Member]

Hello,

To link to the images by filename, type the filename into the cell (for
example, <INSTALL DIR>\Images). WebIntelligence automatically adds
boimg:// before the filename. This links to the file on the
BusinessObjects server (for example: boimg://image.gif).

Using the URL and the filename to insert the image when the image files are
located on a separate web server. The entire URL and filename is entered in to
the cell (for example,
http://www.internal.businesscompany.com/images/company_logo.jpg).

The image"s size is defined when it is created. The size can not be modified
using WebIntelligence.

The image inserted must be in either Graphics Interchange Format (GIF) or
Joint Photographic Experts Group (JPEG) format.

GIF format supports 256 colors and is useful if a logo or icon is to be
inserted in to the document. It allows for background transparency so that the
underlying color of the web page can show through. This is useful when inserting
an image in a cell that contains data.

JPEG supports 16 million colors. It is best suited for photographs and
complex graphics. JPEG images are static whereas GIF images can be animated.

Image files are often located on a secured web server on a corporate network.
To insert an image in a report, link a selected area of the report to an image
file on the web server either by filename or by URL and filename.