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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to call the multiple database into CR9 ???

Status
Not open for further replies.

CrystalReports9

Programmer
Jan 10, 2003
124
US
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top