Skip to Content
0
Former Member
Dec 12, 2011 at 11:18 AM

Combining rows where no data exists

41 Views

Hi all,

I'm fairly new to Crystal reports so forgive me if this is a silly question, but is it possible to combine two rows where data exists in one of them but is null in another. Please see below for example:

The data currently looks like this:

Employee Name || Home Telephone || Work Telephone

John Smith || 01234 xxxxxx || (null)

John Smith || (null) || 07890 xxxxxx

I am trying to achieve the result below with 1 row per person:

Employee Name || Home Telephone || Work Telephone

John Smith || 01234 xxxxxx || 07890 xxxxxx

Any help would be massively appreciated.

Edited by: BoboBarlow on Dec 12, 2011 12:19 PM