• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 262
  • Last Modified:

Crystal Report executes slowly on vb.net app using OLE DB

Hi all,
I'm working with vb.net and created crystal report, using ole db provider. Data source for this report is stored procedure built in sql server 2005. Executing report takes about 30 sec, but stored procedure executes in one sec in Database Engine Query (result of procedure is set of 1600 records). When i switch report datasorce to ODBC, report executes in 3 seconds. It doesn't seem to me normall, but that is fact.

If someone know what is problem, please help me. I prefere ole db and would use it, it's newer than odbc.


dragy
0
dragy
Asked:
dragy
  • 2
1 Solution
 
riyazthadCommented:
Are you pulling from datasource directly to report

or

Are you pushing dataset to report.

Second methos may be fast.
0
 
dragyAuthor Commented:
I'm doing this by pushing dataset to report:

Dim cr1 As New CrystalReport1
cr1.SetDataSource(sqlds.Tables("kls_art"))
crviewer.ReportSource = cr1

It seems to me that app is trying to find db server and it takes about thirty seconds. Db server is on the same machine as app is.
I'm using Microsoft OLE DB Provider for SQL Server, it should be the faster way.
0
 
dragyAuthor Commented:
All right,
riyazthad  helped me to find solution.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now