CiviCRM Community Forums (archive)

I am working on modifying a report that I have been crafting based on the Activity Summary Report. The final addition I need for this report is the Case Status and Case Type fields and filters.

Looking at the Case Details template I see the following are included.

require_once 'CRM/Case/BAO/Case.php';
require_once 'CRM/Case/PseudoConstant.php';
With those included I can grab details of the cases by building the civicrm_case array in the __construct (). I added a line to the from statements so as to match the Details.php file but then I get a host of errors when I run the report. I printed the sql the report prints out and the following field is selected. case_civireport.id as civicrm_case_id, where does civireport come from? I cannot find in the code where civireport is called.

I have posted on http://pastebin.com/KTXMcuws pastebin the full php. Am I going about this the correct way or is their an easier method.

Thank you,

Max