Home › forums › Forums for Groups › 4GL/ABL General Programming

Calling Crystal Report from ABL using JDBC Connection

Fri, 2008-06-06 06:03 — gSanchez

Cystal Report XI
OE Architect 10.1C

Hi PSC Users,
I found this code from PSDN. This is how to call Crystal Report using ODBC.
CREATE "CrystalRuntime.Application" chApplication.

chDocument = chApplication:OpenReport("d:\customer\crystal\1 Sales per country per customer top-5.rpt", 1).
chDatabase = chDocument:DATABASE.
chParamDefs = chDocument:ParameterFields.
chParamDef = chParamDefs:Item(1).
MESSAGE chParamDef:ParameterFieldName .
ResultText = chParamDef:SetCurrentValue(500).

chDocument:EnableParameterPrompting = TRUE.

chDatabase:LogOnServer("pdsodbc.dll", "sports2000", "", "pub", "pub").
AxViewer_Handle:ReportSource = chDocument.
AxViewer_Handle:REFRESH.
AxViewer_Handle:ViewReport.

Does anybody know how to do this using JDBC Connection?
I have search lot of site already, and found no answers..


‹ OE10 - Best practice suggestions for source / object code folder organization [4GL/ABL] Reverse: from DB's schema to table's relationship is possible? ›