Crystal Reports  

½d³ò¸ê®Æ«¬§O (Basic »yªk)

½d³ò¬O¥Î¨Ó±±¨î¤@¨t¦Cªº­È¡C½d³ò«¬§O¥iÀ³¥Î¦b©Ò¦³Â²³æ«¬§O¡A¦ý¥¬ªL°£¥~¡C¼Æ­È½d³ò¡B³f¹ô½d³ò¡B¦r¦ê½d³ò¡B¤é´Á½d³ò¡B®É¶¡½d³ò¤Î¤é´Á®É¶¡½d³ò¡C±z¥i¥H¨Ï¥Î To¡B_To¡BTo_¡B_To_¡BIs >¡BIs >=¡BIs < »P Is <= µ¥ÃöÁä¦r¨Ó²£¥Í½d³ò¡C¤@¯ë¦Ó¨¥¡ATo ¥Î©ó¦³¨â­Óµ²§ôÂIªº½d³ò¡AIs «h¥Î©ó¶}©ñ©Êªº½d³ò (¥u¦³¤@­Óµ²§ôÂI)¡C©³½u²Å¸¹¥Î¨Óªí¥Ü½d³ò¤¤¬O§_¥]§tºÝÂI¡C

¼Æ­È½d³ò­È½d¨Ò

±q 2 ¨ì 5 ªº¼Æ¦r½d³ò¡A¥]§t 2 ©M 5¡C

2 To 5

±q2 ¨ì 5 ªº¼Æ¦r½d³ò¡A¤£¥]§t 2¡A¦ý¥]§t 5¡C

2 _To 5

©Ò¦³¤p©ó©Îµ¥©ó 5 ªº¼Æ¦r

Is <= 5

©Ò¦³¤p©ó 5 ªº¼Æ¦r

Is < 5

¤é´Á®É¶¡½d³ò­È½d¨Ò

#Jan 5, 1999# To #Dec 12, 2000#
Is >= #Jan 1, 2000#

¤½¦¡¤¤ªº½d³ò

¦b Crystal Reports ¤¤¡A¦³ 27 ­Ó¨ç¦¡¥Î¨Ó«ü©w¤é´Á½d³ò¡C¨Ò¦p¡ALastFullMonth ¨ç¦¡¥i¥Î¨Ó«ü©w¥]§t¤W­Ó¤ë±q²Ä¤@¤Ñ¨ì³Ì«á¤@¤Ñ©Ò¦³¤é´Áªº¤é´Á­È½d³ò¡C©Ò¥H¡A°²¦p¤µ¤Ñ¬O 1999 ¦~ 9 ¤ë 15 ¤é¡A¨º»ò LastFullMonth ¨ç¦¡©M CDate (#Aug 1, 1999#) To CDate (#Aug 31, 1999#) ªº½d³ò­È¬O¤@¼Ëªº¡C

If ©Î Select ³¯­z¦¡¤¤³Ì±`¨Ï¥Î½d³ò¡C¥H¤U½d¨Ò¬O®Ú¾Ú¹q¸£½Ò¾Ç¥Íªº¦Ò¸Õ¤À¼Æ¡A¨Ó­pºâ¦¨ÁZµ¥²Ä¡C¤À¼Æ¤j©ó©Îµ¥©ó 90 ¥i±o A¡A¤À¼Æ 80 ¨ì 90 (¦ý¤£¥]§t 90) ¥i±o¨ì B¡A¨Ì¦¹Ãþ±À¡C

Rem ­pºâ¾Ç¥Í¦¨ÁZµ¥²Ä
Select Case {Student.Test Scores}
Case Is >= 90
formula = "A"
   Case 80 To_ 90
formula = "B"
   Case 70 To_ 80
formula = "C"
Case 60 To_ 70
formula = "D"
Case Else
formula = "F"
End Select

¤W­zªº½d¨Ò¨Ï¥Î Select ³¯­z¦¡¡A¦b±±¨îµ²ºc¤¤·|¦³§ó¸Ô²Óªº»¡©ú¡C±z¥i¥H¨Ï¥Î In ¹Bºâ¤l¨ÓÀˬd¬Y­È¬O§_¦b½d³ò¤º¡C¨Ò¦p¡G

formula = 5 In 2 To 10 'True
formula = 5 In 2 To_ 5 '°²
formula = 5 In 2 To 5 'True

Maximum ©M Minimum ¨ç¦¡¥i¥Î¨Ó´M§ä½d³òªººÝÂI¡G

formula = Maximum (2 To 10) '¶Ç¦^ 10

½Ð°Ñ¾\

°}¦C¸ê®Æ«¬§O | ²³æ¸ê®Æ«¬§O