Anonymous | Login
Project:
RSS
  
News | My View | View Issues | Roadmap | Summary

View Issue Details[ Jump to Notes ] [ Issue History ] [ Print ]
ID
0020600
TypeCategorySeverityReproducibilityDate SubmittedLast Update
design defect[Openbravo ERP] A. Platformminorhave not tried2012-05-24 13:192019-09-20 10:37
ReporteregoitzView Statuspublic 
Assigned ToTriage Finance 
PriorityhighResolutionopenFixed in Version
StatusscheduledFix in branchpiFixed in SCM revision
ProjectionnoneETAnoneTarget Version
OSAnyDatabaseAnyJava version
OS VersionDatabase versionAnt version
Product Version3.0MP10.2SCM revision 
Review Assigned To
Web browser
ModulesCore
Regression level
Regression date
Regression introduced in release
Regression introduced by commit
Triggers an Emergency PackNo
Summary

0020600: Arabic characters set are not printed on the standar reports.

DescriptionWhen using arabic language, the reports are arabic characters are not printed on the report.
Steps To Reproduce-Create a salers order
-create a line with a prodcut
-change the name of the product. for exmple with:

سركون بولص. بورتريه للشخص العراقي ف

Print the report.
The name of the product is not printed.
Proposed Solution-Change in all the jrxml files the fontName and pdfFontName to use "Dejavu Sans" instead of the fonts used actually (Helvetica or Bitstream Vera Sans)
TagsNo tags attached.
Attached Files

- Relationships [ Relation Graph ] [ Dependency Graph ]
related to defect 0041790 closedmarkmm82 č slovenian character disappearing in Openbravo PDF Jasper Reports 
has duplicate defect 00237703.0MP25 closedshankarb The warning from Jasper are creating big logs of tomcat and the log is not readable 
related to design defect 0019325 acknowledgedTriage Platform Base i'm using the application in arabic and all pdf and reports doesn't support arabic encoding 
related to defect 00253143.0PR14Q2 closedcaristu Arabic characters set are not printed on some standard reports. 
related to feature request 0025729 closedSandrahuguet Create jasper template for balance sheet report and profit & loss 

-  Notes
(0049741)
Sandrahuguet (developer)
2012-06-12 08:56
edited on: 2012-06-12 09:10

 We have deleted in all jrxml files the fontName and pdfFontName. Besides, the default styles(isDefault="true") have been changed to isDefault="false".
We have created a new propertie in openbravo.properties for font name in the iReports. The font name by default is DejaVu Sans.
 *jasperreports.default.font=DejaVu Sans
