Dynamically change ODBC driver / datasource for the report?
We are using Delphi, Interbase and Crystal Reports 9.
In our Win32 product, we use a Crystal VCL which passes the report parameters and the database connection string to the report. This way we develop our reports using an ODBC connection to a standard Interbase database, but the one actually in production depends on the client (as a client can have multiple datatabses). The connection string passed by the VCL overrides the windows ODBC conneciton.
In our Web product, we are using the .Net Crystal component in place of the VCL. How do we pass the connection string using this component?
Our issue is that we can't find a way to do this for the combination of .Net, Interbase and Crystal.
If this is not clear, or more details are needed, please let me know.
We are using Delphi, Interbase and Crystal Reports 9.
In our Win32 product, we use a Crystal VCL which passes the report parameters and the database connection string to the report. This way we develop our reports using an ODBC connection to a standard Interbase database, but the one actually in production depends on the client (as a client can have multiple datatabses). The connection string passed by the VCL overrides the windows ODBC conneciton.
In our Web product, we are using the .Net Crystal component in place of the VCL. How do we pass the connection string using this component?
Our issue is that we can't find a way to do this for the combination of .Net, Interbase and Crystal.
If this is not clear, or more details are needed, please let me know.