Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

Troubleshooting
Research
Professional Opinions
Ask a Question
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE

troubleshooting Question

Crystal Reports SQL Timeout Issue

Avatar of netsmithcentral
netsmithcentralFlag for United States of America asked on
Crystal Reports
7 Comments1 Solution7811 ViewsLast Modified:
I'm not sure whether to ask this as an independent question or a pointer.  It's related to the question at https://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_22088714.html?qid=22088714 , but it's not really the same question.  An ASP.NET appliction I'm trying to repair (it was not built by me nor do I have any decent documentation/source code for it) is returning a Timeout error right now.

The page is ReportViewer.aspx (which looks like it might be a standard CrystalDecisions/CrystalReports page) and it displays any report requested.  Certain reports are returning timeout (regardless of the data you try to populate them with).  I used Crystal Reports to pull the SQL query the report is running and ran it against my database in SQL Query Analyzer.  Not only does it work perfectly, it only takes approximately 12 seconds to complete (default timeout is 30 seconds).

I don't entirely understand how CrystalReports gets its data or returns it so I'm not really sure where to go from here.  If there's anything I can post to help you help me, please ask!
ASKER CERTIFIED SOLUTION
Avatar of frodoman
frodomanFlag of United States of America image

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Commented:
This problem has been solved!
Unlock 1 Answer and 7 Comments.
See Answers