i have created a crystal report every thing worked fine but when i debug im getting like **The report you requested requires further information. and below it servername,username,password are appearing i dnt knw why dese are coming.i have already given connection when i am creating crystal reports can anyone help me with this??

Hi,

CrystalDecisions.CrystalReports.Engine.ReportDocument report = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
            string oldServerName = "OldServer";
            string newServerName = "NewServer";
            string oldDatabaseName = "OldDatabase";
            string newDatabaseName = "NewDatabase";
            string userID = "MyUserID";
            string password = "MyPassword";

            report.Load(@"C:\My Crystal Reports\Report Name.rpt");

            // Change the server name and database in main reports          
            foreach (CrystalDecisions.Shared.IConnectionInfo connection in report.DataSourceConnections)
            {
                if ((String.Compare(connection.ServerName, oldServerName, true) == 0) &&
                  (String.Compare(connection.DatabaseName, oldDatabaseName, true) == 0))
                {
                    // SetConnection can also be used to set new logon and new database table
                    report.DataSourceConnections[oldServerName, oldDatabaseName].SetConnection(
                      newServerName, newDatabaseName, userID, password);
                }
            }

            // Change the server name and database in subreport
            foreach (CrystalDecisions.CrystalReports.Engine.ReportDocument subReport in report.Subreports)
            {
                foreach (CrystalDecisions.Shared.IConnectionInfo connection in subReport.DataSourceConnections)
                {
                    if ((String.Compare(connection.ServerName, oldServerName, true) == 0) &&
                      (String.Compare(connection.DatabaseName, oldDatabaseName, true) == 0))
                    {
                        // SetConnection can also be used to set new logon and new database table
                        subReport.DataSourceConnections[oldServerName, oldDatabaseName].SetConnection(
                          newServerName, newDatabaseName, userID, password);
                    }
                }
            }


Chk the above code

thanks for ur reply,but what for this code?? wen i run my code at first the error dint occured but hw come when i run second

the error came.

If using Simple Pull method in Crystal report.. U give infomration for local Database from where uR Pulling the Info..

it just Dyncaillly change the Username and Password

any other ways of doing this??

C:\Program Files\Microsoft Visual Studio 8\Crystal Reports\Samples

chk the abelow folder in system it has loads of info on crystal report.