³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 ({Product.Color})¡A¦b¨M©wµ²ªG¬° True ¤§«á¡Aµ{¦¡´N·|ª¾¹D¾ãÓ±ø¥ó§¡¬° True¡A¦Ó¤£»ÝÀˬd¬O§_
InStr({²£«~¸ê®Æ.¦â±m}, " ") = 0
´«¥y¸Ü»¡¡ACrystal Reports ¦b¹w´ú¥X¾ãÓ¹Bºâ¦¡ªºµ²ªG«á¡A´N·|°±¤îÅçºâ¥¬ªL¹Bºâ¦¡¡C¦b¤U¦Cªº½d¨Ò¤¤¡A¦b denom ¬° 0 ªº±¡ªp¤U¡A¤½¦¡¤£·|¥H¹s¨Ó·í°£¼Æ¡G
Dim num As Number, denom As Number ... If denom <> 0 And num / denom > 5 Then ...
ª`·N Visual Basic ¤£¤ä´©³o¶µ§Þ¥©¡A¦]¬° Visual Basic ¤¤¥¬ªL¹Bºâ¦¡ªº©Ò¦³³¡¤À³£·|³QÅçºâ¡A´Nºâ¨S¦³¥²n¤]¬O¦p¦¹¡C
½d¨Ò
{²£«~¸ê®Æ.¦â±m} Äæ¦ì¥]§t¡u¬õ¡v¤Î¡u¶Â¡vµ¥°ò¥»¦â±m¡A©M¸û¨ã´yz©Êªº½Æ¦X¦r¦â±m¡A¨Ò¦p¡uµ·º÷»È¡v©M¡uÄ_¥Ûºñ¡v¡C¥H¤U¬O¤½¦¡½d¨Ò¡A¦¹¤½¦¡±N°ò¥»¦â±m¼Ð¬°¡u°ò¥»¡v¡A¦Ó±N¨ä¥L¦â±m¼Ð¬°¡uªá¦¡¡v¡C
If InStr({²£«~¸ê®Æ.¦â±m}, " ") = 0 Then formula = "basic" Else formula = "fancy" End If
¨ç¦¡©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
¥H¤U½d¨Ò»¡©ú¦p¦ó¨Ï¥Î IsNull ¨Ó×´_¤Wzªº½d¨Ò¡G
If IsNull({²£«~¸ê®Æ.¦â±m}) Or _ InStr({²£«~¸ê®Æ.¦â±m}, " ") = 0 Then formula = "basic" Else formula = "fancy" End If