Hide a Row when Total is ZERO & No Data Contents not Working in Crosstab

[pravin.cognos]

Dear Gurus

I have two issues in my Crosstab report.

Below is the sample crosstab.

         Ind     US   UK   Total
A        10     5      5       20
B         0      0       0       0

Issue 1: Hide a Row in Crosstab When Total is ZERO

1. We need to hide row B from a crosstab when the Total = 0. We have around 20 rows in the crosstab. We use relational data & Cognos 8.3.

Total = total(currentMeasure within detail [Ctry_Name])

When I put [Total] <> 0 in Summary filter, I got the below error.

Error: OP-ERR-0207
The data item dataItem="Total" is invalid. The 'within detail' or 'within aggregate' clause cannot be used in a list report. Not sure how to hide the rows when total = 0.

Issue 2: Do not show the crosstab when there is no data in it

2. We need to hide the crosstab in the report if there is no data for particular selection. No data contents is not working for our Crosstab. Even though there is no data, the empty crosstab with only row names is being shown in the report page. I have checked the tabular data. There is no data coming from database.

We use relational data & Cognos 8.3.

Please help !!

Thanks
Pravin

[kym888]

Hi Pravin,

For Issue 1, have you tried the Suppression function for a crosstab? You need to select the whole crosstab, then find Supression in the properties box, under the Data section. You can choose there whether to hide rows or columns or both.

For Issue 2, you could try putting the crosstab in a table/conditional block and creating a render variable like '[dataitemA] is not null' and applying the render variable to the table/block.

Kym

[pravin.cognos]

Thanks for your reply, Kim

1. I think there is no option in cognos 8.3 for Zero suppresion, so I am trying to do it manually but in vain..

2. I am cheking it now. I will update you with the result soon.

Regards
Pravin