add a "smiley column" in a crosstab

[philelmousse]

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

[Deep]

Hi,

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

Thanks

[philelmousse]

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

[philelmousse]

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

[jd]

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..