SAP Knowledge Base Article - Preview

1574977 - How to add a SQL Query larger than 64KB in Command Object in Crystal Reports?

Symptom

  • Unable to enter large SQL Query in a Command Object.
  • Error: 'Failed to retreive data from the database.' when attempting to add a large SQL Query to a report in Crystal Reports.
  • How to add a SQL Query in a Command Object in Crystal Reports, when the size of the SQL Query is greater than 64 KB? 


Read more...

Environment

  • SAP Crystal Reports 2013
  • SAP Crystal Reports 2016
  • SAP Crystal Reports 2020

Product

SAP Crystal Reports 2013 ; SAP Crystal Reports 2016 ; SAP Crystal Reports 2020

Keywords

CR, Command Object, SQL Query , 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 ONE Support launchpad (Login required).

Search for additional results

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