inserting a character Query item in the measures section of a crosstab !!!!!!

[Desperado]

Hi All,

Can we insert a character Query item in the measures section of a crosstab report (even in cognos 8). I know some versions of reportnet will not support .. But if there is any possibility please let me know how to do

Thanks in Advance

[COGNOiSe administrator]

I believe that was a challenge with some other post in this forum. Something about calendar of events. I am not sure if the community ever found an acceptable solution. I'd try to bring in a fake measure, unlock the crosstab, bring in the character data you need next to the measure, and change the measure display to None. ... but I have a feeling this will fail anyway.

Darek

[Desperado]

Hi Darek,

Sorry for the delayed reply to this posting . i tried doing it in that way mentioned by you. But it's not working.
is there any other way that i can use a character field in the measures section of a cross tab ?

thanks in Advance

[MDXpressor]

Generally the answer to this question is no.  A crosstab is inherintly an aggregate container, and the only aggregate you can perform against a string is a count function.  Having said that, I have seen a long and convoluted approach to this that did function under some pretty specific circumstances.  I will try and dig up the process.