Post Author: tsgill
CA Forum: Formula
i Iam a beginner in crystal and i cannot get this sql statement working in crystal. I have the following SQL Statement LS_FROM_ZONE IN (SELECT SUBZONE FROM FASTZONE WHERE ZONE_CODE = 'BC')) basically iam getting a list of subzones and want to see if my LS_FROM_ZONE is one of the the subzone. SQL runs fine and takes about 1-2sec. somehow my report get stuck. i just think that i programmed it wrong. I simply cannot properly translate the sql into crystal. How can i create the same statement in Crystal Report ? Can anyone help me ? Regards, Tray