Using Different images in report based on selection

[cognos05]

Hi ,

I have a report which has 40 different prompt values and on selection of a specific prompt i should show the image related to that prompt.

What is the best way to handle this .

Actually I am using a package with a olap cube and a realtional table both combined througha  fm model .

I can store this image as an url in the realtional table  and then use it as a seperate query ?

Or downlaod and copy these 40 images to cognos server and then point it based on if else statements on the prompt value caption

This is just a logo image of the agency .

Thanks,

[JCarter]

There are a few ways you might do that.

Create a variable that uses paramvalue or paramdisplayvalue, and then create multiple images on the page, setting the Render Variable on each image so that only the right one is rendered.

or a better solution, especially if the URL is in a column in your table,

2 - Create a data item pointing to the column, and set the Source type in image properties to Report expression, providing the data item in your expression.

or

3 - Create a variable that uses some logic to determine what the URL is, then set the URL source variable on the image properties. e.g.  case when FIELD='Agency1' then 'URL HERE' else 'OTHER URL HERE' end

[cognos05]

Thanks , the second approach i used and it works fine.