0012363: An error on Report Remittance

diff -r 610225e88ac0 src/org/openbravo/base/secureApp/HttpSecureAppServlet.java
--- a/src/org/openbravo/base/secureApp/HttpSecureAppServlet.java	Wed Mar 17 20:29:41 2010 +0100
+++ b/src/org/openbravo/base/secureApp/HttpSecureAppServlet.java	Thu Apr 08 20:44:18 2010 +0530
@@ -1083,8 +1083,12 @@
       designParameters.put("USER_ORG", Utility.getContext(this, variables, "#User_Org", ""));
       designParameters.put("LANGUAGE", strLanguage);
       designParameters.put("LOCALE", locLocale);
-      designParameters.put("REPORT_TITLE", PrintJRData.getReportTitle(this,
-          variables.getLanguage(), classInfo.id));
+      String reportTitle = PrintJRData.getReportTitle(this, variables.getLanguage(), classInfo.id);
+      if (reportTitle == null) {
+        reportTitle = PrintJRData.getReportTitleFromProcess(this, variables.getLanguage(),
+            classInfo.id);
+      }
+      designParameters.put("REPORT_TITLE", reportTitle);
 
       final DecimalFormatSymbols dfs = new DecimalFormatSymbols();
       dfs.setDecimalSeparator(variables.getSessionValue("#AD_ReportDecimalSeparator").charAt(0));
diff -r 610225e88ac0 src/org/openbravo/erpCommon/utility/PrintJR_data.xsql
--- a/src/org/openbravo/erpCommon/utility/PrintJR_data.xsql	Wed Mar 17 20:29:41 2010 +0100
+++ b/src/org/openbravo/erpCommon/utility/PrintJR_data.xsql	Thu Apr 08 20:44:18 2010 +0530
@@ -54,5 +54,16 @@
       <Parameter name="adLanguage"/>
       <Parameter name="adProcessId"/>
     </SqlMethod>
+   <SqlMethod name="getReportTitleFromProcess" type="preparedStatement" return="String">
+      <SqlMethodComment></SqlMethodComment>
+      <Sql>
+        select COALESCE(t.name, m.name) AS paramname
+        FROM AD_PROCESS m LEFT JOIN ad_process_trl t ON m.AD_Process_ID  = t.AD_Process_ID
+        AND t.AD_Language = ? 
+        WHERE m.AD_Process_ID = ?
+      </Sql>
+      <Parameter name="adLanguage"/>
+      <Parameter name="adProcessId"/>
+    </SqlMethod>
     
 </SqlClass>