SAP Knowledge Base Article - Preview

1374413 - How To Format Bit Datatype for OLE DB


  • OLE DB driver to connect to MS SQL 2005 database. One of the column in table has '0' and '1' values, which should appear as '0' and '1' in BO report but they appear as '0' and '255', means it converts '1' into '255'.
  • Zero and one data is displayed as a zero and 255
  • data is displayed as 255



BusinessObjects Enterprise XIR3.1


SAP BusinessObjects Enterprise XI 3.1


KBA , BI-BIP-SL , Semantic Layer , How To

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.