Avatar of JayMeredith
JayMeredith
Flag for United States of America asked on

no stored procedures property when using crystal reports OCX in .NET

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:

 With Me.CRpt1
          .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 #
 End With

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?
Visual Basic ClassicCrystal Reports

Avatar of undefined
Last Comment
JayMeredith

8/22/2022 - Mon
Mike McCracken

I suspect the OCX is not .Net compliant.  It was last updated in CR6.  

You could try using the RDC but I think you will have the same issue.

I don't know of a document that explains how to go from the OCX to the .Net assemblies.


What version of Crystal do you have?
I don't know of a version that has the OCX that is compatible with VB.Net

mlmcc
ASKER CERTIFIED SOLUTION
JayMeredith

Log in or sign up to see answer
Become an EE member today7-DAY FREE TRIAL
Members can start a 7-Day Free trial then enjoy unlimited access to the platform
Sign up - Free for 7 days
or
Learn why we charge membership fees
We get it - no one likes a content blocker. Take one extra minute and find out why we block content.
Not exactly the question you had in mind?
Sign up for an EE membership and get your own personalized solution. With an EE membership, you can ask unlimited troubleshooting, research, or opinion questions.
ask a question
JayMeredith

ASKER
found my own solution
I started with Experts Exchange in 2004 and it's been a mainstay of my professional computing life since. It helped me launch a career as a programmer / Oracle data analyst
William Peck