SAP Knowledge Base Article - Preview

2230602 - Leading and decimal ending zeroes are not displayed in the WebI report for number objects when using FHSQL as data source


  • Decimal digits (zeroes) are not displaying in WebI report when using querying with Free Hand SQL function.
  • For Example:
    • SQL Client returns: 1234.50000
    • Result in WebI: 1234.5
  • Same behavior with e-fashion database.



  • SAP BusinessObjects Web Intelligence SP6
  • FHSQL data source


SAP BusinessObjects Business Intelligence platform 4.1


Free hand, SQL, DB2, SQL, Oracle, Microsoft, FHSQL, zero, zeroes, end trim, cut trimmed, cut off, webi, SP6 , KBA , BI-RA-WBI , Web Intelligence , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.