SAP Knowledge Base Article - Public

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

Symptom

  • 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.

Environment

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

Cause

  • 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

Keywords

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

Product

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