scottpdann
Technical User
It is taking an unbearably long time to read the records for this report. Is there anything I could do better in the record selection formula?
{ARF.SQL_TRANS_DATE} in Date (2005,01,01) to Date (2005, 12,31) and
isnull ({FAMILY.SQL_DEACTIVATION_DATE})and
{ARF.SQL_BILL_CODE} in ["0001"to "0041","0100"to"0299" ,"0331" to "0332","0500" to "0700", "0997" to "0997"] and
({ARF_SQL_ACCT_ASSOC.SQL_CREDIT_ACCT} = "01-00-21100" or {ARF_SQL_ACCT_ASSOC.SQL_DEBIT_ACCT}="01-00-21100" )
Any suggestions would be appreciated.
{ARF.SQL_TRANS_DATE} in Date (2005,01,01) to Date (2005, 12,31) and
isnull ({FAMILY.SQL_DEACTIVATION_DATE})and
{ARF.SQL_BILL_CODE} in ["0001"to "0041","0100"to"0299" ,"0331" to "0332","0500" to "0700", "0997" to "0997"] and
({ARF_SQL_ACCT_ASSOC.SQL_CREDIT_ACCT} = "01-00-21100" or {ARF_SQL_ACCT_ASSOC.SQL_DEBIT_ACCT}="01-00-21100" )
Any suggestions would be appreciated.