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 2016
  • SAP Crystal Reports 2020
  • SAP Crystal Reports 2025

Product

SAP Crystal Reports 2016 ; SAP Crystal Reports 2020 ; SAP Crystal Reports 2025

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 for Me (Login required).

Search for additional results

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