Crystal Reports  

Select ¹Bºâ¦¡ (Crystal »yªk)

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

//Select example 1
Select {«È¤á.¶Ç¯u¸¹½X}[1 To 3]
Case "604", "250" :
"BC"
Case "206", "509", "360" :
"WA"
Default :
      "";

ºò±µ¦b Select ÃöÁä¦r¤§«áªº¹Bºâ¦¡ºÙ¬° Select ±ø¥ó¡C¦b¤W­±³o­Ó½d¨Ò¤¤¡A¬O {Customer.Fax}[1 To 3]¡CSelect ¹Bºâ¦¡¹Á¸Õ´M§ä²Ä¤@­Ó²Å¦X Select ±ø¥óªº Case¡AµM«á°õ¦æ¦ì©ó¸Ó Case «á­±«_¸¹«áªº¹Bºâ¦¡¡C°²¦p«e­±³£¤£²Å¦X Select ±ø¥ó¡A´N²Å¦XDefault ±ø¥ó¡C½Ðª`·N¡A¦bDefault ¤§«á¤]¦³¤@­Ó«_¸¹¡C

//Same effect as Select example 1
Local StringVar areaCode := {«È¤á.¶Ç¯u¸¹½X}[1 To 3];
If areaCode In ["604", "250"] Then
"BC"
Else If areaCode In ["206", "509", "360"] Then
"WA"
Else
   "";

½d¨Ò

¥H¤Uªº¤½¦¡±N¬Y¹q¼v©ÒÀò±oªº¶ø´µ¥d´£¦W¼Æ¤À¦¨§C¡B¤¤¡B°ª©Î·¥°ªµ¥Ãþ§O¡A¨ÃÅã¥Ü¦b Case ¼Ð°O«á¥i¥H©ñ¤Jªº¹Bºâ¦¡²M³æ¡C

//Select example 2
Select {movie.NOM}
Case 1,2,3, Is < 1
   (
//Can have expression lists by using
//parentheses
      10 + 20;
"§C"
   )
Case 4 To 6, 7, 8, 9 :
"¤¤"
Case 10 :
"°ª"
Default :
"µ´¨Î"

Select ¹Bºâ¦¡¤¤ªº Default ¤l¥y¬O¿ï¾Ü©Êªº¡A¦pªG¨S¦³ Default ¤l¥y¡A¦Ó¥B¨S¦³¥ô¦ó¤@­Ó±ø¥ó²Å¦X¡ASelect ¹Bºâ¦¡´N·|¶Ç¦^¸Ó¹Bºâ¦¡«¬§Oªº¹w³]­È¡C¨Ò¦p¡A°²¦p¥H¤W½d¨Ò¤¤¨S¦³ Default ¤l¥y¡A¦Ó¥B {movie.NOM} = 11¡A«K·|¶Ç¦^ªÅ¥Õ¦r¦ê¡CSelect ¹Bºâ¦¡¤]¬O¤@­Ó¹Bºâ¦¡¡A¦]¦¹¤]¾A¥Î¡u¨ä¥L¦³Ãö If ¹Bºâ¦¡ªº¸Ô²Ó¸ê®Æ¡v¤@¸`¤¤ªºÃþ¦üµù¸Ñ¡C

½Ð°Ñ¾\

If ¹Bºâ¦¡ | ±±¨îµ²ºc | For °j°é