AnsweredAssumed Answered

Issues creating reports with custom modules using Alineasol Reports

Question asked by Ryan Ryan on Nov 7, 2014
Latest reply on Mar 13, 2015 by alineasol alineasol
I am using AlineasolReports V 4.0.4 for creating reports. I am having difficulty getting the reports to show data from a 3rd table. If i select data from two tables I have no problems but when I try to obtain data from a 3rd table I get a blank screen. I am using a custom module. Would this be causing my issue?

This is the error I have

Fri Nov  7 02:27:39 2014 [28486][1][FATAL]  Query Failed:SELECT DISTINCT users0.first_name AS 'group'  FROM inno_activitymod LEFT JOIN users users0 ON inno_activitymod.created_by=users0.id  LEFT JOIN accounts accounts12 ON inno_activitymod_cstm.account_id1_c=accounts12.id  LEFT JOIN inno_activitymod_cstm ON inno_activitymod.id=inno_activitymod_cstm.id_c  WHERE inno_activitymod.deleted = 0 AND ( (DATE(DATE_ADD(inno_activitymod.date_modified, INTERVAL 0 SECOND))) BETWEEN '2014-11-06' AND '2014-11-07'  )::: MySQL error 1054: Unknown column 'inno_activitymod_cstm.account_id1_c' in 'on clause'

Outcomes