simple report

[noister]

hi to all.

i have the following code calling a report created in crystal report using odbc connection.

cr.Connect = "ODBCDBName"
cr.SQLQuery = "Select * TableName"
cr.ReportFileName = App.path & "ReportFile.rpt" 
cr.PrintReport

but the problem is that the report does not show up. why is it?

noister

[jggtz]

Probably because of missing \ in path :

cr.ReportFileName = App.path & "\ReportFile.rpt"

[noister]

here's my current code now...

cr.Connect = strODBCDB
cr.SelectionFormula = ""
cr.ReportFileName = StrReportFile
cr.WindowShowPrintSetupBtn = True
cr.WindowShowRefreshBtn = True
cr.WindowState = crptMaximized
cr.Action = 1

error: Run-time error '20599'
Cannot Open SQL server.