I am currently currently using the Crystal Report viewer to view and export my reports in Vb 6.0
My reports are being read from the server through an INI file.
The problem i’m having lies with attempting to Refresh a report on the server that has had it’s datasource closed and not opened as yet.
When i attempt to Refresh such a report i get the error messaage: “The Server has not been opened”
My reports are using an ODBC type datasource to open tables.
I can fix this error buy opening up the report through Crystal Reports application it self and setting the database location the read the machine’s DSN datasource.
However i would like my program to allow the user the select their machine’s datasource if it happens that the one in the server is closed.
Thus far i’m getting the user the choose the datasource using the ODBC login form in VB6.0
From the ODBC form the user can open the datasource.
I would like the code that will allow the report opened datasource to be changed to reflect the DSN datasource the user opens in the ODBC login form.