COGNOiSe.com - The IBM Cognos Community

IBM Cognos 8 Platform => COGNOS 8 => Report Studio => Topic started by: div_1234 on 27 Sep 2011 11:30:09 AM

Title: How to display date in crosstab measure
Post by: div_1234 on 27 Sep 2011 11:30:09 AM
Hi

How to display date in cross tabe measure.my date is repeating ,instead of one  row,its showing multiple rows with date

for ex.

Date      sep/03/2009          jan/05/2004                     sep/23/2011
Date       sep/03/2009          jan/05/2004                     sep/23/2011
Date       sep/03/2009          jan/05/2004                     sep/23/2011

y it is reporting , i just want 1 row
Title: Re: How to display date in crosstab measure
Post by: Arpitagrawal9 on 27 Sep 2011 11:52:41 PM
What all data items you have added in the columns and Rows section of the report,Your data might be repeating because it might be getting shown in the intersection of all the columns and rows that is how cross tab works