Limitation on data passed to Crystal Report
Hello, I have a very basic question that I cannot find the answer to in the manual or online.
We are pulling data from a SQL 2005 database. Specifically, we are querying information that contains very complicated legal instructions - the equivalent of two dozen pages of text.
We are finding that the data is being truncated once it reaches the report to about 7 pages....
Is there a limit on the amount of data Crystal Report XI can bring across from a single record. Or is this a limitation of the report itself? I am working with the developers who are struggling to make this work correctly and I am trying to get to the bottom off this.
Thanks for your time!
Graham Cunningham replied
The limit is 64k of data per record. You may find that only 32k are coming back if the data is stored as double byte characters. The only workaround to this that I am aware of is to chunk the data out into blocks of 64k data in a stored procedure or view.