Access Crystal Reports through OLE Db through Lotusscript

HCL Domino Domino Forum
1

Hi,

I want to access the Crystal Reports through OLE Db using Lotus Script.

Can anybody help me in this regard by giving some Sample Code.

Thanks

Veerappan.G

2

Subject: Access Crystal Reports through OLE Db through Lotusscript

There is a pdf document (only 15 pages) very useful. The name of the file is cr_lotus_rdc.pdf. If you need it, contact me at j.alemany@alboraya.com and I will send to you.

Here comes some example code:

Dim m_Viewer As Variant

Set m_Viewer = Source.GetObject("Crystal Report Viewer

Control")

Set App = CreateObject(“CrystalRuntime.Application”)

Set Rep = App.OpenReport(“c:\lotus\notes\rep.rpt”)

Set m_Viewer.ReportSource = Rep

’ So that we can refresh the report data

m_Viewer.EnableRefreshButton = 1

’ So that we can export the report after previewing

m_Viewer.EnableExportButton = 1

m_Viewer.ViewReport

I hope this will help you…