Crystal Reports  

Select ³¯­z¦¡ (Basic »yªk)

Select ³¯­z¦¡»P If ³¯­z¦¡Ãþ¦ü¡C¦ý¦³®É¥Î Select ³¯­z¦¡¼¶¼gªº¤½¦¡¸û²M·¡¥B¤£­«½Æ¡C¥H¤U½d¨ÒÅçºâ {Customer.Fax} Äæ¦ì¡A¨M©w¨ä°Ï½X¬O§_ÄÝ©óµØ²±¹y¦{ (206¡B360¡B509) ©Î¥[®³¤jªº­^ÄÝ­ô­Û¤ñ¨È (604¡B250)¡G

Rem Select ½d¨Ò 1
Select Case Left ({«È¤á.¶Ç¯u¸¹½X}, 3)
Case "604", "250"
formula = "BC"
Case "206", "509", "360"
formula = "WA"
End Select

ºò±µ¦b Select Case ÃöÁä¦r«á­±ªº¹Bºâ¦¡ºÙ¬° Select ±ø¥ó¡C¦b¤W¨Ò¤¤¬° Left ({Customer.Fax}[1 To 3])¡CSelect ³¯­z¦¡±q²Ä¤@­Ó Case ¶}©l¡AÀˬd¨äµ²ªG¬O§_²Å¦X Select ±ø¥ó¡A¦pªG¬O¡A´N°õ¦æ±µ¤U¨Óªº³¯­z¦¡¡A³o¼Ë¤@ª½¶i¦æ¨ì¤U¤@­Ó Case¡C

Rem ®ÄªG»P Select ½d¨Ò 1 ¬Û¦P
Dim areaCode As String
areaCode = Left ({«È¤á.¶Ç¯u¸¹½X}, 3)
If areaCode In Array ("604", "250") Then
formula = "BC"
ElseIf areaCode In Array ("206", "509", "360") Then
formula = "WA"
End If

½d¨Ò

¥H¤Uªº¤½¦¡±N¬Y¹q¼v©ÒÀò±oªº¶ø´µ¥d´£¦W¼Æ¤À¦¨§C¡B¤¤¡B°ª©Î·¥°ªµ¥Ãþ§O¡A¨ÃÅã¥Ü¦b Case ¼Ð°O«á¥i¥H©ñ¤Jªº¹Bºâ¦¡²M³æ¡C½Ðª`·N¿ï¾Ü©Êªº Case Else ¤l¥y¡C¦pªG«e­±ªº Case ¤l¥y§¡¤£²Å¦X Case ¹Bºâ¦¡²M³æ¡A¨º»ò´N·|¨Ï¥Î Case Else ¦r¥y¡C¨Ò¦p¡A¦b¤U¨Ò¤¤¡A¦pªG {movie.NOM} ¬O 11¡A«h¤½¦¡·|¶Ç¦^ extreme¡C

Rem Select example 2
Select Case {movie.NOM}
Case 1,2,3, Is < 1
Rem ¥i¦³¦h­Ó³¯­z¥y¥X²{©ó
Rem ¹Bºâ¦¡°Ï¶ô¤¤
formula = "low"
Case 4 To 6, 7, 8, 9
formula = "medium"
Case 10
formula = "high"
Case Else
formula = "extreme"
End Select

½Ð°Ñ¾\

±±¨îµ²ºc | If ³¯­z¦¡ | For/Next °j°é