Author Topic: Hiding empty columns in crosstab report  (Read 6251 times)

Offline hem852

  • Full Member
  • ***
  • Join Date: Apr 2008
  • Posts: 31
  • Forum Citizenship: +0/-0
Hiding empty columns in crosstab report
« on: 06 May 2009 07:17:14 am »
Hi

I have a crosstab report.

Accross the top I have a dimension of 'Legal Type' and under that a dimension named 'Game Name'. (Each Game Name fits into a Legal Type).

The 'Game Names' Dimension creates a number of columns relating to different Game Names under the individual Legal Types.

The problem is under legal types I get a column for every game name displayed, regardless of whether it fits into that legal type. The actual data values only show under the correct legal type. If the Game Name does not fit into a Legal type I get the column header but no data.

Is there a way to ensure that the Game Names only display under their appropriate Legal Types or failing that is there a way to hide Game Names with Empty columns?

TIA

John
John Daisley
Database Administrator / Cognos Administrator
Spirax Sarco Plc.
http://www.spiraxsarco.com

MySQL Certified Database Administrator (CMDBA)
MySQL Certified Developer (CMDEV)
MySQL Certified Associate (CMA)

Online CognosPaul

  • Global Moderator
  • Statesman
  • *****
  • Join Date: Jan 2009
  • Posts: 1,633
  • Forum Citizenship: +250/-1
    • Paul's Cognos Blog
Re: Hiding empty columns in crosstab report
« Reply #1 on: 06 May 2009 07:37:00 am »
Instead of pulling the level directly into the crosstab, try something like this:
Code: [Select]
filter([Cube].[Dimension].[Hierarchy].[Level],[Cube].[Measures].[Measure]>0)

Offline david.stachon

  • Community Leader
  • *****
  • Join Date: Dec 2008
  • Posts: 196
  • Forum Citizenship: +9/-0
Re: Hiding empty columns in crosstab report
« Reply #2 on: 08 May 2009 12:41:09 am »
...or better yet, if you're on 8.4 use zero suppress.

Offline hem852

  • Full Member
  • ***
  • Join Date: Apr 2008
  • Posts: 31
  • Forum Citizenship: +0/-0
Re: Hiding empty columns in crosstab report
« Reply #3 on: 11 May 2009 10:23:24 am »
Thanks Gents,

Sadly David we are still on 8.2 :(

Paul, this worked great thank you.
John Daisley
Database Administrator / Cognos Administrator
Spirax Sarco Plc.
http://www.spiraxsarco.com

MySQL Certified Database Administrator (CMDBA)
MySQL Certified Developer (CMDEV)
MySQL Certified Associate (CMA)

Offline ramya

  • Associate
  • **
  • Join Date: May 2016
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Hiding empty columns in crosstab report
« Reply #4 on: 06 May 2016 06:46:52 am »
Hi!..
   I have crosstab report.I have taken "Routes" at columns ,"vehicles" at Rows and students count who are belongs to specific vehicle and route as Summarized fields..I need not to display intersection cells having data as "0"..I want to supress that cells having value zeros..
    Thanks in Advance!....

Offline ramya

  • Associate
  • **
  • Join Date: May 2016
  • Posts: 2
  • Forum Citizenship: +0/-0
Re: Hiding empty columns in crosstab report
« Reply #5 on: 09 May 2016 05:19:42 am »
anyone plz give me reply

 


       
Twittear