Page 1 of 1
Report running ties up Server
Posted: Tue May 24, 2005 1:53 pm
by Smzemke_(Guest)
When I print a particular report, it sorts through every last piece of data in our database, and filters out what I need according the the filter I set. When it does this, it ties up the database server, and people who our using our front end software experience delays and hang-ups.____Is there anyway to stop this from happening?____As always, thanks for your help
=> RE: Report running ties up Server
Posted: Tue May 24, 2005 2:01 pm
by kfleming
There must be something in your filter that is being evaluated locally rather than being passed to the SQL SELECT as a WHERE clause. What is in your filter?____Kathleen__R&R Support
==> RE: Report running ties up Server
Posted: Tue May 24, 2005 2:40 pm
by Smzemke_(Guest)
The filters I have are:____1) Invoice date in the range: XX/XX/XX to XX/XX/XX____2) And then another filter when it filters out invoices according to whether or not they fall within a margin % range.