CiviCRM Community Forums (archive)

We have some custom reports (very barebones wrappers around straight sql statements with no user interface) that worked in a previous deployment, but are not working under v4.2.  Before I dive into debugging and a possible patch, can anyone tell me if this is already a known problem?  I don't see anything in the issues board....

*******
The report template is recognized, and I can start the process of adding a report instance: a preview is created and after adding a title, etc the notice that an instance has been created appears.  But that's it - looking in the database (civicrm_report_instance) there is a instance, but without a title, description, permission or nav_id.  The nav table (civicdm_navigation) also has an entry for the report, but its missing most values.

Other custom reports (edited versions of CiviCRM reports, to add custom fields, etc) function as expected with instances and navigation entries.  We have also tried this across multiple sites with the same result.

*******
This is the test report (there is a matching tpl, of course).
<?php
require_once 'CRM/Report/Form.php';


class CRM_Report_Form_Contact_TestReport extends CRM_Report_Form {

function postProcess(){
    $this->beginPostProcess();
    
    $fullquery=
"SELECT
id from civicrm_contact
WHERE id < 100";
        
/*now register all the columns to display */
    $this->_columnHeaders =
        array ('id'=> array ('title' => 'CiviCRM ID'),
                );
                
    $this->buildRows ($fullquery, $rows);
    $this->formatDisplay($rows);
    $this->doTemplateAssignment( $rows );
    $this->endPostProcess( $rows );
    
    }
}
?>

p.s.  I am also, as a workaround, editing the civicrm_navigation table, so that I can add the report to a menu, as this table is also missing information for the custom report instance, although a record is created.