Conditionally Suppress Row in Cross-Tab 2

[gbobbie]

CR9/Access DB

I created a crosstab that looks as follows:

           Appointment     Phone Call     Fax    Mail
Person1     5               6              8      10
Person2     6               4              10     9 
Person3     8               11             4      6
"Blank"     1               0              0      0

The database is used by people who log the amount of contacts they receive. Due to human error, occassionally they leave the name field blank. I don't want to include the row with the null person name. Can I suppress this row in a cross-tab?

Any assistance whatsoever is GREATLY appreciated!!!

 

[lbass]

First create a formula like {@person}:

if isnull({table.person}) then
"" else
{table.person}

Then use this formula as your row field. Then select the inner cell->format field->common->suppress->x+2 and enter:

gridrowcolumnvalue("@person") = ""

Then go to the customize style tab of the crosstab and check "suppress empty rows".

-LB

 

[IdoMillet]

Another approach is to simply remove those records from your report by using a record selection formula:
NOT IsNull({table.person})

- Ido



view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com