We have the same report used in both SQL-Server and Oracle. Current implementation has 2 reports, one for Oracle, one for SQL-Server. From a maintenance standpoint, this is unacceptable (we have hundreds). We would like to have one report that could work for both. Is there a way to have one report fit both SQL and Oracle?
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Oracle and SQL-Server one report fits all?
- Thread starter vtisgreat
- Start date
If you are strictly using Crystal Reports as a stand-alone app, then I doubt it. You're talking about 2 different db drivers.
However, if you had a front-end app in VB, you could pass an ADO recordset to the report, and inside the VB code you could create an ADO recordset from either Oracle or SQL Server. Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer
However, if you had a front-end app in VB, you could pass an ADO recordset to the report, and inside the VB code you could create an ADO recordset from either Oracle or SQL Server. Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer
- Status
Similar threads
- Question
- Locked
- Question
- Locked
- Question
- Question