CODEWITHSUNDEEP
crystal-reportscrystal-reports-2008crosstab
Tassadaque
Tassadaque

Reputation: 8199

supress zero rows in crosstab crystal reports

I have crosstab looks like this

          Jan           Feb
Emp1      500           600
Emp2      600           700
Emp3       0             0

I want to hide the row3 as it has zero values. I have seen in crosstab expret to supress empty rows but that doesn't server the purpose. I want output like this

          Jan           Feb
Emp1      500           600
Emp2      600           700

Upvotes: 0

Views: 2260

Answers (1)

craig
craig

Reputation: 26262

Create a SQL Expression that returns a NULL:

-- {@DB_NULL}
-- Oracle syntax
(
SELECT NULL FROM DUAL
)

-- {@DB_NULL}
-- MS SQL syntax
(
SELECT NULL
)

Create a formula field to convert 0 to NULL:

-- {@data}
If {table.field}=0 Then
  {@DB_NULL}
Else
  {table.field}

Reference this field in your cross-tab instead of {table.field}. You may have to reset the 'suppress empty rows' setting.

Upvotes: 1

Related Questions