public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport3 rpt = new CrystalReport3();
rpt.Site = this.Site;
return(rpt);
}
private void frm18Viewer3_Load(object sender, EventArgs e)
{
String cnS = "data source=(local);initial catalog=Galaxy;integrated security=SSPI;";
SqlConnection cn = new SqlConnection(cnS);
SqlCommand cm = new SqlCommand("Select * from Transactions", cn);
SqlDataAdapter da = new SqlDataAdapter(cm);
SqlCommandBuilder cmb = new SqlCommandBuilder(da);
DataSet ds = new DataSet();
da.Fill(ds, "Transactions");
CrystalReport3 cr = new CrystalReport3();
int c = 0;
c = ds.Tables["Transactions"].Rows.Count;
SqlCommand cm1 = new SqlCommand("select Transactions.TransactionID, Transactions.MemberID, Transactions.BookID, Transactions.IssueDate, Transactions.DueDate from Transactions where Transactions.TransactionID ='" + c + "'", cn);
SqlDataAdapter da1 = new SqlDataAdapter(cm1);
SqlCommandBuilder cmb1 = new SqlCommandBuilder(da1);
DataSet ds1 = new DataSet();
da1.Fill(ds1, "Transactions");
cr.SetDataSource(ds1.Tables["Transactions"]);
crystalReportViewer1.ReportSource = cr;
}
