Performance Issue

[Jan_M_Socorro_(Guest)]

Iam using:__R&R Report SQL Writer Version 8.1.__VB.NET 2008.__SQL Server 2000.__ODBC.____Example Report 1: List Projects__It has 3 joins, like 10 calculated fields and a couple of conditions on the filter____Execution Time: GOOD__--------------------------------------------__Example Report 2: Report on X Material__It has 6 joins, like 50 calculated fields and like 10 filter conditions____Execution Time: Too long and the report close itself.____Questions:__What are the best practices to increase performance in this situations?.

[kfleming]

Do a Database Show SQL on the bad report and look at the WHERE __clause. Does it include all of your filter conditions or is some of the work being done locally?__If the filter includes any conditions that cannot be passed to the WHERE, then the report will run more slowly.____Kathleen __R&R Support