CrystalReports9
Programmer
Hi
Pls help me....
I have crystal report that I would like to run on different databases, with the user selecting which database supplies the data for the report (the tables are all same in each database but yearwise the data will be differ).
I have successfully done this with a single database using the RDC combined with the LogOnServer method.
Pls give me the solution for multiple database using native oracle database driver dll crdb_oracle.dll
Environment
-----------
Crystal Report 9
ORACLE 8i
Power Builder8.0
Windows NT
Using RDC i am calling CR in PowerBuilder8.
Scenario.
---------
For example "report1.rpt" is a report created in the database "DB1". From the application if i am calling the report "rpt1" by passing the database name "DB1" and User Name / Password then the report works fine.
Later if i passing the another database name "DB2" in my application and call the same report "rpt1"(which is created using the databaes "DB1" then i got the error message "Logon Failed"....
Solution please....
Rgs
Antony
Pls help me....
I have crystal report that I would like to run on different databases, with the user selecting which database supplies the data for the report (the tables are all same in each database but yearwise the data will be differ).
I have successfully done this with a single database using the RDC combined with the LogOnServer method.
Pls give me the solution for multiple database using native oracle database driver dll crdb_oracle.dll
Environment
-----------
Crystal Report 9
ORACLE 8i
Power Builder8.0
Windows NT
Using RDC i am calling CR in PowerBuilder8.
Scenario.
---------
For example "report1.rpt" is a report created in the database "DB1". From the application if i am calling the report "rpt1" by passing the database name "DB1" and User Name / Password then the report works fine.
Later if i passing the another database name "DB2" in my application and call the same report "rpt1"(which is created using the databaes "DB1" then i got the error message "Logon Failed"....
Solution please....
Rgs
Antony