Crystal Reports  

Null Äæ¦ì©M Null ­È (Crystal »yªk)

³q±`¡A·í Crystal Reports ¸I¨ì¤½¦¡¤¤ªºªÅ­ÈÄæ¦ì®É¡A·|¥ß¨è°±¤îÅçºâ¤½¦¡¡A¦Ó¥B¤£²£¥Í¥ô¦ó­È¡C¦pªG±z·Q­n¦b¤½¦¡¤¤³B²zªÅÄæ¦ì­È¡A¥²¶·©ú½T¦a¨Ï¥Î±Mªù³]­p¨Ó±±¨î¥¦­Ìªº¨ç¦¡¨Ó³B²z¡GIsNull¡BPreviousIsNull ©Î NextIsNull¡C

»P¹Bºâ¤l¬ÛÃö¡A¦b Crystal Reports Åçºâ¤U¦C±ø¥ó®É¡G

IsNull({²£«~¸ê®Æ.¦â±m}) Or
InStr({²£«~¸ê®Æ.¦â±m}, " ") = 0

¥¦·|¥ýÅçºâ IsNull ({²£«~¸ê®Æ.¦â±m})¡A¦pªG§PÂ_¥Xµ²ªG¬° True¡A´Nªí¥Ü¾ã­Ó±ø¥ó³£¬° True¡A´N¤£¥ÎÄ~ÄòÀˬd¤U¦C±ø¥ó¡G

InStr({²£«~¸ê®Æ.¦â±m}, " ") = 0

´«¥y¸Ü»¡¡ACrystal Reports ¦bºtºâ¥X¾ã­Ó¹Bºâ¦¡ªºµ²ªG«á¡A´N·|°±¤îÅçºâ¥¬ªL¹Bºâ¦¡¡C¦b¤U¦Cªº½d¨Ò¤¤¡A¦b denom ¬° 0 ªº±¡ªp¤U¡A¤½¦¡¤£·|¥H¹s¨Ó·í°£¼Æ¡G

Local NumberVar num;
Local NumberVar denom;
...
If denom <> 0 And num / denom > 5 Then
...

½d¨Ò

{²£«~¸ê®Æ.¦â±m} Äæ¦ì¥]§t¡u¬õ¡v¤Î¡u¶Â¡vµ¥°ò¥»¦â±m¡A©Mªá¦¡ªº½Æ¦X¦r¦â±m¡A¨Ò¦p¡uµ·º÷»È¡v©M¡uÄ_¥Ûºñ¡v¡C°²³]±z·Q­n¼¶¼g¤@­Ó¤½¦¡¡A¦pªG¬O°ò¥»¦â±m«K¦L¥X¡u°ò¥»¡v¡A¦pªG¬O¨ä¥L¦â±m«h¦L¥X¡uªá¦¡¡v¡C

If InStr({²£«~¸ê®Æ.¦â±m}, " ") = 0 Then
"°ò¥»"
Else
"ªá¦¡"

¨ç¦¡©I¥s InStr ·|¥h·j´M {²£«~¸ê®Æ.¦â±m} ¦r¦ê¤¤ªºªÅ®æ¡C°²¦p¥¦§ä¨ìªÅ®æ¡A´N·|¶Ç¦^ªÅ®æªº¦ì¸m¡F§_«h¶Ç¦^ 0¡C¥Ñ©ó°ò¥»¦â±m³£¥u¦³¤@­Ó­^¤å¦r¡A¤£§t¥ô¦óªÅ®æ¡A¦]¦¹ InStr ¸I¨ì¥¦­Ì´N·|¶Ç¦^ 0¡C

¹ï©ó Guardian Chain Lock ³oÃþ²£«~¡A¨Ã¤£·|°O¿ý¥¦ªº¦â±m­È¡A©Ò¥H¦b¸ê®Æ®w¤¤¸Óµ§¸ê®Æ¿ýªº {²£«~¸ê®Æ.¦â±m} Äæ¦ì¨ã¦³ªÅ­È¡C¦]¦¹¡AGuardian Chain Lock ¸ê®Æ¿ýªº®ÇÃ䤣·|¦L¥X¥ô¦ó¤å¦r¡C

¤U¦C½d¨Ò»¡©ú¦p¦ó¥Î IsNull ­×¥¿«e¤@­Ó½d¨Ò¡G

If IsNull({²£«~¸ê®Æ.¦â±m}) Or
InStr({²£«~¸ê®Æ.¦â±m}, " ") = 0 Then
"°ò¥»"
Else
"ªá¦¡"

½Ð°Ñ¾\

¹Bºâ¤l | ¤½¦¡½s¿è¾¹