x Want to participate? Join the group to interact
Options
  • State Not Answered
  • Replies 1 reply
  • Subscribers 19 subscribers
  • Views 2139 views
  • Users 0 members are here
Browse Forums
Announcements
150
topics
113
replies
General Discussion
5k
topics
13k
replies
Payroll & Tax
631
topics
887
replies
Reporting and Analytics
573
topics
1k
replies
Service Alerts
1
topics
0
replies
Software Development Kit (SDK)
434
topics
671
replies
Year End
83
topics
128
replies
sschaller

Use indexes or server for speed

Posted By

I have been finding recently that on certain computers, Crystal Reports will give an error message if I don't uncheck the box “Use indexes or server for speed” in the Report Options.  Unchecking this makes the report run much slower. 

At one client I was able to run the report on about 5 different computers with that box checked, but when I got to the 6th, I got the error message and had to uncheck the box. 

Has anyone else run into this?  Any idea why this might be happening? 

  • 0
    You can try Verify Database, check to see if the SQL Query needs to be reset and make sure the drivers are set up the same on each computer. Likely the latter is the problem.

    from an old help file found online about "Error detected by database driver" error (I don't know if this is the one you had or not)

    "2.Disable the report's "Use Indexes or Server for Speed" option.
    Open the report in Crystal Reports and, on the File menu, click Options. On the Database tab, clear the "Use Indexes or Server for Speed" option. Disabling this option may resolve database driver errors."

*Community Hub is the new name for Sage City