StackOverflow2013

Note that there are some explanatory texts on larger screens.

plurals

POcrystal report are not displaying my records
text
Body
copied!<p>I have sap Crystal Report 13 in my application, It is working fine in simple tables, But in specific scenario like: I have a table which loaded via store procedure when i load this table, then report going to be called and after showing the report i clean the table by using delete query. If i comment that query report show record otherwise empty report appears. Please see my code:</p> <pre><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 and Without Of Opening Bal) FROM Store Procedure string Qry = "INSERT INTO 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 up tblReportTrialBalanceWithOpening for Future use. //Qry = "DELETE FROM 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 up tblReportTrialBalanceWithOpening for Future use. //Qry = "DELETE FROM tblReportTrialBalanceWithOpening"; //DatabaseHelper.ExecuteNonQuery(Qry); } MyResources.WaitDialogDispose(); //***** Clean up tblReportTrialBalanceWithOpening for Future use. Qry = "DELETE FROM tblReportTrialBalanceWithOpening"; DatabaseHelper.ExecuteNonQuery(Qry); } } </code></pre> <p>you can see my delete query if i comment it. My report shows record. delete query is must in my case. So please help me i am total scattered. One more thing remember my app was upgraded from 2010 to 2012 visual studio successfully expect this problem.</p>

Querying!

Guidance

An individual column

Larger individual text columns get their own page to allow for proper reading.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload