CiviCRM Community Forums (archive)

Hi

I have created a custom data set and attached into activity type for CiviCase.

I have modified the exsiting report which is Case Detail Report by adding

    protected $_customGroupExtends = array( 'Activity' );

So the Report Criteria shows the set of custom fields that I created but when I try to preview the report. The DB error occurs.  The error occurs around line 498 which is

     $this->buildRows ( $sql, $rows );

Then I print the SQL to see if there and problem in SQL so I can see they is a problem of SQL in the highlight below

SELECT SQL_CALC_FOUND_ROWS case_civireport.id AS civicrm_case_id, case_civireport.subject AS civicrm_case_subject, contact_civireport.sort_name AS civicrm_contact_client_sort_name, contact_civireport.id AS civicrm_contact_id
FROM civicrm_case case_civireport
LEFT JOIN civicrm_case_contact civireport_case_contact ON civireport_case_contact.case_id = case_civireport.id
LEFT JOIN civicrm_contact contact_civireport ON contact_civireport.id = civireport_case_contact.contact_id
LEFT JOIN civicrm_address address_civireport ON contact_civireport.id = address_civireport.contact_id
AND address_civireport.is_primary =1
LEFT JOIN civicrm_value_initial_assessment_6 value_initial_assessment_6_civireport ON value_initial_assessment_6_civireport.[b][color=red]entity_id = .id[/color][/b]
WHERE ( 1 )
GROUP BY case_civireport.id
ORDER BY case_civireport.start_date DESC
LIMIT 0 , 50
Can anyone help me where do I have to add or changed in the code in order to make it works.

Thank you

Erawat