Converting report from "Data" to "ODBC" 1

[BijuP]

Hi,

I am in desperate need of a solution for this. I want to convert an existing crystal report file, which is using "Data File" (MS Access), to the one which uses "SQL/ODBC". It was working fine till the application (VB) wasn't in network. Once it had become a network application, the "Data File" report couldn't be opened from remote systems (it uses central database). I want to know whether there is any remote possibilty for getting the above said task done or should I redo everything from scratch ! I am using Seagate Crystal Reports 7.
I tried to change the location of the database in runtime using DataFiles(0) property of the Report Control in VB. That works fine for the main report, but gives an error (table not found at the location) for Subreport.

Please help me out.Thanks.

Regards,
Biju.

 

[dalchri]

Biju,

There is a property called SubReportToChange for the VB Crystal Control. Use this property to set the location of the database for your subreport.

Example:

With VBCrystalControl
.DataFiles(0) = "full file name and path"
.SubReportToChange = "The subreport name"
.DataFiles(0) = "full file name and path"
.SubReportToChange = ""
.Action = 1
End With

 

[BijuP]

Dear Dalchri,
Thank you for the needed help. The code is working fine and I seem to be relieved of the tension now ! Thanks again.
Biju.