c# - crystal report is not showing any data : Error "Function evaluation disabled because a previous function evaluation timed out." -


i new crystal reports. have designed 1 crystal report using google , asp.net forum. after doing coding not able view crystal report after running through visual studio 2010. development environment (windows-7 32 bit,visual studio 2010 ,crystal report v.13). aspx looks below:

<%@ page language="c#" autoeventwireup="true" codefile="reportsapco.aspx.cs" inherits="reportsapco" %>      <%@ register assembly="crystaldecisions.web, version=13.0.2000.0, culture=neutral, publickeytoken=692fbea5521e1304"      namespace="crystaldecisions.web" tagprefix="cr" %>    <!doctype html public "-//w3c//dtd xhtml 1.0 transitional//en" "http://www.w3.org/tr/xhtml1/dtd/xhtml1-transitional.dtd">    <html xmlns="http://www.w3.org/1999/xhtml">  <head id="head1" runat="server">      <title></title>             <link href="8lcksbvehkazoxgjmwviuq==/site.css" rel="stylesheet" type="text/css" />  </head>  <body style="background-color:#e6e6fa;">      <form id="form1" runat="server">              <cr:crystalreportsource id="crystalreportsource1" runat="server">              <report filename="certsreportsapco.rpt">              </report>          </cr:crystalreportsource>              <div>         <cr:crystalreportviewer id="reportviewer" runat="server"               grouptreeimagesfolderurl="" height="1269px"               toolbarimagesfolderurl="" toolpanelwidth="120px" width="100%"               enabledatabaselogonprompt="false" enableparameterprompt="false"               hascrystallogo="false" hastogglegrouptreebutton="false" bestfitpage="false"                 toolpanelview="none" bordercolor="#006699" borderstyle="solid"               borderwidth="2px" hastoggleparameterpanelbutton="false"               reuseparametervaluesonrefresh="true" hassearchbutton="false"               onload="reportviewer_load" reportsourceid="crystalreportsource1" onunload="reportviewer_unload"               />             </div>      </form>  </body>  </html>

and aspx.cs looks below:

using system; using system.collections.generic; using system.linq; using system.web; using system.web.ui; using system.web.ui.webcontrols; using system.configuration; using system.data.sqlclient; using system.data; using system.globalization; using crystaldecisions.web; using crystaldecisions.crystalreports; using crystaldecisions.crystalreports.engine; using crystaldecisions.shared; using crystaldecisions.reportsource;  public partial class reportsapco : system.web.ui.page {     public static readonly string _constr = configurationmanager.connectionstrings["cstr"].tostring();     public static void checkdb()     {         using (var _con = new sqlconnection(_constr))         {             if (_con.state == connectionstate.open)             {                 _con.close();             }         }     }       private dscertssapco getdata(string query)     {         sqlcommand cmd = new sqlcommand(query);         using (sqlconnection con = new sqlconnection(_constr))         {             using (sqldataadapter sda = new sqldataadapter())             {                 cmd.connection = con;                 sda.selectcommand = cmd;                 using (dscertssapco dscustomers = new dscertssapco())                 {                     sda.fill(dscustomers, "tb_newsapcocerts");                     return dscustomers;                 }             }         }     }      protected void homebtn_click(object sender, eventargs e)     {         response.redirect("~/default.aspx");     }      protected void btnshowinfo_click(object sender, eventargs e)     {          string datefrom = string.format("{0}/{1}/01", getcuryear(), ddownmonth.text);         string dateto = string.format("{0}/{1}/31", getcuryear(), ddownmonth.text);         reportdocument rpt = new reportdocument();         rpt.load(server.mappath("certsreportsapco.rpt"));         dscertssapco dscerts = getdata("select suppcode,(select sp_name tb_supplierinfo (sp_code=tb_newsapcocerts.suppcode)) suppname,partno,serialno,code,postedno,(select st_name + ' ' + st_family expr1 tb_staffsinfo where(st_perscode=tb_newsapcocerts.serialexporter)) serialexporter,serialissueddate,id,serialexporter perscode tb_newsapcocerts serialexporter=n'" + int.parse(session["perscode"].tostring()) + "' , suppcode='" + ddownsupp.text + "' , serialissueddate between '" + datefrom + "' , '" + dateto + "' , serialstat<>6 order serialissueddate");         if (dscerts.tables[0].rows.count > 0)         {             rpt.setdatasource(dscerts);             rpt.setparametervalue("karfarma", "ساپکو");             rpt.setparametervalue("mah", ddownmonth.text);             rpt.setparametervalue("personeli", session["perscode"].tostring());             rpt.setparametervalue("persname", session["persname"].tostring());             reportviewer.reportsource = rpt;             reportviewer.databind();         }         else         {             reportdocument rpt2 = new reportdocument();             rpt2.load(server.mappath("certsreportsapco.rpt"));             rpt2.setdatasource("");             rpt2.setparametervalue("karfarma", "");             rpt2.setparametervalue("mah", "");             rpt2.setparametervalue("personeli", "");             rpt2.setparametervalue("persname", "");             reportviewer.reportsource = rpt2;         }      }     protected void sapcoprint_click(object sender, eventargs e)     {         response.redirect("~/reportsaze.aspx");     }     protected void epcoprint_click(object sender, eventargs e)     {         response.redirect("~/reportepco.aspx");     }     protected void reportviewer_load(object sender, eventargs e)     {         string datefrom = string.format("{0}/{1}/01", getcuryear(), ddownmonth.text);         string dateto = string.format("{0}/{1}/31", getcuryear(), ddownmonth.text);          reportdocument rpt = new reportdocument();         rpt.load(server.mappath("~/certsreportsapco.rpt"));         dscertssapco dscerts = getdata("select suppcode,(select sp_name tb_supplierinfo (sp_code=tb_newsapcocerts.suppcode)) suppname,partno,serialno,code,postedno,(select st_name + ' ' + st_family expr1 tb_staffsinfo where(st_perscode=tb_newsapcocerts.serialexporter)) serialexporter,serialissueddate,id,serialexporter perscode tb_newsapcocerts serialexporter=n'" + int.parse(session["perscode"].tostring()) + "' , suppcode='" + ddownsupp.text + "' , serialissueddate between '" + datefrom + "' , '" + dateto + "' , serialstat<>6 order serialissueddate");         if (dscerts.tables[0].rows.count > 0)         {             rpt.setdatasource(dscerts);             rpt.setparametervalue("karfarma", "ساپکو");             rpt.setparametervalue("mah", ddownmonth.text);             rpt.setparametervalue("personeli", session["perscode"].tostring());             rpt.setparametervalue("persname", session["persname"].tostring());             reportviewer.reportsource = rpt;         }         else         {             reportdocument rpt2 = new reportdocument();             rpt2.load(server.mappath("certsreportsapco.rpt"));             rpt2.setdatasource("");             rpt2.setparametervalue("karfarma", "");             rpt2.setparametervalue("mah", "");             rpt2.setparametervalue("personeli", "");             rpt2.setparametervalue("persname", "");             reportviewer.reportsource = rpt2;         }     }     protected void reportviewer_unload(object sender, eventargs e)     {         if (reportviewer != null)         {            reportviewer.reportsource = null;            reportviewer.dispose();         }     } }

