I am migrating an application using the Crystal Reports OCX COM control from VB6 to VB.NET. The reports all use SQL stored procedures to get their data. In VB6, I would set the report's stored procedure's parameters using the STOREDPROCPARAM(X) property of the OCX control as in the following code:
.StoredProcParam(0) = My.Settings.Lang_ID 'Lang Id
.StoredProcParam(1) = My.Settings.Warehouse 'Warehouse
.StoredProcParam(2) = Me.ultText1.Text 'Beginning Request #
.StoredProcParam(3) = Me.ultText2.Text 'Ending Request #
.StoredProcParam(4) = Me.ultText3.Text 'Beginning Stock #
The problem is that when I use the OCX control as a COM object in my .NET project, all references to StoredProcParam() have squiggles and the messages says that StoredProcParam is not a member of AcCrystal.AcCrystalReports. Is there an alternate way of setting store procedure parameters for the OCX control?