Report - Filter date on related module about corebos HOT 6 CLOSED

diff --git a/modules/Reports/ReportRun.php b/modules/Reports/ReportRun.php
index ecea02e..a0c4220 100755
--- a/modules/Reports/ReportRun.php
+++ b/modules/Reports/ReportRun.php
@@ -845,7 +845,11 @@ class ReportRun extends CRMEntity {
                                                                $tableColumnSql = "CAST((CONCAT(due_date,' ',time_end)) AS DATETIME)";
                                                        }
                                                } else {
-                                                       $tableColumnSql = $selectedfields[0].".".$selectedfields[1];
+                                                       if ($moduleName==$this->primarymodule) {
+                                                               $tableColumnSql = $selectedfields[0].".".$selectedfields[1];
+                                                       } else {
+                                                               $tableColumnSql = $selectedfields[0].$moduleName.".".$selectedfields[1];
+                                                       }
                                                }
                                                $startDateTime = "'$startDateTime'";
                                                $endDateTime = "'$endDateTime'";