Skip to Content
0
Former Member
May 30, 2008 at 07:19 PM

Zone and Subzone problem

34 Views

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