Article ID	2186
Article Title	INFO: Crystal CDO Limit
Article URL	http://www.dataaccess.com/kbasepublic/kbprint.asp?ArticleID=2186
KBase Category	Crystal Reports
Date Created	11/07/2005
Last Edit Date	02/15/2006

Article Text
PROBLEM:
Is there a limit to the max number of columns in a CDO-RDC report?

We have a TTX-file with over 500 columns. In the Designer the TTX can be used without any problems but when running the program and filling the array I get

'The maximum number of columns is exceeded'


SOLUTION:
Crystal Reports Knowledge Base article c2012190 states that "the maximum number of characters a CDO rowset can hold is 23876.

For instance, you can have a CDO rowset with 94 columns with each column containing 254 characters (as this does not exceed 23876 characters).

However, using a CDO rowset with 180 columns with each column containing 200 characters will cause an error message (as this does exceed 23876 characters)"



That article refers to Crystal Reports 8.5 but apparently the same limit applies to Crystal XI.  

In the help (Crystal's CrystalDevHelp.chm), under "Using the Crystal Data Object" there is a note about limitation - it doesn't state the exact number though:

Note:    Following are known limitations of the CDO:

The CDO does not support Memo or Blob fields.
If character string fields are used as data, the number of columns in the CDO is limited based on the number of characters in the string fields. For example, the more characters in the string, the fewer number of columns allowed in the rowset.




Contributed By:
Marcia Booth
Company: Data Access Worldwide
Web Site: http://www.dataaccess.com

Links Related to this Article
Business OBjects - Difference between CDO32.DLL and CDO.DLL (Collaboration Data Objects)
Business Objects - Err Msg: ".Method 'AddRows' of object 'ICrystalDataObject' failed" using CDO
DAW Knowledge Base article 2185: HOWTO: Create TTX Files using Crystal Reports Designer

Email this Article
Email this Article to a Colleague
Send Feedback on this Article to Data Access Worldwide
Copyright ©2024 Data Access Corporation. All rights reserved.

The information provided in the Data Access Technical Knowledge Base is provided "as is" without warranty of any kind. Data Access Corporation disclaims all warranties, either express or implied, including the warranties of merchantability and fitness for a particular purpose. In no event shall Data Access Corporation or its suppliers be liable for any damages whatsoever including direct, indirect, incidental, consequential, loss of business profits or special damages, even if Data Access Corporation or its suppliers have been advised of the possibility of such damages. Some states do not allow the exclusion or limitation of liability for consequential or incidental damages so the foregoing limitation may not apply.