COGNOiSe.com - The IBM Cognos Community

Legacy Business Intelligence => COGNOS ReportNet => Topic started by: elphin on 16 Oct 2005 07:20:28 PM

Title: [Solved] Linking catalogue images to a catalogue report - Help
Post by: elphin on 16 Oct 2005 07:20:28 PM
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.
Title: Re: Linking catalogue images to a catalogue report - Help
Post by: sir_jeroen on 16 Oct 2005 11:50:51 PM
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)

Title: Re: Linking catalogue images to a catalogue report - Help
Post by: elphin on 17 Oct 2005 07:11:37 PM
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

Title: Re: [Solved] Linking catalogue images to a catalogue report - Help
Post by: sir_jeroen on 18 Oct 2005 01:11:18 AM
Nice tutorial.. Tnx... it's gonna be helpfull to a lot of people!