Crystal Reports 2011 Activex and Ms Access 2010

[Former Member]

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 and Activex can I use with Crystla 2011 ?

What component  ( Activex?) 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

[former_member183750 · Accepted solution]

Hello Giovanni

You are not licensed to use the craxddrt.dll in any applications. Craxddrt.dll belonged to and SDK that was often referred to as RDC (Report Designer Component). This SDK was retired in Crystal Reports XI R2 (11.5) and is now replaced by the SDK for VS .NET.

E.g.; you can not use the RDC in CR2011. For more info see the following:

http://scn.sap.com/community/crystal-reports-for-visual-studio/blog/2008/10/20/report-designer-compo...

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/80bd35e5-c71d-2b10-4593-d09907d9...

http://devlibrary.businessobjects.com/BusinessObjectsXIR2SP2/en/en/CrystalReports_dotNET_SDK/crsdk_n...

http://www.businessobjects.com/jump/xi/gettingstarted/whatsnew_cr2008.pdf

- Ludek

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces

[Former Member · Accepted solution]

Hello Ludek,

                         thank's for the information, but I don't hane understund what are the component that I can use in Access 2010 in VBA to view the Report. MS Access  2007 and 2010 don't use .NET but VBA that is a simple version of VB6.

1. You have some example of code that I can user in VB6 to view the report of Crystal Reports 2011?
2. What is the library that I have to use ( reference component in VBA)?
3. What is the component that I have to release in my application if i cannot use RDC?

Thak's for the support

Giovanni Roi

[former_member183750 · Accepted solution]

1. You have some example of code that I can user in VB6 to view the report of Crystal Reports 2011?

- CR2011 does not ship and developer SDK.

2. What is the library that I have to use ( reference component in VBA)?

- No support as such for VBA anymore. Only .NET or possibly Java

3. What is the component that I have to release in my application if i cannot use RDC?

- CR SDK for .NET

Sorry, I'm sure this is not what you want to hear, but no COM SDK for CR anymore. Only .NET and Java.

- Ludek