COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: nbailey on 14 Aug 2013 02:10:29 PM

Title: Getting Extraneous rows in My crosstab report ???
Post by: nbailey on 14 Aug 2013 02:10:29 PM
I have a multi query cross tab report where I am getting 1 row and 1 collumn of all zeros that should not be on the report.  Not sure where they are coming from or how to get rid of them.  Must be something to do with the way I am aggregating ???    See Attachment
Title: Re: Getting Extraneous rows in My crosstab report ???
Post by: adam_mc on 15 Aug 2013 03:34:05 PM
Do you have a null year and a null xxCC Code (or whatever your column headings are) somehow coming into your query results?

Or, I think you can just "suppress" the additional row & column using the properties of the Crosstab.

Hope this helps.