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
- MSDN: Text File Data Types
Keywords
CRVS CR size small big txt consume bring print show , KBA , BI-RA-CR , Crystal Reports designer or Business View 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