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