public static void Main(string[] args) { ReportCreation oReportCreation = new ReportCreation(); DbCon CSDB = new DbCon(); DataTable myDataset = new DataTable(); myDataset = CSDB.Execute_Of_Query_Function_dataSet("Exec sp_tblFiles_Selct"); if (myDataset.Rows.Count > 0) { for (int i = 0; i < myDataset.Rows.Count; i++) { oReportCreation.LoadDataTable(@"" + myDataset.Rows[i]["vchrPath"].ToString() + "", myDataset.Rows[i]["vchrFileName"].ToString(), Convert.ToInt32(myDataset.Rows[i]["intFileSerial"]), Convert.ToInt32(myDataset.Rows[i]["intProjectSerial"])); } } }
public ActionResult Report(ReportCreation c) { if (c.select == "Monthly salary Given to staff") { ReportDocument rd = new ReportDocument(); SqlConnection con = new SqlConnection(constr); con.Open(); SqlDataAdapter ada = new SqlDataAdapter("select Staff.Username,Staff.Contact,staff.Email,Staff.Address,Salary.SalaryAmount,Salary.Bonus from staff join Salary on Staff.Id=Salary.StaffId where MONTH(Salary.Month) = MONTH(GETDATE())", con); DataSetSalry dat = new DataSetSalry(); DataTable T = new DataTable(); ada.Fill(T); dat.Tables[0].Merge(T, true, MissingSchemaAction.Ignore); rd.Load(System.IO.Path.Combine(Server.MapPath("~/Report"), "Salaryreposrt.rpt")); rd.SetDataSource(dat); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { System.IO.Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, System.IO.SeekOrigin.Begin); return(File(stream, "salary/pdf", "staff_salary.pdf")); } catch { return(RedirectToAction("Report")); } } else if (c.select == "yearly Report of salary") { ReportDocument rd = new ReportDocument(); SqlConnection con = new SqlConnection(constr); con.Open(); SqlDataAdapter ada = new SqlDataAdapter("select staff.Username,Salary.SalaryAmount,Salary.Bonus,Salary.[Month],Year(Salary.[Month]) as [Year]from Staff join Salary on Staff.Id=Salary.StaffId group by YEAR(Salary.[Month]),Staff.Username,Salary.SalaryAmount,Salary.Bonus,Salary.Month", con); yearlydata dat = new yearlydata(); DataTable T = new DataTable(); ada.Fill(T); dat.Tables[0].Merge(T, true, MissingSchemaAction.Ignore); rd.Load(System.IO.Path.Combine(Server.MapPath("~/Report"), "yearlyReport.rpt")); rd.SetDataSource(dat); Response.Buffer = false; Response.ClearContent(); Response.ClearHeaders(); try { System.IO.Stream stream = rd.ExportToStream(CrystalDecisions.Shared.ExportFormatType.PortableDocFormat); stream.Seek(0, System.IO.SeekOrigin.Begin); return(File(stream, "salary/pdf", "yearlyf_salary.pdf")); } catch { return(RedirectToAction("Report")); } //MessageBox.Show(dat.Tables[0].Rows.Count.ToString()); /* rpt.Load(@"C:\Users\FINEC\Documents\Visual Studio 2015\Projects\databaseproject\databaseproject\CrystalReport1.rpt"); * rpt.SetDataSource(dat); * crystalReportViewer1.ReportSource = rpt;*/ } return(View()); }