public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReportCurrentLendings rpt = new CrystalReportCurrentLendings();
rpt.Site = this.Site;
return(rpt);
}
private void PrintCurrentLendings_Load(object sender, EventArgs e)
{
// TODO: This line of code loads data into the 'sbmsDataSet.current_lending_history' table. You can move, or remove it, as needed.
try
{
//added created date as filter of todays eneter slides
String query = " SELECT * from current_lending c inner join slides as s on s.id = c.slide_id inner join donors as d on d.id = s.donor_id inner join contacts as b on b.id = c.borrower_id inner join species_specifics as ss on ss.id = d.species_specific_id inner join species_category as sc on sc.id = d.species_catgeroy_id inner join species_stages as st on st.id = d.species_stage_id inner join density_category as dc on dc.id = d.density_category_id WHERE c.isHistory = 0 and c.reason <> 'Exchange' and isDefault=0 and b.isExchange=0;";
SqlDataAdapter dataAdapter = new SqlDataAdapter(query, DBConnectionSingltonServices.GetConnection());
dataAdapter.SelectCommand.CommandText = query;
DataTable sqldatatable = new DataTable();
dataAdapter.Fill(sqldatatable);
CrystalReportCurrentLendings crystalReportCurrentLending = new CrystalReportCurrentLendings();
crystalReportCurrentLending.Database.Tables["checkedout_slides_details"].SetDataSource(sqldatatable);
crystalReportViewer1.ReportSource = crystalReportCurrentLending;
}
catch (Exception ex)
{
logger.Error(ex, "All Borrowed Report generation has some expections");
}
}
