Print Page - add a "smiley column" in a crosstab

Title: add a "smiley column" in a crosstab
Post by: philelmousse on 18 Jun 2011 06:01:04 AM

Hello,

I have a crosstab and I would like to add a column with smilies. But I dont want a smiley for each row.

My crosstab is like that :
Column1 Column2 Column3 Smiley
level1 level2
level2
level2

I want a smiley based on group level1 and not at every level2. You follow me ? How is it possible ?

Thanks and regards

Title: Re: add a "smiley column" in a crosstab
Post by: Deep on 19 Jun 2011 09:56:51 PM

Hi,

Try to add Data Item in the query with Image URL.
Check for level 1 if yes then Image URL
else
null

Thanks

Title: Re: add a "smiley column" in a crosstab
Post by: philelmousse on 20 Jun 2011 06:11:43 AM

I resolved the problem but now i would like to remove the border of the smiley. I try to change the box type but thats not working

(http://img11.hostingpics.net/pics/580676smileyborder.jpg) (http://www.hostingpics.net/viewer.php?id=580676smileyborder.jpg)

Title: Re: add a "smiley column" in a crosstab
Post by: philelmousse on 21 Jun 2011 09:49:59 AM

please tell me if its not possible or how to do. Thanks a lot.

Title: Re: add a "smiley column" in a crosstab
Post by: jd on 22 Jun 2011 01:27:38 PM

Open up that image in paint and remove the boders then save and upload that image to the where u have your images. Then go to the report and get teh Image URL..

COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: philelmousse on 18 Jun 2011 06:01:04 AM