i have sap crystal report 13 in application, working fine in simple tables, in specific scenario like: have table loaded via store procedure when load table, report going called , after showing report clean table using delete query. if comment query report show record otherwise empty report appears. please see code:
private void btnpreview_click(system.object sender, system.eventargs e) { if (iserrorfound() == false) { myresources.waitdialogcreate("loading...."); string formulastring = ""; string parameters = ""; //***** insert data in table naamed tblreporttrialbalancewith (with , without of opening bal) store procedure string qry = "insert tblreporttrialbalancewithopening exec [sptrialbalance] @minfy = '" + globalvriables.fyeardatestart.year.tostring() + "'," + "@maxfy = '" + globalvriables.fyeardateend.year.tostring() + "'," + "@datefrom = '" + myresources.getdatefordb(dtefromdate.text.trim()) + "'," + "@dateto = '" + myresources.getdatefordb(dtetodate.text.trim()) + "'," + "@fromcode = '" + lkpfromcode.text.trim() + "'," + "@tocode = '" + lkptocode.text.trim() + "'," + "@category = '" + rdoacccategory.text.trim() + "'"; databasehelper.executenonquery(qry); if (chkwithoutob.checked == true) { //************* parameters parameters = "companyname=" + globalvriables.companyname + "&startingdate=" + dtefromdate.text + "&endingdate=" + dtetodate.text + "&category=" + (rdoacccategory.selectedindex == 0 ? "all categories" : rdoacccategory.text.trim()) + "&fyear=[" + globalvriables.fyeardatestart.year + "-" + globalvriables.fyeardateend.year + "]"; switch (rdoacccategory.selectedindex) { case 0: parameters = parameters + "&reportcase=0"; break; case 2: parameters = parameters + "&reportcase=2"; break; default: parameters = parameters + "&reportcase=1"; break; } myresources.viewreport("rpttrialbalancewithoutob.rpt", formulastring, parameters); ////***** clean tblreporttrialbalancewithopening future use. //qry = "delete tblreporttrialbalancewithopening"; //databasehelper.executenonquery(qry); } else { //************* parameters parameters = "companyname=" + globalvriables.companyname + "&startingdate=" + dtefromdate.text.trim() + "&endingdate=" + dtetodate.text + "&category=" + (rdoacccategory.selectedindex == 0 ? "all categories" : rdoacccategory.editvalue.tostring()) + "&fyear=[" + globalvriables.fyeardatestart.year + "-" + globalvriables.fyeardateend.year + "]"; switch (rdoacccategory.selectedindex) { case 0: parameters = parameters + "&reportcase=0"; break; case 2: parameters = parameters + "&reportcase=2"; break; default: parameters = parameters + "&reportcase=1"; break; } myresources.viewreport("rpttrialbalance.rpt", formulastring, parameters); ////***** clean tblreporttrialbalancewithopening future use. //qry = "delete tblreporttrialbalancewithopening"; //databasehelper.executenonquery(qry); } myresources.waitdialogdispose(); //***** clean tblreporttrialbalancewithopening future use. qry = "delete tblreporttrialbalancewithopening"; databasehelper.executenonquery(qry); } } you can see delete query if comment it. report shows record. delete query must in case. please me total scattered. 1 more thing remember app upgraded 2010 2012 visual studio expect problem.
Comments
Post a Comment