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,
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
Thanks , the second approach i used and it works fine.