Hi! I used CrystallReport but, it’s show bellow error:
The maximum report processing jobs limit configured by your system administrator has been reached.
After using this code it’s not solved:
CrystalDecisions.CrystalReports.Engine.ReportDocument crystalReport = null;
protected void Page_Load(object sender, EventArgs e)
{
this.crystalReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
crystalReport.Load(Server.MapPath("~/Reports/LoginReport.rpt"));
PersonInformation dsPersonInformations = GetPersonInformations();
crystalReport.SetDataSource(dsPersonInformations);
prLoginInformation.ReportSource = crystalReport;
}
private PersonInformation GetPersonInformations()
{
SqlConnection con = new SqlConnection(UserData);
SqlCommand cmd = con.CreateCommand();
cmd.CommandText = @"select row_number() over(order by AccessID)row,
(select naim_vr from spr_vrch where kod_vr = act)naim,
(select secondname+' '+name+' '+fatherName from Users
where login ='"+ sistem.UserLogin() +"')fio,login from users where type = 'user'";
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
PersonInformation dsPersonInformation = new PersonInformation();
sda.Fill(dsPersonInformation, "LogTable");
return dsPersonInformation;
}
protected void Page_UnLoad(object sender, EventArgs e)
{
if (this.crystalReport != null)
{
this.crystalReport.Close();
this.crystalReport.Dispose();
}
}
Who is you can help me?
