Report running ties up Server

[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

[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

[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.