help me to convert the code from CR 4.0 to CR XI.

LucyNgo
LucyNgo used Ask the Experts™
on
Please help me to convert the code from CR 4.0 to CR XI.
We have upgrade the OS from Win NT to XP and purchased the new CR XI.  Now I have to convert the VB code from CR 4.0 to CR XI, which I am not very good at.  I know some basic code of OCX but still in a baby steps for RDC, please help, I would greatly appreciate it.

Here is my old code from using OCX and we are using the SQL Server:
Private Sub form_load
     FormName = "addhoc"
     gdbCurrentDB.QueryTimeout = 300
end sub

Private Sub cmdSubmit_Click()
Dim SelList1 as string
SelList1= " Select * from county_res where SurveyDate='200701' and state='06' and county='001' and imp_rep='E' and datasave='R' "

        'design window format display for crystal report
          CrystAddhoc.WindowHeight = 3100
          CrystAddhoc.WindowWidth = 5900
          CrystAddhoc.WindowTitle = Trim(StName)

          CrystAddhoc.Formulas(0) = "TOPHEAD1 = 'DISPLAY DATA BY DATE - ESTIMATES W/IMPUTATION'"
          CrystAddhoc.Formulas(1) = "Subhead1 = '" & StName & "'"
          CrystAddhoc.Formulas(2) = "Title1 = 'CURRENT MONTH'"
          CrystAddhoc.Formulas(3) = "Title2 = 'YEAR-TO-DATE'"

           CrystAddhoc.ReportFileName = "C:\AddHocVersionXI\addhocitmAllCountyRes.rpt"
           CrystAddhoc.SelectionFormula =  SelList1
           CrystAddhoc.Destination = crptToWindow
           CrystAddhoc.WindowControls = True
           CrystAddhoc.Action = 1

What do I need to do to convert ?  Please guide me slowly.  Thank you very much in advance.

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Senior Consultant
Most Valuable Expert 2011
Top Expert 2013
Commented:
Forced accept.

Computer101
EE Admin

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial