Cannot open SQL Designed report within VB

[marabou]

We have a problem with a report. It is based on a SQL Designed query and gets its parameters from a temporary table within the database.

The vb code we are using within the app

CrystalReport1.Connect = "korg" 'conn.ConnectionString
CrystalReport1.ReportFileName = App.Path "\DeliveryNote.rpt"
CrystalReport1.PrintReport

does not display the report, where it does for every other report we have ever used. We get the error

'xbase error: cannot open file'

Has anyone got any ideas what could be causing this, we seem to be running around in circles. It is v. urgent so I would appreciate any help anyone could give me.

Thanks in advance

 

[marabou]

If anyone is interested, we have bypassed the error completely, by creating a view with the complex sql statement and doing the report from that instead. This has also cut down by loads the processing time of the report.