Slow in displaying Crystal report
-
Hi, I am using CrystalReport XI-R2, in my application. I have used a Types Dataset and DataTables in the report. Data retrieved from querry has been added in the DataTable and in the report the DataSource of the report has been set that DataTable. This report displays values correctly. There are nearly 5 custom querries and 3 Subreports in the report. The problem is that in the display of report it is displayed nearly after 1 minutes which is very slow in my requirement. Please suggest me, what is its solution.
-
Hi, I am using CrystalReport XI-R2, in my application. I have used a Types Dataset and DataTables in the report. Data retrieved from querry has been added in the DataTable and in the report the DataSource of the report has been set that DataTable. This report displays values correctly. There are nearly 5 custom querries and 3 Subreports in the report. The problem is that in the display of report it is displayed nearly after 1 minutes which is very slow in my requirement. Please suggest me, what is its solution.
Please Check the following: 1) Which DB you are using. 2) Are you retrieving the data in Network 3) Is that Windows application or Web application Check where is the actual delay Is that in binding ? Is that in Fetching ? then you can get some idea.
-
Please Check the following: 1) Which DB you are using. 2) Are you retrieving the data in Network 3) Is that Windows application or Web application Check where is the actual delay Is that in binding ? Is that in Fetching ? then you can get some idea.
I have used Oracle10g Database. Yes is retrieved by client side from server. This is windows application. In my report In crystal report oracle Database is not connected. used Dataset and DataTable. my coding pattern is like this. private void btnTestReceipt_Click(object sender, EventArgs e) { ReportDocument rptdmt=new ReportDocument(); DataTable dtr=GetDatas(); string ReportName = Application.StartupPath + "\\Reports\\rptCashReceiptPP.rpt"; rptdmt.Load(ReportName); rptdmt.SetDataSource(dtr); CrystalReportViewer.ReportSource = rptdmt; } private DataTable GetDatas() { StringBuilder sb=new StringBuilder(); sb.Append("SELECT *from TableName WHERE CONDITION"); DataTable dt=_con.ExecuteDataTable(sb.ToString()); DsDataSet.UserDataTable dtrep=new DsDataSet.UserDataTable(); //This is object of DataTable of Typed Dataset named DsDataset. foreach(DataRow dr in dt.Rows) { dtrep.Rows.Add(dr.ItemArray); } dtrep.AcceptChanges(); return dtrep; }