COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: Nagendar on 16 Mar 2017 07:29:00 AM

Title: Help needed in Crosstab layout preparation
Post by: Nagendar on 16 Mar 2017 07:29:00 AM
Hi Team,

I am trying to create a Crosstab report which looks like a List. Its existing report only. Now trying to add new columns beside to country names.
Plz find the image to get the actual issue.


Thanks.
Nagendar
Title: Re: Help needed in Crosstab layout preparation
Post by: New_Guy on 16 Mar 2017 08:09:40 AM
Hi,
What is the desired output format? and just an info, you can build list reports using dimensional data with tuples.
If you hide the row nodes in crosstab by box type none, the cross tab will get disturbed for sure and there is no work around for it. If the output is not excel, you can select the text and do the box type none and make the padding to zero on right and left side.

Option 2 is to build a list report and use tuple like tuple([Netherlands], [Measure]) for each country column.

Let us know if you still need help.

Good luck
New Guy
Title: Re: Help needed in Crosstab layout preparation
Post by: Nagendar on 16 Mar 2017 08:39:02 AM
Quote from: New_Guy on 16 Mar 2017 08:09:40 AM
Hi,
What is the desired output format? and just an info, you can build list reports using dimensional data with tuples.
If you hide the row nodes in crosstab by box type none, the cross tab will get disturbed for sure and there is no work around for it. If the output is not excel, you can select the text and do the box type none and make the padding to zero on right and left side.

Option 2 is to build a list report and use tuple like tuple([Netherlands], [Measure]) for each country column.

Let us know if you still need help.

Good luck
New Guy


Hi, 
Thanks for your reply. Its Existing report (Crosstab). Few more columns are needed in that report which are coming from new table. We joined it and trying to add those by inserting crosstab space beside that country--United States..

we want exact output should be like Image 4 in the image which I attached.

Thanks.....
Title: Re: Help needed in Crosstab layout preparation
Post by: Nagendar on 18 Mar 2017 06:39:52 AM
Quote from: Nagendar on 16 Mar 2017 08:39:02 AM
Hi, 
Thanks for your reply. Its Existing report (Crosstab). Few more columns are needed in that report which are coming from new table. We joined it and trying to add those by inserting crosstab space beside that country--United States..

we want exact output should be like Image 4 in the image which I attached.


I have tried but I dont want those yellow columns to be in crosstab rows.
Thanks.....