public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
crTransactions rpt = new crTransactions();
rpt.Site = this.Site;
return(rpt);
}
private void frmTran_Load(object sender, EventArgs e)
{
crTransactions cr = new crTransactions();
SqlConnection cn;
SqlDataAdapter da;
DataSet ds = new DataSet();;
string conS = "data source=(local);initial catalog=Library;Integrated security=SSPI";
cn = new SqlConnection(conS);
string selectsql = "select TransactionID as TransactionID1,TransactionID.MemberID,BookID,LoanStatus,MemberName" +
" from TransactionID left join Members on TransactionID.MemberID=Members.MemberID";
da = new SqlDataAdapter(selectsql, cn);
da.Fill(ds, "TransactionID");
cr.SetDataSource(ds.Tables["TransactionID"]);
cRVtran.ReportSource = cr;
}
