COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: philelmousse on 04 Jul 2011 04:26:34 AM

Title: data label displayed instead of value
Post by: philelmousse on 04 Jul 2011 04:26:34 AM
Hello,

In my crosstab I have a row with singletons based on one query. If I run the query I get the values but in my crosstab the data item label are displayed and not the values. Of course in the property I selected "data item value".

What could be the problem ?
Title: Re: data label displayed instead of value
Post by: RobsWalker68 on 04 Jul 2011 05:55:12 AM
Hi,

Off the top of my head check thst data item value has been set for the unlocked item i.e. the singleton itself and not the overall cell.

Kind Regards

Rob
Title: Re: data label displayed instead of value
Post by: philelmousse on 04 Jul 2011 07:08:24 AM
Thats the case, my data item is in the singleton :/
Title: Re: data label displayed instead of value
Post by: philelmousse on 05 Jul 2011 02:16:42 AM
here are some pictures to show the crosstab structure.

(http://hfr-rehost.net/http://self/pic/5fca9d9d2b60a370780199e16800c3e6d83f3388.jpeg)

(http://hfr-rehost.net/http://self/pic/889f72ae8d1e7642801f81a845083ada4f17ef3f.jpeg)

The dataitem properties :

(http://hfr-rehost.net/http://self/pic/1a4c2cd7b81e8535c5ab45c8fc91821df7dd7360.jpeg)

I really dont know what the problem is

Thanks for the help
Title: Re: data label displayed instead of value
Post by: RobsWalker68 on 05 Jul 2011 07:32:11 AM
Hi

I see the values set for the crosstab intersection but what are the values set for the singleton itself.

What are the values if you unlock the report and then click on the singleton value within the crosstab cell itself.

It may be that you have set the value for the outerwrapper (cell value) as it were but not the actual contents (the singleton).  Just a thought to check out.

Cheers

Rob