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