+- CoreBOSBB (https://discussions.corebos.org)
+-- Forum: Development (https://discussions.corebos.org/forumdisplay.php?fid=18)
+--- Forum: coreBOS Development (https://discussions.corebos.org/forumdisplay.php?fid=4)
+--- Thread: Having trouble with a report (/showthread.php?tid=463)
Having trouble with a report - Guido1982 - 10-15-2016
Having trouble with a report I want to use, that lists all timecontrol records from a certain report. The error is:
" Unknown column 'vtiger_projectRelProjectTask637.projectname' in 'where clause' "
Anybody have some tips on where to look in the code?
RE: Having trouble with a report - joebordes - 10-17-2016
The first thing you can do is set the global variable DEBUG_ReportQuery to 1 and analyze the SQL.
I suppose the problem will be in the GenerateReport() methods in Projects if they exist.
I created a report with some TC columns and Project Name, it worked correctly. Can you reproduce the problem in the online demo? Can you give me some more information on how to reproduce it?