SUGARCRM 4.5-RC - (Summation Report) Not Functional

[emillion]

When creating a summation report, the following error message appears:

> Create Summation Report
> Select Primary Address Country as Group By
> Select Output Fields
> Run Report
> Receive following error:

SQL Error : IFNULL is not a recognized function

When I modified the following code in modules\Reports\Reports.php, I got the error message which follows:

$query .= " GROUP BY IFNULL($this->group_by,'') ";

Changed to:

// Recognized SQL Server Function
$query .= " GROUP BY ISNULL($this->group_by,'') ";

SQL Error : Column 'contacts.primary_address_country' is invalid in the select list because it is not contained in either an aggregate function or the GROUP BY clause.

Is there any timeline on when this might be fixed? Has anyone else experienced this?

Thanks,

- E

OS: Windows XP Professional
SugarCRM Version: 4.5-RC
Webserver: IIS 5
PHP Version: 4.4.1
SQL: MSSQL 2005

[emillion]

This bug has been fixed, and released in the SUGARCRM 4.5.0 (1099) Build for the MSSQL installation.

Check it out!

- E