If you do not write this property or write the font name incorrectly in openbravo.properties the jrxml used the default font name in iReport (San Serif)
(0049742)
Sandrahuguet (developer)
2012-06-12 08:59
edited on: 2012-06-12 09:00

 The following iReports have been modified in core:

 modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_reports/ReportReconciliation.jrxml
  modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportExcel.jrxml
  modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportPDF.jrxml
  modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped.jrxml
  src/org/openbravo/erpCommon/ad_reports/productionReport.jrxml
  src/org/openbravo/erpCommon/ad_reports/productionSubReport.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportAnnualCertification.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportAssetDepreciationSchedule.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportBankJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_perDay.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_sub.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportCashJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_BankAcc.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_NoBP_BankAcc.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_NoBP.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportDebtPaymentTracker.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportExpense.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalExcel.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDateJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportInvoicesEditJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportMaterialTransactionEditionJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportPendingProductionJr.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportProductionRun.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSiteJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportProjectProgress.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportPurchaseOrder.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoicedJasper.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportSalesPartnerProduct.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportShipmentEdition.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR_srptcosts.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR_subreport0.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoice.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoicePurchase.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoicePurchaseForeign.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSale.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSaleForeign.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportTrialBalancePDF.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementDailyEdit.jrxml
  src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementJR.jrxml
  src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalComparative.jrxml
  src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalNoComparative.jrxml
  src/org/openbravo/erpCommon/ad_reports/SubreportWorkRequirementDaily.jrxml
  src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml
  src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml
  src/org/openbravo/erpReports/C_OrderJR.jrxml
  src/org/openbravo/erpReports/C_OrderLinesJR.jrxml
  src/org/openbravo/erpReports/C_RMOrderJR.jrxml
  src/org/openbravo/erpReports/C_RMOrderLinesJR.jrxml
  src/org/openbravo/erpReports/ReportRegisterByVatJR.jrxml
  src/org/openbravo/erpReports/ReportRegisterLineJR.jrxml
  src/org/openbravo/erpReports/RptC_Invoice_Lines.jrxml
  src/org/openbravo/erpReports/RptC_Invoice_TaxLines.jrxml
  src/org/openbravo/erpReports/RptC_Invoice.jrxml
  src/org/openbravo/erpReports/RptC_OrderPO_Lines.jrxml
  src/org/openbravo/erpReports/RptC_OrderPO.jrxml
  src/org/openbravo/erpReports/RptC_ProposalJr.jrxml
  src/org/openbravo/erpReports/RptC_Remittance_Lines.jrxml
  src/org/openbravo/erpReports/RptC_Remittance.jrxml
  src/org/openbravo/erpReports/RptFIN_PaymentLines.jrxml
  src/org/openbravo/erpReports/Rptm_InOut_Lines.jrxml
  src/org/openbravo/erpReports/RptM_InOut.jrxml
  src/org/openbravo/erpReports/RptM_Requisition_Lines.jrxml
  src/org/openbravo/erpReports/RptM_Requisition.jrxml
  src/org/openbravo/erpReports/RptM_RMInOut_Lines.jrxml
  src/org/openbravo/erpReports/RptM_RMInOut.jrxml
  src/org/openbravo/erpReports/RptMA_ProcessPlan.jrxml
  src/org/openbravo/erpReports/SubreportLines.jrxml
(0049745)
Sandrahuguet (developer)
2012-06-12 10:29

 Test Plan:
- Go to Business Partner select one, and change the Commercial Name to: سركون بولص. بور
تريه للشخص العراقي ف
- Go to sales order create a order to the business partner سركون بولص. بورتريه للشخص العراقي ف, and Book.

- Go to sales order report and Print the report, notice that the business partner is printed.
(0050822)
jonalegriaesarte (reporter)
2012-07-25 09:40

 Clasified as design defect because all the reports need to be changed
(0065334)
psanjuan (manager)
2014-03-21 08:59
edited on: 2014-03-21 09:09

 The solution provide to this issue (Chinese, Japanese, Arabic..etc character not printed properly on OB PDF format reports) is:

We have deleted in all jrxml files the fontName and pdfFontName. Besides, the default styles(isDefault="true") have been changed to isDefault="false".

We have created a new property in OB properties that is *jasperreports.default.font, which is set to DejaVu Sans font by default, unless the end-user wants to change it to another font.

If you do not want to use DejaVu Sans font but another one, it is necessary to create a .jar as described in this How to document: http://wiki.openbravo.com/wiki/How_to_Change_Fonts_in_Openbravo_Reports#Changing_the_font_in_Jasper_Reports. [^]
Once done, remember to fill in the font to be used in the *jasperreports.default.font OB property.

Have in mind that if you do not fill in this property or write the font name incorrectly or if you fill in a font which does not have the corresponding .jar created, the OB reports will the be printed by using the defaulted font name in iReport that is San Serif.

This solution is going to be provided in the next release that is PR14 Q3.
(0065352)
Sandrahuguet (developer)
2014-03-21 11:08

 List of modified reports:

