Background Color via HTML codes

building reports webintelligence
1

I found this response to a question someone posted quite some time ago to showing the results of HTLM code:

  1. Remove single quotes before and End of your HTML code.
    you can Either write Prabhat
    or, =“Prabhat” in the cell’s formula bar

  2. Check “Read as HTML” in cell’s property.

  3. It will not show in Webi Java report panel or, in full client/Deski…
    it will only show in Infoview where report viewer format is HTML or, Interactive HTML and not a Adobe acrobat format…

NOTE: you will see this HTML code in PDF/EXCEL Exports too. Not its output…

I did as it says using the marquee as a test and it worked great!!! I assumed that getting the background color of a cell to be a color would be just as simple but I was wrong.

I have to assume I am not typing the string correctly since the marquee things works great.

Can you show me the syntax needed to establish a background color for a free standing cell and the syntax for getting an image to display?

Thanks for your help.

lajutown (BOB member since 2008-09-19)

2

Including an image is pretty simple

just put the following code :

450×219 13.6 KB

where you replace the url with your image url.

I’m not sure I understand your question about the backgroundcolor though… why would you want to set that through html when you have that in the properties of the textbox?

Peter

pderop (BOB member since 2010-10-27)

3

Thanks Peter.

Let me explain what I have tried so far and perhaps you can steer me in the right direction.

I no longer need to do anything with color provided I can get this image thing working.

Regarding the image issue -

I created a tag shown below:

This is an attempt to find a file on a shared network drive; this is not reaching out to the BO image folder on the server that houses BO.

Does the image need to be in the boimg folder and only that folder?

A member of my IT group tried the same thing referencing an image in the boimg folder and got the same results.

So we can’t get an image to display.

Here’s my goal: have images that are the same in shape, just different colors. Create a variable where the value of the formula points to the proper image. Something like the code shown here:

if( = Then
When = Then
When = Then
etc…
(found in a posting)

Any advice on how I can do this?

Thanks again!

lajutown (BOB member since 2008-09-19)

4

Yeah, you could try do that using html…

but I think you’re gonna have it a lot easier, using conditional formatting on this one.

Try create an alerter – set your conditions and change the format… under background, you can choose : background image and actually browse for the file… A LOT easier.

cheers,

Peter

pderop (BOB member since 2010-10-27)

5

The alerter was the easy answer. However, SAP limits you to 20 per report and I needed many more.

I solved my problem by having all of the images stored in the boimg folder on the server and then my variables returns a URL link to the proper image. It works great.

Thanks for your help and suggestions and this site in general. I learn something everytime I read the posts.

lajutown (BOB member since 2008-09-19)