Report issues depending on the first field

derForest · 7 July 2025 10:56

Hello,
I was facing some problems in reporting in suiteCRM8.8.
Depending on the first field used in the report, I got no result.

Eg: Report module: opportunities
Starting with “assigned to” or “Account name” deliveres no result

changed to

It is also reproducible in the demo, so it does not seem to be a problem specific to my installation.

Is this a known bug? Are there any fixes?
Thanks for any hints.

rsp · 7 July 2025 13:44

I think it is known issue.

github.com/SuiteCRM/SuiteCRM-Core

Reports - If the first reported belongs to a Module that is not the "Report Module", this can cause reports to fail on custom fields.

opened 02:00PM - 02 May 25 UTC

johnM2401

Type: Bug Priority:Important Area: Reports Severity: Major

### Issue Possibly related to: https://github.com/salesagility/SuiteCRM-Core/is…sues/613 <br> When creating a report, users are able to select related modules and their fields. However, if the user creates a report that has the first reportable field as one that is NOT the same module as the "Report Module", it falls over if any subsequent fields are custom fields. It looks as though it is trying to access the wrong module's custom table. <br> Using a report set like: ![Image](https://github.com/user-attachments/assets/a86c5afb-ebf1-4f45-ab56-2ca45704b9d5) This generates the Query: ``` SELECT `aos_quotes:accounts`.id AS 'aos_quotes:accounts_id', `aos_quotes:accounts`.name AS 'Name0', `aos_quotes`.id AS 'aos_quotes_id', `aos_quotes`.name AS 'Title1', `aos_quotes:accounts`.testdd_c AS 'testDD2' FROM `aos_quotes` LEFT JOIN accounts `aos_quotes:accounts` ON `aos_quotes`.billing_account_id=`aos_quotes:accounts`.id AND `aos_quotes:accounts`.deleted=0 WHERE aos_quotes.deleted = 0 GROUP BY `aos_quotes`.name, `aos_quotes:accounts`.id, `aos_quotes:accounts`.name, `aos_quotes`.id, `aos_quotes:accounts`.testdd_c ``` Generating the error: ``` #1054 - Unknown column 'aos_quotes:accounts.testdd_c' in 'field list' ``` ### Possible Fix _No response_ ### Steps to Reproduce the Issue ```bash 1. Create a Report 2. Set the first report field to a related module's CORE field 3. Set a subsequent report field to a custom field in the Report Module 4. Set a subsequent report field to a custom field in the related module ... ``` ### Context _No response_ ### Version 8.8.0 ### What browser are you currently using? Chrome ### Browser Version _No response_ ### Environment Information MariaDB 10.4.12 / PHP 8.3 ### Operating System and Version Ubuntu 20.04