string connectionString = TimestampHelper.ParseConnectionString(sesja.Connection.ConnectionString);

                //this.crystalReportViewer1.re



                System.Data.Common.DbConnectionStringBuilder builder = new System.Data.Common.DbConnectionStringBuilder();

                builder.ConnectionString = connectionString;

                string server = builder["Server"] as string;

                string database = builder["Database"] as string;

                string userid = "";

                string password = "";





                if (connectionString.Contains("User ID"))

                {

                    userid = builder["User ID"] as string;

                    password = builder["Password"] as string;

                }



                string sciezka = @"C:\Wydruk zlecenia.RPT";



                ReportDocument rd = new ReportDocument();



                rd.Load(sciezka);



                ConnectionInfo conInfo = new ConnectionInfo();

                if (userid == "")

                {

                  //  rd.SetDatabaseLogon(server, database);

                    conInfo.DatabaseName = database;

                    conInfo.ServerName = server;

                    conInfo.IntegratedSecurity = true;

                }

                else

                {

                    //rd.SetDatabaseLogon(userid, password, server, database);

                    conInfo.DatabaseName = database;

                    conInfo.ServerName = server;

                    conInfo.IntegratedSecurity = false;

                    conInfo.UserID = userid;

                    conInfo.Password = password;

                }



                //if (userid == "")

                //    rd.Subreports[0].SetDatabaseLogon(server, database);

                //else

                //    rd.Subreports[0].SetDatabaseLogon(userid, password, server, database);



                Tables CrTablice = rd.Database.Tables;

                foreach (Table CrTabela in CrTablice)

                {

                    TableLogOnInfo tloi = new TableLogOnInfo();

                    tloi.ConnectionInfo = conInfo;



                    CrTabela.ApplyLogOnInfo(tloi);

                    CrTabela.Location.Substring(CrTabela.Location.LastIndexOf(".") + 1);

                }

              



                this.crystalReportViewer1.ReportSource = rd;

                ReportDocument cryRpt = new ReportDocument();

                TableLogOnInfos crtableLogoninfos = new TableLogOnInfos();

                TableLogOnInfo crtableLogoninfo = new TableLogOnInfo();

                ConnectionInfo crConnectionInfo = new ConnectionInfo();

                cryRpt.Load(sciezka);



                if (userid == "")

                    cryRpt.SetDatabaseLogon(server, database);

                else

                    cryRpt.SetDatabaseLogon(userid, password, server, database);



                DataTable dtSrsZlecenia = DB.SrsZlecenia(sesja.Connection.ConnectionString);

                cryRpt.Database.Tables["SrsZlecenia"].SetDataSource(dtSrsZlecenia);

                

                DataTable dtSrsUrzadzenia = DB.SrsUrzadzeniaRaport(sesja.Connection.ConnectionString);

                cryRpt.Database.Tables["SrsUrzadzenia"].SetDataSource(dtSrsZlecenia);

    



                DataTable dtKontrahenci = DB.KontrahenciRaport(sesja.Connection.ConnectionString);

                cryRpt.Database.Tables["Kontrahenci"].SetDataSource(dtKontrahenci);



                DataTable dtCzesci = DB.SrsCzesciRaport(sesja.Connection.ConnectionString);

                cryRpt.Database.Tables["SrsCzesci"].SetDataSource(dtCzesci);



                this.crystalReportViewer1.ReportSource = cryRpt;