2 Replies Latest reply: May 22, 2012 7:47 PM by Ludek Uher RSS

Crystal Reports 2011 and Ms Access 2010

Giovanni Roi
Currently Being Moderated

I use now Crystal Reports XI with Access 2007 with Activex in VBA control and RDC to view the report with this code.

I want to use Access 2010 with Crystal Reports 2011 but I see that Crystal 2011 don't have Activex and RDC.


What code can I use with Crystla 2011 ? and What component I have tu use to view the reports?



  Dim crxApplication As CRAXDDRT.Application
  Dim crxReport As CRAXDDRT.Report
  Dim nomefile As String
  Dim DirName As String
  Dim sPath As String
  Dim LPath As Integer
  Dim NomeReport As String 
  NomeReport = "Reports.rpt"

    Set crxApplication = CreateObject("CrystalRuntime.Application")
    Set crxReport = crxApplication.OpenReport(("C:\Report\" & NomeReport), 0)   
    Me.CrystalActiveXReportViewer6.ReportSource = crxReport            
    Me.CrystalActiveXReportViewer6.EnableSearchControl = True   
    Me.CrystalActiveXReportViewer6.EnableProgressControl = True   
    Me.CrystalActiveXReportViewer6.DisplayToolbar = True   
    Me.CrystalActiveXReportViewer6.DisplayGroupTree = False   
    Me.CrystalActiveXReportViewer6.Zoom (100)




Thank's for the support


Giovanni Roi