i debugged code , found getting below error:

hasrecords = function evaluation disabled because previous function evaluation timed out. must continue execution reenable function evaluation crystal reports

i getting error attributes after hasrecords reportdocument.

i googled , found going in infinite loop or breakpoints should removed solve error.

but observation nothing in infinite loop above mentioned code , removed breakpoints no luck.

will me solve error not able see crystal report after running code.

i getting blank page , getting error reportdocument.

i set "printjoblimit" property in registry = 250 , enable 32-applications on application pool in iis = true

the reasons of hang , of error message same: there takes lot of time compute. both when in code , in debugger.
seems kind of bug can happen when trying watch @ variables have thread safe framework implementation not perfect....
in case "hasrecords" doesn't appear in code, suppose watch window causes problem.

to avoid problem : when stepping through code variables bound windows or other controls, don't show local variables or "auto" variables. @ such things when sure variables safe at. , note error doesn't appear on unsafe variables. use "immediate" window on safe (i.e. non-control) variables when operating in dangerous code.


Comments

Post a Comment

Popular posts from this blog

Sort a complex associative array in PHP -

this question has answer here: php sort array subarray value 5 answers i have associative array in php like: $newarray1 = array ( [producta] => array ( [link] => http://sanjosespartan.com/blog/products/agile-java-development/ [visitcount] => 4 ) [productd] => array ( [link] => http://sanjosespartan.com/blog/products/intro-to-go/ [visitcount] => 1 ) [productg] => array ( [link] => http://sanjosespartan.com/blog/products/node-js-for-developers/ [visitcount] => 1 ) [productb] => array ( [link] => http://sanjosespartan.com/blog/products/beginning-mysql/ [visitcount] => 1 ) [productc] => array ( [link] => http://sanjosespartan.com/blog/products/computer-networks/ [visitcount] => 1 ) ...
Read more

vb.net - How to ignore if a cell is empty nothing -

how use roscolor() ignore value (like empty cell) ? color row if value upper 5 when there nothing in cell, want ignore roscolor() apply, how? public sub roscolor() integer = 0 quotedatagridview1.rows.count() - 1 step +1 dim val integer val = quotedatagridview1.rows(i).cells(3).value if val = vbempty quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.white elseif val < 5 quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.red elseif val > 5 , val < 10 quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.lightyellow end if next end sub you can check empty value following public sub roscolor() integer = 0 quotedatagridview1.rows.count() - 1 step +1 dim val = quotedatagridview1.rows(i).cells(3).value if isdbnull(val) or val nothing quotedatagridview1.rows(i).defaultcellstyle.backcolor = color.white ...
Read more

recursion - Can every recursive algorithm be improved with dynamic programming? -

i first year undergraduate csc student looking competitive programming. recursion involves defining , solving sub problems. understand, top down dynamic programming (dp) involves memoizing solutions sub problems reduce time complexity of algorithm. can top down dp used improve efficiency of every recursive algorithm overlapping sub problems? dp fail work , how can identify this? the short answer is: yes. however, there constraints. obvious 1 recursive calls must overlap. i.e. during execution of algorithm, recursive function must called multiple times same parameters. lets truncate recursion tree memoization. can use memoization reduce number of calls. however, reduction of calls comes price. need store results somewhere. next obvious constraint need have enough memory. comes not-so obvious constraint. memory access requires time. first need find result stored , maybe copy location. in cases, might faster let recursion calculate result instead of loading somewher...
Read more