SAP Knowledge Base Article - Public

2004931 - Is there a limit to text file size that can be accessed using ODBC?


  • A text file contains over a million records.
  • When connecting a Crystal Reports to the datasources, only a small fraction of the records are displayed in the report.


  • Crystal Reports 2008
  • SAP Crystal Reports 2011
  • SAP Crystal Reports 2013
  • SAP Crystal Reports, Developer Version for Visual Studio .NET


  • The theoretical limit on the width of a LONGCHAR column in either a fixed-length or delimited table is 65500K.
  • The Text ISAM is more likely to provide reliable support up to about 32K.

See Also


CRVS CR size small big txt consume bring print show , KBA , BI-RA-CR , Crystal Reports designer or Business View Manager , Problem


Crystal Reports 2008 V1 ; SAP Crystal Reports 2011, feature pack 03 ; SAP Crystal Reports 2013 ; SAP Crystal Reports, developer version for Microsoft Visual Studio ; SAP Crystal Reports, version for Visual Studio .NET 2008