Problem with First Names and Reports

**mergulhao83** · 2007-03-02, 08:24 PM

I have some reports here. One of them shows Contacs with some rules. There is a bug in Reports that makes the name of a Contact be not showed in Report(any of them: pdf, html) if this contact don't have an First Name. Others informations about the contact are showed ok. So I think its a problem in concatenation of the first and last name.

I searched in the code but there are hundreds of locations that makes this concatenation... A violation of the DRY concept, but its other discussion.

Anyone know how to solve this?

Thanks.

**mergulhao83** · 2007-03-05, 04:59 PM

No answers again? Have I only difficult questions?

**malcolmh** · 2007-03-06, 04:56 PM

Hi,

I was able to reproduce your error in 4.5.0h. Which version were you using?

Have you registered a support case? If not I would recommend doing so.

A workaround to your problem is selecting first & last name separately.

Hope this helps

**davidcosine** · 2007-03-06, 10:24 PM

Dear Sugar User;

This issue is should not occur if you upgrade your version to 4.5.1 or later.

Thanks;
David Kosy

**mergulhao83** · 2007-03-08, 08:12 PM

I'm using 4.5.1 version Pro. I've found the solution by myself.

Edit the file /include/generic/SugarWidgets/SugarWidgetFieldname.php

Look around line 100... You will found this:

Code:

                                $alias .= "CONCAT(CONCAT("
                                        .$table_alias."."
                                        .$field_def['fields'][0].",' '),"
                                        .$table_alias."."
                                        .$field_def['fields'][1].")";

Exchange by:

Code:

                                $alias .= "CONCAT_WS(' ',"
                                        .$table_alias."."
                                        .$field_def['fields'][0].","
                                        .$table_alias."."
                                        .$field_def['fields'][1].")";

Test it.

**susiewilliams** · 2007-03-08, 08:21 PM

Hi mergulhao83,

Thank you for sleuthing out the answer! Great detective work. You can contribute your fix to the Open Source community by following the instructions on this website.

Regards,

-Susie