public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport rpt = new CrystalReport();
rpt.Site = this.Site;
return(rpt);
}
private void Report_Load(object sender, EventArgs e)
{
CrystalReport rpt = new CrystalReport();
SqlConnection conn = new SqlConnection("Data Source=.\\SORIMACHI2012;Initial Catalog=LibraryManager;Integrated Security=True");
conn.Open();
SqlDataAdapter dap = new SqlDataAdapter("SELECT rent.*, re.*, a.UserName AS 'Customer', a2.UserName AS 'Employee', b.Name FROM dbo.BookReturn AS re INNER JOIN dbo.BookRental AS rent ON re.IdBookRental = rent.Id INNER JOIN dbo.Account AS a ON a.Id = rent.IdAccount INNER JOIN dbo.Account AS a2 ON a2.Id = re.IdEmployeeAccount INNER JOIN dbo.Book AS b ON b.Id = rent.IdBook", conn);
DataSet ds = new DataSet();
dap.Fill(ds);
rpt.SetDataSource(ds.Tables[0]);
crystalReportViewer1.ReportSource = rpt;
}
