Skip to Content
1
Former Member
Sep 13, 2012 at 04:13 PM

Set SQL Expression Fields in VS 2010 Verison of Crystal Reports

169 Views

I am converting an application written in VB6 using CR 10.5 and ActiveX to VS2010/VB.Net using CR VS2010 version.

I am able to convert all of the existing code except for a line that sets the SQL Expression Fields as shown below:

crReportDocument.SQLExpressionFields.GetItemByName(msSQLExpression(0, x)).Text = msSQLExpression(1, x)



From searching and reading, it appears that setting the SQLExpressionFields is no longer allowed. I find that there is an item collection associated with SQLExpressionFields, but it is READ-ONLY.



1- Is it true that setting the SQLExpressionFields is no longer allowed/supported in the VS2010 version?



2- If this is no longer supported, how should/could I work around this issue?





Thanks in advance for your help and assistance!