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.ViewReport   
    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

Actions