SUM for (Null)-column in CrossTab

This public forum is for user-to-user discussions of PHP Report Maker. Note that this is not support forum.

SUM for (Null)-column in CrossTab

Postby strustam » Tue Jul 25, 2017 1:10 am

Hi!

There is (Null)-column in my CrossTab. SUM is not working for this column. I check COUNT, AVG, MAX. Those are calculating properly.
It seems to me, there is error in phprptfn.php at place

case "SUM":
$fld = $smrytype . "(" . $smryfld . "*" . ewr_SQLDistinctFactor($colfld, $datetype, $val, $qc, $dbid) . ")";
break;

should be

case "SUM":
$fld = $smrytype . "(" . $smryfld . "*" . ewr_SQLDistinctFactor($colfld, $datetype, $wrkval, $wrkqc, $dbid) . ")";
break;

Hope, it will help somebody
strustam
 
Posts: 10
Joined: Mon May 05, 2014 4:02 pm

Re: SUM for (Null)-column in CrossTab

Postby Webmaster » Tue Jul 25, 2017 9:41 am

Thank you for reporting. Will fix in the next build.
Webmaster
 
Posts: 10734
Joined: Fri Aug 06, 2004 5:59 pm

Re: SUM for (Null)-column in CrossTab

Postby Webmaster » Wed Jul 26, 2017 10:37 am

This is fixed in the latest version (10.0.3).
Webmaster
 
Posts: 10734
Joined: Fri Aug 06, 2004 5:59 pm


Return to General Discussion (PHP Report Maker)