M modules/org.openbravo.advpaymentmngt/src/org/openbravo/advpaymentmngt/ad_reports/ReportReconciliation.jrxml
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportExcel.jrxml
M modules/org.openbravo.financial.paymentreport/src/org/openbravo/financial/paymentreport/erpCommon/ad_reports/PaymentReportPDF.jrxml
M modules/org.openbravo.reports.ordersawaitingdelivery/src/org/openbravo/reports/ordersawaitingdelivery/erpCommon/ad_reports/ReportOrderNotShipped.jrxml
M src/org/openbravo/erpCommon/ad_reports/CustomerStatement.jrxml
M src/org/openbravo/erpCommon/ad_reports/GeneralAccountingReportsPDF.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportAgingBalance.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportAnnualCertification.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportAssetDepreciationSchedule.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportBankJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportCashJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_perDay.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportCashflowForecast_sub.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPaymentTracker.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_BankAcc.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_NoBP.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportDebtPayment_NoBP_BankAcc.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportExpense.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedger.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerExcel.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournal.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGeneralLedgerJournalExcel.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportGuaranteeDateJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesComparativeJR_legacy.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerDimensionalAnalysesNoComparativeJR_legacy.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceCustomerJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceDiscountJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoiceVendorJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportInvoicesEditJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportMaterialTransactionEditionJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportOrderNotInvoiceJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportPendingProductionJr.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportProductionRun.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportProjectBuildingSiteJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProfitabilityJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportProjectProgress.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportPurchaseOrder.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderInvoicedJasper.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesOrderProvidedJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportSalesPartnerProduct.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportShipmentEdition.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR_srptcosts.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportStandardCostsJR_subreport0.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoice.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoicePurchase.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoicePurchaseForeign.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSale.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTaxInvoiceSaleForeign.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportToInvoiceConsignmentJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalanceExcel.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportTrialBalancePDF.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportWarehousePartnerJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementDailyEdit.jrxml
M src/org/openbravo/erpCommon/ad_reports/ReportWorkRequirementJR.jrxml
M src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalComparative.jrxml
M src/org/openbravo/erpCommon/ad_reports/SimpleDimensionalNoComparative.jrxml
M src/org/openbravo/erpCommon/ad_reports/SubreportWorkRequirementDaily.jrxml
M src/org/openbravo/erpCommon/ad_reports/WeightDimensionalComparative.jrxml
M src/org/openbravo/erpCommon/ad_reports/WeightDimensionalNoComparative.jrxml
M src/org/openbravo/erpCommon/ad_reports/productionReport.jrxml
M src/org/openbravo/erpReports/C_OrderJR.jrxml
M src/org/openbravo/erpReports/C_OrderJR_new.jrxml
M src/org/openbravo/erpReports/C_OrderLinesJR.jrxml
M src/org/openbravo/erpReports/C_OrderLinesJR_new.jrxml
M src/org/openbravo/erpReports/C_OrderLinesTaxIncludedJR.jrxml
M src/org/openbravo/erpReports/C_OrderLinesTaxIncludedJR_new.jrxml
M src/org/openbravo/erpReports/C_QuotationJR.jrxml
M src/org/openbravo/erpReports/C_RMOrderJR.jrxml
M src/org/openbravo/erpReports/C_RMOrderLinesJR.jrxml
M src/org/openbravo/erpReports/ReportRegisterByVatJR.jrxml
M src/org/openbravo/erpReports/ReportRegisterLineJR.jrxml
M src/org/openbravo/erpReports/RptC_Invoice.jrxml
M src/org/openbravo/erpReports/RptC_Invoice_Lines.jrxml
M src/org/openbravo/erpReports/RptC_Invoice_Lines_new.jrxml
M src/org/openbravo/erpReports/RptC_Invoice_TaxLines.jrxml
M src/org/openbravo/erpReports/RptC_Invoice_TaxLines_new.jrxml
M src/org/openbravo/erpReports/RptC_Invoice_new.jrxml
M src/org/openbravo/erpReports/RptC_OrderPO.jrxml
M src/org/openbravo/erpReports/RptC_OrderPO_Lines.jrxml
M src/org/openbravo/erpReports/RptC_Order_TaxLines.jrxml
M src/org/openbravo/erpReports/RptC_Order_TaxLines_new.jrxml
M src/org/openbravo/erpReports/RptC_ProposalJr.jrxml
M src/org/openbravo/erpReports/RptC_Remittance.jrxml
M src/org/openbravo/erpReports/RptC_Remittance_Lines.jrxml
M src/org/openbravo/erpReports/RptFIN_PaymentLines.jrxml
M src/org/openbravo/erpReports/RptMA_ProcessPlan.jrxml
M src/org/openbravo/erpReports/RptM_InOut.jrxml
M src/org/openbravo/erpReports/RptM_InOut_new.jrxml
M src/org/openbravo/erpReports/RptM_RMInOut.jrxml
M src/org/openbravo/erpReports/RptM_RMInOut_Lines.jrxml
M src/org/openbravo/erpReports/RptM_Requisition.jrxml
M src/org/openbravo/erpReports/RptM_Requisition_Lines.jrxml
M src/org/openbravo/erpReports/Rptm_InOut_Lines.jrxml
M src/org/openbravo/erpReports/Rptm_InOut_Lines_new.jrxml
M src/org/openbravo/erpReports/SubreportLines.jrxml

