³q±`¡A·í Crystal Reports ¸I¨ì¤½¦¡¤¤ªºªÅÈÄæ¦ì®É¡A·|¥ß¨è°±¤îÅçºâ¤½¦¡¡A¦Ó¥B¤£²£¥Í¥ô¦óÈ¡C¦pªG±z·Qn¦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·Qn¼¶¼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 "ªá¦¡"