COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: ankit.agg.2008 on 23 Jul 2013 09:32:19 AM

Title: Issue with Crosstab - in Report Studio
Post by: ankit.agg.2008 on 23 Jul 2013 09:32:19 AM
•   Suppose in a Cross tab, in rows we have 7-8 items, in columns we had year and in measure we had amount.
•   We need to show the output with column name (like List report). So we use crosstab space to enter the column name for each column.
•   Post this we are having an extra row below the year measure in columns. Below is the screen shot for the same.
•   This is quiet urgent. Please share the solution if anyone has face the same issue.
Title: Re: Issue with Crosstab - in Report Studio
Post by: Lynn on 23 Jul 2013 09:46:45 AM
You could try THIS (http://www.cognoise.com/index.php/topic,11363.msg37230.html#msg37230) technique that PaulM posted. An oldie but a goodie.
Title: Re: Issue with Crosstab - in Report Studio
Post by: ankit.agg.2008 on 25 Jul 2013 02:53:43 AM
Thanks, Lynn and Paul. It works.