.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
 
Sign In
Register
 
Win Surprise Gifts!!!
Congratulations!!!


Top 5 Contributors of the Month
david stephan

Home >> Forum >> ASP.Net >> Post New QuestionBookmark and Share Subscribe to Forum

crystal reports in asp.net

Posted By: sheeba     Posted Date: April 24, 2011    Points:5   Category :ASP.Net
Hi

i want to display 2000 records in crystal reports.but if i run that record it gets slower and did not display the result...how can i do that?

I wrote query like this;

oitem.open();

Ada = new OleDbDataAdapter("SELECT DISTINCT A.FEATNO AS SNO,A.MEASUREMENT AS MEASUREFEATURE,A.NOMINAL_DIMENSION AS NOMINALVALUE,A.NOMINAL_PLUS AS NPLUS,A.NOMINAL_MINUS AS NMINUS,B.ACTUAL_DIMENSION AS ACTVALUE,B.DEVIATION AS DEVIATION,B.OUT_OF_TOLERENCE AS OUTOFTOLERANCE,B.REMARKS AS REMARKS FROM FEATURES A JOIN DETAIL B ON A.FEATNO=B.SNO WHERE B.BATCH_CODE='" + Batch_Code + "'", oitem.con);
Ada.Fill(ds, "FEATUREDETAILS");

oitem.close();

This query returns 1799 records...

and this foll.. query returs 999 records

Ada = new OleDbDataAdapter("SELECT QAE_INSP AS QAEINSP,STATUS,MACHINES,'" + terminal + "' AS TERMINAL,'" + Uname + "' AS OPERATORID,IRFNO,'" + compnm + "' AS ME,PARTNO,TO_CHAR(MDATE,'dd/mm/yyyy') AS MEASUREDSTART,'" + batchno + "' AS BATCHNO,'" + batch_started + "' AS BATCHSTARTED,CASE VIS_INSP WHEN 0 THEN 'ACCEPTED' ELSE 'REJECTED' END AS VISUALINSP FROM HEADER WHERE BATCH_CODE='" + Batch_Code + "' AND STATUS='" + ReportName + "' ORDER BY PARTNO ASC", oitem.con);
Ada.Fill(ds, "DETAILPARTSTATUS");


now i want to display these whole to crystal reports..but its too slow and did not display...

help me...

thanks in advance


Responses
Author: Kannan C S             
Posted Date: April 24, 2011     Points: 20   

Hi Sheeba,

did you got any errors during loading the report...?

Thanks,
kannan


Author: sheeba             
Posted Date: April 25, 2011     Points: 20   

Hi Kannan

i cant get the issue.bcz its loading max 5 mins.so other process also hang.so i just close that.

Author: Kannan C S             
Posted Date: April 25, 2011     Points: 20   

Hi Sheeba,

Normaly 1999 records is not a big deal for crystal reports.i think it should be some other issue.can you please extend the executiontime for retreiving the data,put your code in try cath .wait for the result or until the error message is coming.If not you please attach your code ..

thanks
kannan






Post Reply

You must Sign In To post reply
 
 
Find more Forum Questions on C#, ASP.Net, Vb.Net, SQL Server and more Here
Quick Links For Forum Categories:
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  OOPs  SilverlightIISJQuery
JavaScript/VBScriptBiztalkWPFPatten/PracticesWCFOthers
www.DotNetSpark.comUnAnsweredAll

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend