Hello ,
In Windows Application, I hv to show 1 Lakh Records in Crystal Report at a time (these Records comes after all where condition in SQL).
Filltable (ds.Tables["DataTable"],SQL);
CrystalReport1.SetDataSource(ds); crvReportViewer.ReportSource = objCrystalReport1;
All coding lines executes with in 25 Sec.
After that Report takes too much time to show Report.
What could be the cause ??
I have not included Subreport, Page N of M .
Only Grouping , Summary field are there .
Report does not come after 1 hour in PC with Win7 with 4 gb RAM & SQL 2008.
Also I can't debug the application bcoz all lines executes successfully.
Is there any way we can show partial pages from all data ?
Regards,
Yogesh
Loading

Vilas GitePosted May 14, 2011, 7:47 AM
Are you using crystal report on sql table directly?
if yes, then please try to bind crystal report on store procedure. It may be helpful for your problem.
please check: Build Crystal report on Store procedure.
http://www.c-sharpcorner.com/UploadFile/73ba73/7161/?ArticleID=63b40f15-b9a8-4e27-a4f1-0625b4be4c55