public virtual CrystalDecisions.CrystalReports.Engine.ReportDocument CreateReport()
{
CrystalReport3 rpt = new CrystalReport3();
rpt.Site = this.Site;
return(rpt);
}
private void button2_Click(object sender, EventArgs e)
{
if (bunifuDropdown1.selectedValue == "")
{
MessageBox.Show("You should complete information");
}
else
{
connection = new OracleConnection(con);
connection.Open();
cmd = new OracleCommand("select RESNAME from ADMINS where EMAIL='" + log_in.User_Email + "'", connection);
cmd.CommandType = CommandType.Text;
OracleDataReader reader = cmd.ExecuteReader();
CrystalReport3 CR = new CrystalReport3();
string resname = "";
while (reader.Read())
{
resname = reader[0].ToString();
}
reader.Close();
CR.SetParameterValue(0, bunifuDropdown1.selectedValue.ToString().Split(' ')[0]);
CR.SetParameterValue(1, bunifuDropdown2.selectedValue);
CR.SetParameterValue(2, resname);
crystalReportViewer1.ReportSource = CR;
connection.Close();
}
}
