Crystal Reports table data issue

Message

     I have a table that displays the address information on separate rows in the table 

TYPE       VAL                                          ID
CT          Chicago                                   1234                 
L1           123 Main Street                      1234
L2                                                          1234
CY          COOK                                       1234
ST           IL                                            1234
PC           60068                                     1234
PC           60056                                      4432
CY           Lake                                       4432
CT                                                          4432
L1           1453 87th Street                     4432
L2                                                           4432

I cannot figure out how to display the address information on the report.  If I put the TYPE and VAL fields in the Detail section I get an item for each instance whether there is data or not.

I tried this that someone suggested but I only get the first item and nothing else.

If Not IsNull ({Type.FieldName}) and ({Type.FieldName} in ["ST","CY"]) then {Type.FieldName} +":  "+{Value.FieldName} else ""

Edited by sv2284 - 29 Mar 2010 at 5:12am