Skip to Content
0
Former Member
May 14, 2013 at 08:32 AM

Showing multiple values by comma separated

53 Views

Hi,

I want to display 3 fields of the table by comma separated in my crystal report.

For e.g. Add1,Add2,City

if any one of the of them is blank then suppress that comma.

if Add1 is blank the want to display Add2,City.

If Add2 is blank the display Add1,City &

if both Add1 & Add2 is blank then display only City.

Please help on this.

Thanks & Regards,

Deepali.