Focal Point
[SOLVED] Report Painter and images in column

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5587022036

April 17, 2013, 09:51 AM
cs_source
[SOLVED] Report Painter and images in column
Hello,

i am developing a report in report painter and i have 2 questions:

i have a column in a report which is an indicator column and i would like to pull an image based on the value of a different column.

Here is the source code for the issue below:

Question 1 - when i reference the column to check the indicator against and the alternating color code for that column it works when i am in the source view and test. as soon as i save and click on the report view the last two lines go disappear and i the report doesn't work as excepted.

TYPE=DATA,
COLUMN=N6,
IMAGE=C:\Users\xxx\Pictures\IndicatorYELLOW.jpg,
SIZE=(0.250000 0.250000),
-> WHEN=N7 EQ '1',
-> BACKCOLOR=( 'WHITE' RGB(210 255 255) ),

Question 2 - i have my indicator images stored in C:\ibi\apps\images folder, in the code when i reference that folder (so the images are stored in the apps directory) i get the (X) on the image, i'm assuming i didn't use the correct language for the path?

TYPE=DATA,
COLUMN=N6,
IMAGE=C:\ibi\apps\images\IndicatorYELLOW.jpg,
SIZE=(0.250000 0.250000),
WHEN=N7 EQ '1',
BACKCOLOR=( 'WHITE' RGB(210 255 255) ),

Any thoughts?

This message has been edited. Last edited by: <Kathryn Henning>,


WebFocus 8.02, SQL Server 2008r2
April 17, 2013, 10:56 AM
Rao D
The images should be available to the Webserver(client server). So, you need to make sure those images are in the app directory on the client server.


WebFOCUS - ver8201
[ReportingServers: Windows 64bit;
Client: tomcat and IIS on windows 2012
AppStudio

April 17, 2013, 10:59 AM
cs_source
quote:
TYPE=DATA,
COLUMN=N6,
IMAGE=C:\Users\xxx\Pictures\IndicatorYELLOW.jpg,
SIZE=(0.250000 0.250000),
-> WHEN=N7 EQ '1',
-> BACKCOLOR=( 'WHITE' RGB(210 255 255) ),

I have seemed to have resolved my own issue, i have moved the fex file to the content folder and now all code is saved as well i moved the images to the content folder and the path was set as it shown in properties and were good for anyone with similar issues.


WebFocus 8.02, SQL Server 2008r2