Notes & Crystal Reports

HCL Domino Domino Forum
1

Is there a way to call/run a crystal report within a lotus notes database ? If so, where do I start ?

Any help would be greatly appreciated…

Thanks,

Ken H.

2

Subject: Notes & Crystal Reports

Crystal can query a lotus notes database via the Lotus Notes ODBC driver.

I don’t think you are “call/run a crystal report within a lotus notes database”.

HTH – Cheers

3

Subject: RE: Notes & Crystal Reports

Crystal Report can query Notes Database with a NotesSQL driver. Create Crytal Report Control in the form in which you are generating report. Using object routines, you can pass parametrs, specify the path of the file, NotesSQL driver name to the crystal report you designed.

I am putting a sample code for you here.

'Report is the name of the control

Dim ctl As Variant

Set ctl = uidoc.GetObject(“Report”)

'ls_ReportFrom is a string holds a date

'StartDate is crystal report parameterof type Date

ctl.parameterfields(0)=“StartDate;date(”+Cstr(Year(ls_ReportFrom))+“,”+Cstr(Month(ls_ReportFrom))+“,”+Cstr(Day(ls_ReportFrom))+“)” +“;True”

'Activity is a parametr in crystal report parameter of type String

ctl.parameterfields(2)=“Activity;”+Cstr(ls_ActivityType)+“;True”

ctl.reportfilename=“C:/Reports/Detailed Report.rpt”

ctl.connect=“dsn=” & NotesSQL1

ctl.WindowState = 2

ctl.Action = 1

Hope, this helps you to generate report that you would like to.

Reddy

4

Subject: RE: Notes & Crystal Reports

Hello,

I am trying to call a report of the Crystal but always occurs the same error. Catch his example and occurs the same error in the line that creates the Object => Set clt = uidoc.getobject(“Report”)

Please help me, what is occurring? EMAIL write me: vagnerst@bol.com.br

It obliged, Vagner