I had a question about blank records in a dataset (in this case an Excel Spreadsheet).

 

I have an excel spreadsheet with a good number of columns (about 22). There are a lot more but I want to have the report only show on the 22 columns. In anycase, what i want to do is build something that I can place into a Crystal Report that will show all the non-valued (ie: blank) records of a particular column.

 

Example:

 

A    B         C        D        E

5  Joe     Smith    NY    11548

6  Matt   Smith            11208

7  John   Foigis   NJ    

 

and so on and so forth.....

 

I want the report to state the following:

 

 

Matt Smith

 

D

 

in other words.....

 

 

<Name of Person (in the real case it will be a business name)>

<field that is blank>

 

 

Is there someway to do this in CR?

 

Thanks.

 

 

--Matt