Crystal Reports  

½d³ò¸ê®Æ«¬§O (Crystal »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_¡BUpTo¡BUpTo_¡BUpFrom ¤Î UpFrom_ µ¥ÃöÁä¦r¨Ó²£¥Í½d³ò¡C¤@¯ë¦Ó¨¥¡ATo ¥Î©ó¦³¨â­Óµ²§ôÂIªº½d³ò¡AUpTo ©M UpFrom «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

UpTo 5

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

UpTo_ 5

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

#Jan 5, 1999# To #Dec 12, 2000#
UpFrom #Jan 1, 2000#

¦b¤½¦¡¤¤¨Ï¥Î½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

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

//Compute student letter grades
Select {Student.Test Scores}
Case UpFrom 90 :
"A"
Case 80 To_ 90 :
"B"
   Case 70 To_ 80 :
"C"
   Case 60 To_ 70 :
"D"
Default :
"F";

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

5 In 2 To 10; //True
5 In 2 To_ 5; //False
5 In 2 To 5; //True

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

Maximum (2 To 10) //Returns 10

½Ð°Ñ¾\

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