[Solved] Linking catalogue images to a catalogue report - Help

[elphin]

Being new to the world COGNOS.. forgive me if this is a simple request or the answer is buried somewhere here on this site (I did check before posting!)

I am trying to create a simple catalogue report (list report) where by a picture of each product appears on the same line as the description and other information of the item.

Does anyone know how to do this?

I have created the report but how do you create a query to link the JPG file to the actual asset. (assume the jpg file name is the same as the procurement code of that item).

Any help would be greatly appreciated.

[sir_jeroen]

Take a look at the Go Sales & Retailers package that's provided in the crn/webcontent/samples directory. See the help function of ReportNet on how to install (deploy)

[elphin]

Yep all sorted thanks...for others who need to know...

1. Under tool box drag the image icon into the report
2. In the Properties of the image select Data Item / Expression field.
3. Select the ellipsis '...'
4. Type the location of the images in the expression definition field
5.Insert the database field from the available components
6. Type in the file extention

For example:

'http://full_computer_name/crn/samples/images/'+[FIM].[C_FFE].[CELL_NAME]+'.jpg'


should be good to go..
cheers

[sir_jeroen]

Nice tutorial.. Tnx... it's gonna be helpfull to a lot of people!