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 ONE Support launchpad (Login required).

Search for additional results

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