CiviCRM Community Forums (archive)

I am trying to Create a Report from a Template using the Case Details Report. Everything works well when I do not set any filters. However, when I set filters (for example, Case Type and Case Status) I am able to create the report but when I go to view the newly created report I get an error.
The error is “Sorry. A non-recoverable error has occurred. DB Error: syntax error”. Does anybody have any ideas on what may be going on, or what I am doing wrong?
Thanks.

The Error Details are:

Database Error Code: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ...

Just got an bug while checking this
After applying above patch u need to use this
Index: CRM/Report/Form/Case/Detail.php
===================================================================
--- CRM/Report/Form/Case/Detail.php (revision 33562)
+++ CRM/Report/Form/Case/Detail.php (working copy)
@@ -460,7 +460,7 @@
                 }
             }
             if ( array_key_exists('civicrm_case_case_type_id', $row ) ) {
-                if ( $value = str_replace( CRM_Case_BAO_Case::VALUE_SEPERATOR, '', $row['civicrm_case_case_type_id'] )) {
+                if ( $value = str_replace( CRM_Core_DAO::VALUE_SEPARATOR, '', $row['civicrm_case_case_type_id'] )) {
                     $rows[$rowNum]['civicrm_case_case_type_id'] = $this->case_types[$value];
                     
                     $entryFound = true;

Thanks,
Rajan