Sep 09, 2009 09:00 AM|imansom|LINK
Thanks for reply.
But I don`t need fill report with data from both databases. I just need one report to be able to show informations no matter which database I choose. (every database has same table just different data).
Another one: If I create new report using OLE DB I have to fill server, user ID, password and database in Connection Information. Now what if I need to connect this report to the same database but on another server? Since I entered server in Connection Information
Window during report creating won`t this report fail to connect on another server?
ReportDocument crystalReport = new ReportDocument();
crystalReport.SetDatabaseLogon("sa", "sa", @"SERVER", "database");
CrystalReportViewer.ReportSource = crystalReport;
if I change server name in this code from 'SERVER' to 'SERVER2' it just ask me to fill password but it still connects to server which was entered in Connection Information Window.