Crystal Reports  

Null Äæ¦ì©M Null ­È (Basic »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 ({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¸û¨ã´y­z©Êªº½Æ¦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 ¨Ó­×´_¤W­zªº½d¨Ò¡G

If IsNull({²£«~¸ê®Æ.¦â±m}) Or _
InStr({²£«~¸ê®Æ.¦â±m}, " ") = 0 Then
formula = "basic"
Else
formula = "fancy"
End If

½Ð°Ñ¾\

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