Unable to suppress a total column

[shaleen7]

I created a report using the Crystal 9 crosstab wizard.

I have the following information in the crosstab expert:
Row = the employee names in the row,
Column = Date Received (Date Range is 1/1/2000 - 1/31/2004)
Summarize = the appno which is alphanumeric (i.e. IP9000)

I want to use a formula to display just 1/2004 results.

I used the following formula:

If month ({VRPT_TABPRO.DATE}) = 1 and year({VRPT_TABPRO.DATE})= 2004 then "1/2004" else ""

I get the following:

1/2004
Paul 1000 1
John 50 0
Laura 65 10
Pam 96 17

The first row is totaling the results from 2000 - 2003 which is fine but I want to suppress that column and I can't. I tried to suppress it in the crosstab customize style section but it's still there.

Any suggestions?

 

[lbass]

In the crosstab, select the column field (your month formula) and choose "Group Options"->choose "Specified Order"->add your formula result "1/2004" and then choose the "others" tab and select "Discard All Others."

-LB