Dear all, I have two questions as follows: 1. I have been using Crystal Report 8.0 and VB6 but I need to upgrade to Crystal Report 10. I would like to be calling the report from VB IDE but I do not have the code for that and I have no idea what components to add. I have been using the following Code:-
Sub Show_Report() If Cn.State <> adStateClosed Then Cn.Close Cn.Open "Provider=sqloledb;Data Source=Server,1433;Network Library=DBMSSOCN;Initial Catalog=ServiceMaster;User ID=*****;Password=*****;" CrystalReport1.WindowShowZoomCtl = True CrystalReport1.WindowControlBox = False CrystalReport1.PageZoom (200) CrystalReport1.WindowShowExportBtn = True CrystalReport1.WindowShowPrintBtn = True CrystalReport1.WindowShowPrintSetupBtn = True CrystalReport1.WindowShowRefreshBtn = True CrystalReport1.WindowShowCloseBtn = True CrystalReport1.WindowShowGroupTree = False CrystalReport1.WindowState = crptMaximized CrystalReport1.PageZoom (200) CrystalReport1.WindowTitle = "Outstanding" & ContractTitle & "Calls By Oil Company Report" CrystalReport1.ReportFileName = App.Path & "\Reports\OutstandingCallsByOilCompany.RPT" CrystalReport1.ReplaceSelectionFormula SQL CrystalReport1.Connect = "UID=*****;PWD=******;" CrystalReport1.RetrieveDataFiles CrystalReport1.Action = 1 End Sub 2. Is it possible to run both Crystal Reports Version 8.0 and 10.0 on the same machine? Thanks in advance. Peter P Please consider your environmental responsibility. Do not print this e-mail unless you really need to. Thank you.
