SAP Knowledge Base Article - Preview

2329727 - Report returns no data, when filtering on MS SQL Server GUID in Crytal Reports

Symptom

  • No data returned.
  • When filtering on a GUID, it returns no data.
  • Filtering on the same GUID in MS SQL Server returns a result set.
  • When reporting off MS SQL Server using an OLEDB connection, and filtering on a unique identifier, it returns no data in Crystal Reports.
  • But when adding french braket around the GUID, like: '{9A784140-24B4-4482-85CC-FF9ACE5EDE75}', it returns data in Crystal Reports.


Read more...

Environment

  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
              
  • MS SQL Server 2012
  • MS SQL Server 2014
  • MS SQL Server 2016
  • MS SQL Server 2017

Product

Crystal Reports 2008 V1 ; SAP Crystal Reports 2011 ; SAP Crystal Reports 2013 ; SAP Crystal Reports 2016

Keywords

CR, SQL Sever GUID , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , 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.