cross tab problem

[CrystalUser1]

Hi,

I have a cross tab report like the below:

dept 2001 2002 2003

finance 100 200 300
HR 99 104 250
Recruit 0 0 0

I want to take out the entire Recrit Data row dynamically because it has no data. that is zeros. how to do that? please advice.

thanks in advance.

 

[gav12345]

Hi,

You can use a formula for the 'dept' row in your crosstab, along the lines of:

if {dept_no} <> 'Recruit' then
    {dept_no}

(if you always want to suppress the 'Recruit' department).

If you only want to do this if all values are '0', you can use a formula like:

if {Year} = '2001' and {Amount} <> 0 then
    {dept_no}

Gavin