Click here to Skip to main content
15,889,315 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
i am getting error :

The maximum report processing jobs limit configured by your system administrator has been reached."

Having researched the topic online i found some solution,set registry value, specifically HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Report Application Server\InprocServer\PrintJobLimit to "-1" ,but this solution is not working,if i adding crystal report dispose and close function in my code,the crystal report i generated will be empty. Below are my aspx code:


ASP.NET
<asp:DropDownList ID="dllselection"  onchange="javascript:return dropdown(this);" runat="server" Style="border: groove" CssClass="form-control" AutoPostBack="true">
                    <asp:ListItem Text="On Job Training" Value="3"></asp:ListItem>
                    <asp:ListItem Text="Training Effectiveness Form" Value="4"></asp:ListItem>
                </asp:DropDownList>
<asp:Button ID="Button1" runat="server" Text="Generate" CssClass="btn btn-success" OnClick="Button1_Click" />
        <div id="dvReport">
            <CR:CrystalReportViewer ID="CrystalReportViewer1" runat="server" AutoDataBind="true" ToolPanelView="None" EnableDatabaseLogonPrompt="False" PrintMode="Pdf" />
        </div>


C#
<pre lang="C#">protected void Page_Load(object sender, EventArgs e)
    {
        Response.Clear();
        Response.Buffer = true;
        if (IsPostBack)
        {
            if (dllselection.SelectedValue == "3")
            {
                ReportDocument myDataReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
                myDataReport.Load(Server.MapPath("OJT.rpt"));
                myDataReport.SetDatabaseLogon("intranet", "cpgintranet@2016", "192.168.2.5", "INTRANET");
                myDataReport.SetParameterValue("T-ID", TextBox1.Text);
                CrystalReportViewer1.ReportSource = myDataReport;
                CrystalReportViewer1.DataBind();

            }
            else if (dllselection.SelectedValue == "4")
            {
                ReportDocument myDataReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
                myDataReport.Load(Server.MapPath("TEFF.rpt"));
                myDataReport.SetDatabaseLogon("intranet", "cpgintranet@2016", "192.168.2.5", "INTRANET");
                myDataReport.SetParameterValue("T-ID", TextBox1.Text);
                CrystalReportViewer1.ReportSource = myDataReport;
                CrystalReportViewer1.DataBind();


            }
        }
    }

 protected void Button1_Click(object sender, EventArgs e)
    {
        Response.Clear();
        Response.Buffer = true;
if (dllselection.SelectedValue == "3")
            {
                ReportDocument myDataReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
                myDataReport.Load(Server.MapPath("OJT.rpt"));
                myDataReport.SetDatabaseLogon("intranet", "abc@2016", "192.168.2.88", "INTRANET");
                myDataReport.SetParameterValue("T-ID", TextBox1.Text);
                CrystalReportViewer1.ReportSource = myDataReport;
                CrystalReportViewer1.DataBind();

            }
            else if (dllselection.SelectedValue == "4")
            {
                ReportDocument myDataReport = new CrystalDecisions.CrystalReports.Engine.ReportDocument();
                myDataReport.Load(Server.MapPath("TEFF.rpt"));
                myDataReport.SetDatabaseLogon("intranet", "abc@2016", "192.168.2.88", "INTRANET");
                myDataReport.SetParameterValue("T-ID", TextBox1.Text);
                CrystalReportViewer1.ReportSource = myDataReport;
                CrystalReportViewer1.DataBind();


            }
}


What I have tried:

C#
Having researched the topic online i found some solution,set registry value, specifically HKEY_LOCAL_MACHINE\SOFTWARE\Business Objects\Suite 12.0\Report Application Server\InprocServer\PrintJobLimit to &quot;-1&quot; ,but this solution is not working,if i adding crystal report dispose and close function in my code,the crystal report i generated will be empty
Posted

1 solution

You can increase the Job Limit in Crystal Report in Register Edit.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900