- Issue History
Date Modified Username Field Change
2012-05-24 13:19 egoitz New Issue
2012-05-24 13:19 egoitz Assigned To => alostale
2012-05-24 13:19 egoitz Modules => Core
2012-06-04 11:46 alostale Assigned To alostale => mirurita
2012-06-07 10:31 Sandrahuguet Assigned To mirurita => Sandrahuguet
2012-06-07 10:31 Sandrahuguet Status new => scheduled
2012-06-07 10:31 Sandrahuguet fix_in_branch => pi
2012-06-12 08:56 Sandrahuguet Note Added: 0049741
2012-06-12 08:59 Sandrahuguet Note Added: 0049742
2012-06-12 09:00 Sandrahuguet Note Edited: 0049742 View Revisions
2012-06-12 09:10 Sandrahuguet Note Edited: 0049741 View Revisions
2012-06-12 10:29 Sandrahuguet Note Added: 0049745
2012-07-25 09:40 jonalegriaesarte Assigned To Sandrahuguet => egoitz
2012-07-25 09:40 jonalegriaesarte Note Added: 0050822
2012-07-25 09:40 jonalegriaesarte Type defect => design defect
2012-07-25 09:40 jonalegriaesarte Target Version 3.0MP14 =>
2012-07-25 09:40 jonalegriaesarte fix_in_branch pi =>
2012-09-13 10:42 jonalegriaesarte Assigned To egoitz => dmiguelez
2013-02-16 09:14 thirumalaik Relationship added related to 0019325
2013-06-27 18:13 Sandrahuguet Status scheduled => acknowledged
2013-06-27 18:14 Sandrahuguet Status acknowledged => scheduled
2013-06-27 18:14 Sandrahuguet fix_in_branch => pi
2013-06-27 18:17 AugustoMauch Relationship added has duplicate 0023770
2013-12-12 11:17 caristu Relationship added related to 0025314
2014-02-13 18:26 Sandrahuguet Relationship added related to 0025729
2014-03-13 10:40 Sandrahuguet Assigned To dmiguelez => Sandrahuguet
2014-03-21 08:59 psanjuan Note Added: 0065334
2014-03-21 09:09 psanjuan Note Edited: 0065334 View Revisions
2014-03-21 11:08 Sandrahuguet Note Added: 0065352
2017-05-29 13:45 Sandrahuguet Assigned To Sandrahuguet => Triage Finance
2019-09-20 10:37 Sandrahuguet Relationship added related to 0041790

Copyright © 2000 - 2009 MantisBT Group
Powered by Mantis Bugtracker