Symptom
- Passing an ADO .NET Dataset to a Crystal Report
- Dataset contains a field with parenthesis; PA-PHONE-NO(1)
- Full error message is:
Invalid Argument provided. Details: crdb_adoplus : Object reference not set to an instance of an object. Failed to open a rowset.
Error in File C:\Windows\TEMP\Account History {401A8758-8F34-487B-BF62-12F894F4F1A1}.rpt: Invalid argument for database.
Environment
- VS .NET 2008
- CR 2008
Cause
- According to the XML standards, parenthesis () are not supported
- Saving the dataset to an XML file results in the filed being written as; <PA-PHONE-NO_x0028_1_x0029_>
- The parenthesis are converted into ASCII values causing the error
Resolution
- Do not use parenthesis
Keywords
Perenthesis paren bracket brace , KBA , BI-DEV-NET-SDK , .NET SDK / COM SDK , How To
Product
Crystal Reports 2008 V1