public void ReportEngine(string rptNm, string OderID) { using (dbDatabaseDataDataContext db = new dbDatabaseDataDataContext()) { //int sample = int.Parse(Request.QueryString["ApplicationId"]); crReportDocument = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); crReportDocument.Load(Server.MapPath(rptNm)); //crReportDocument.Refresh(); ConnectionInfo connectionInfo = new ConnectionInfo(); connectionInfo.DatabaseName = ConfigurationManager.AppSettings["DBaseName"]; connectionInfo.UserID = ConfigurationManager.AppSettings["DBUserName"]; connectionInfo.Password = ConfigurationManager.AppSettings["DBPassword"]; connectionInfo.ServerName = ConfigurationManager.AppSettings["DBServerName"]; CrTables = crReportDocument.Database.Tables; connectionInfo.Type = ConnectionInfoType.SQL; TableLogOnInfo tableLogOnInfo = new TableLogOnInfo(); tableLogOnInfo.ConnectionInfo = connectionInfo; crReportDocument.DataSourceConnections[0].SetConnection(tableLogOnInfo.ConnectionInfo.ServerName, tableLogOnInfo.ConnectionInfo.DatabaseName, tableLogOnInfo.ConnectionInfo.UserID, tableLogOnInfo.ConnectionInfo.Password); int GrocerID = int.Parse((Session["GrocId"]).ToString()); crReportDocument.SetParameterValue("@CustOdrID", OderID); crReportDocument.SetParameterValue("@GrocerId", GrocerID); if (System.IO.File.Exists(Server.MapPath("~/DownloadApplication/ItemLIst" + ".pdf"))) { System.IO.File.Delete(Server.MapPath("~/DownloadApplication/ItemLIst" + ".pdf")); } crReportDocument.ExportToDisk(ExportFormatType.PortableDocFormat, Server.MapPath("~/DownloadApplication/ItemLIst" + ".pdf")); ViewState["ApplicationPath"] = "~/DownloadApplication/ItemLIst" + ".pdf"; FilePath1 = Server.MapPath(ViewState["ApplicationPath"].ToString()); System.Net.WebClient User = new System.Net.WebClient(); byte[] FileBuffer = User.DownloadData(FilePath1); if ((FileBuffer != null)) { Response.ContentType = "application/pdf"; Response.AddHeader("content-length", FileBuffer.Length.ToString()); Response.BinaryWrite(FileBuffer); } Response.Redirect(ViewState["ApplicationPath"].ToString()); } }
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { var Entity = new RTMEntities(); var report = new RTM.Report.GenralRep.Contractors_(); ////////Login Info ConnectionInfo crConnection = new ConnectionInfo(); crConnection.ServerName = @"GIS-SERVER"; crConnection.DatabaseName = "ratec"; crConnection.UserID = "ratec"; crConnection.Password = "******"; CrystalDecisions.CrystalReports.Engine.Tables tables = report.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables) { CrystalDecisions.Shared.TableLogOnInfo tableLogonInfo = table.LogOnInfo; tableLogonInfo.ConnectionInfo = crConnection; table.ApplyLogOnInfo(tableLogonInfo); } //////// //report.SetDatabaseLogon("ratec", "ratec"); var result = (from items in MyList select new cc { CompanyName = items.CompanyName != null?(string)items.CompanyName:"-", NationalIdNumber = items.NationalIdNumber != null ? (string)items.NationalIdNumber : "-", CompanyType = items.CompanyType != null ? (string)items.CompanyType : "-", Telephone = items.Telephone != null?(string)items.Telephone:"-", Fax = items.Fax != null?(string)items.Fax:"-", CeoEmailAddress = items.CeoEmailAddress != null?(string)items.CeoEmailAddress:"-", CompanyField1 = items.CompanyField1 != null?(string)items.CompanyField1:"-", CompanyBase1 = items.CompanyBase1 != null?(int)items.CompanyBase1:5, Design = items.Design != null?(bool)items.Design:false, Procurement = items.Procurement != null?(bool)items.Procurement:false, BuildAndOperation = items.BuildAndOperation != null?(bool)items.BuildAndOperation:false, Finance = items.Finance != null?(bool)items.Finance:false, ContractorId = (int)items.ContractorId, }).ToList(); report.SetDataSource(result); crystalReportsViewer1.ViewerCore.ReportSource = report; }
public static void LogonReport(CrystalDecisions.CrystalReports.Engine.ReportDocument reportdocument) { System.Data.SqlClient.SqlConnectionStringBuilder con = new System.Data.SqlClient.SqlConnectionStringBuilder(); con.ConnectionString = ConfigurationManager.ConnectionStrings["SPDDevConnectionString"].ConnectionString; CrystalDecisions.Shared.ConnectionInfo consinfo = new CrystalDecisions.Shared.ConnectionInfo(); consinfo.ServerName = con.DataSource; consinfo.UserID = con.UserID; consinfo.DatabaseName = con.InitialCatalog; consinfo.Password = con.Password; consinfo.Type = CrystalDecisions.Shared.ConnectionInfoType.SQL; CrystalDecisions.CrystalReports.Engine.Tables myTables = reportdocument.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table myTable in myTables) { CrystalDecisions.Shared.TableLogOnInfo myTableLogonInfo = myTable.LogOnInfo; myTableLogonInfo.ConnectionInfo = consinfo; myTable.ApplyLogOnInfo(myTableLogonInfo); } }
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { var report = new RTM.Report.GenralRep.WebDocRecieve(); //report.SetDatabaseLogon("ratec", "ratec"); ConnectionInfo crConnection = new ConnectionInfo(); crConnection.ServerName = @"GIS-SERVER"; crConnection.DatabaseName = "ratec"; crConnection.UserID = "ratec"; crConnection.Password = "******"; CrystalDecisions.CrystalReports.Engine.Tables tables = report.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables) { CrystalDecisions.Shared.TableLogOnInfo tableLogonInfo = table.LogOnInfo; tableLogonInfo.ConnectionInfo = crConnection; table.ApplyLogOnInfo(tableLogonInfo); } foreach (TenderingFileDownload t in MyList) { t.PersianDate = DateConverter.ConvertDate(t.date); } report.SetDataSource(MyList); crystalReportsViewer1.ViewerCore.ReportSource = report; }
private void crystalReportsViewer1_Loaded(object sender, RoutedEventArgs e) { var Entity = new RTMEntities(); ////////Login Info ConnectionInfo crConnection = new ConnectionInfo(); crConnection.ServerName = @"Gis-Server"; crConnection.DatabaseName = "ratec"; crConnection.UserID = "ratec"; crConnection.Password = "******"; //crConnection.ServerName = @"."; //crConnection.DatabaseName = "ratec"; //crConnection.UserID = "sa"; //crConnection.Password = "******"; CrystalDecisions.CrystalReports.Engine.Tables tables = report.Database.Tables; foreach (CrystalDecisions.CrystalReports.Engine.Table table in tables) { CrystalDecisions.Shared.TableLogOnInfo tableLogonInfo = table.LogOnInfo; tableLogonInfo.ConnectionInfo = crConnection; table.ApplyLogOnInfo(tableLogonInfo); } //////// var x = (from n in Entity.OrganizationalCharts where n.ChartNodeId == CurrentContract.SupervisingUnitHigher select n).FirstOrDefault(); CalculateExtrasContract(); //report.SetDatabaseLogon("ratec", "ratec"); report.SetParameterValue("ContractId", CurrentContract.Contractid); report.SetParameterValue("DraftId", CurrentDraft.PaymentDraftId); report.SetParameterValue("Date", DateConverter.ConvertDate((DateTime)(((CurrentContract.ContractDate).Value).Date)).Substring(4)); if (Convert.ToString(CurrentDraft.PayableAmount) != string.Empty) { report.SetParameterValue("Amount", CurrentDraft.PayableAmount); } else { report.SetParameterValue("Amount", 0); } if (x != null) { report.SetParameterValue("Supervisor", x.Title); } else { report.SetParameterValue("Supervisor", "-"); } ////////////////////////////////////////////////////////////////////////// you have a problem here in your code decimal B; if (CurrentDraft.EmployerInsurancePercentage != 0 || CurrentDraft.EmployerInsurancePercentage != null) { B = ((((decimal)CurrentDraft.CurrentSituationDraft) - ((decimal)CurrentDraft.PerviousSituationDraft)) * (((decimal)(CurrentDraft.EmployerInsurancePercentage)) / 100)); } else { B = ((((decimal)CurrentDraft.CurrentSituationDraft) - ((decimal)CurrentDraft.PerviousSituationDraft))); } report.SetParameterValue("Bimeh", B); report.SetParameterValue("HaveTrans", HaveTrans); // added by naseri PNumberTString dd = new PNumberTString(); decimal Subtract = (((decimal)CurrentDraft.CurrentSituationDraft) - ((decimal)CurrentDraft.PerviousSituationDraft)); report.SetParameterValue("Subtract", Subtract); try { report.SetParameterValue("NumToWord", dd.num2str(Convert.ToString(Convert.ToInt64(CurrentDraft.PayableAmount)))); } catch (Exception) {} if (!HaveTrans) { report.SetParameterValue("User", string.Empty); } // added by naseri crystalReportsViewer1.ViewerCore.ReportSource = report; }