Hi,
Why is Crystal not passing the below record selection formula to SQL under "Show SQL Query"? I want all the OR's to be processed on the server...
(
{TPTY_A_NEW.APTYNAM} <> {TPTY_A_OLD.APTYNAM} or
{TPTY_A_NEW.APTYABB} <> {TPTY_A_OLD.APTYABB} or
{TPTY_A_NEW.APTYDSC} <> {TPTY_A_OLD.APTYDSC} or
{TPTY_A_NEW.APTYSTA} <> {TPTY_A_OLD.APTYSTA} or
{TPTY_A_NEW.AACCINIEMPCDE} <> {TPTY_A_OLD.AACCINIEMPCDE} or
{TPTY_A_NEW.AACCMGREMPCDE} <> {TPTY_A_OLD.AACCMGREMPCDE} or
{TPTY_A_NEW.ACLTIND} <> {TPTY_A_OLD.ACLTIND} or
{TPTY_A_NEW.AOURAGTIND} <> {TPTY_A_OLD.AOURAGTIND} or
{TPTY_A_NEW.ASTKBRKIND} <> {TPTY_A_OLD.ASTKBRKIND} or
{TPTY_A_NEW.AAGTIND} <> {TPTY_A_OLD.AAGTIND} or
{TPTY_A_NEW.AISSIND} <> {TPTY_A_OLD.AISSIND}
)
Thanks,
John
Why is Crystal not passing the below record selection formula to SQL under "Show SQL Query"? I want all the OR's to be processed on the server...
(
{TPTY_A_NEW.APTYNAM} <> {TPTY_A_OLD.APTYNAM} or
{TPTY_A_NEW.APTYABB} <> {TPTY_A_OLD.APTYABB} or
{TPTY_A_NEW.APTYDSC} <> {TPTY_A_OLD.APTYDSC} or
{TPTY_A_NEW.APTYSTA} <> {TPTY_A_OLD.APTYSTA} or
{TPTY_A_NEW.AACCINIEMPCDE} <> {TPTY_A_OLD.AACCINIEMPCDE} or
{TPTY_A_NEW.AACCMGREMPCDE} <> {TPTY_A_OLD.AACCMGREMPCDE} or
{TPTY_A_NEW.ACLTIND} <> {TPTY_A_OLD.ACLTIND} or
{TPTY_A_NEW.AOURAGTIND} <> {TPTY_A_OLD.AOURAGTIND} or
{TPTY_A_NEW.ASTKBRKIND} <> {TPTY_A_OLD.ASTKBRKIND} or
{TPTY_A_NEW.AAGTIND} <> {TPTY_A_OLD.AAGTIND} or
{TPTY_A_NEW.AISSIND} <> {TPTY_A_OLD.AISSIND}
)
Thanks,
John