Crystal Reports  

±ø¥ó¦¡®æ¦¡¤Æ¨ç¦¡ (Basic »yªk)

¦b¼¶¼g±ø¥ó¦¡®æ¦¡¤Æ¤½¦¡®É¡A±z¥i¯à·|·Q¥Î [¨ç¦¡] ¾ðª¬µ²ºc¤WºÝªºÃB¥~¨ç¦¡¡C

½d¨Ò

¦pªG­n®æ¦¡¤Æ {«È¤á.¥h¦~·~ÁZ} Äæ¦ì¡A¥Hºñ¦âÅã¥Ü¶W¹L $100,000 ªº¾P°â¶q¡A¥H¬õ¦âÅã¥Ü§C©ó $15,000 ªº¾P°â¶q¡A¦Ó¨ä¥L«h¥H¶Â¦âÅã¥Ü¡C

Rem ±ø¥ó®æ¦¡½d¨Ò 1
If {«È¤á.¥h¦~·~ÁZ} > 100000 Then
formula = crGreen
ElseIf {«È¤á.¥h¦~·~ÁZ} < 15000 Then
formula = crRed
Else
formula = crBlack
End If

¥Ñ©ó³o¬O¤@­Ó¦r«¬¦â±m®æ¦¡¤Æªº¨ç¦¡¡A¦]¦¹¦â±m±`¼Æªº²M³æ·|¥X²{¦b [¨ç¦¡] ¾ðª¬µ²ºc¤¤¡C³o­Ó½d¨Ò¨Ï¥Î¨ì¤TºØ¨ç¦¡¡GcrGreen¡BcrRed ¤Î crBlack¡C±z¤]¥i¥H§ï¥Î¦â±m±`¼Æªº¹ê»Ú¼Æ­È¡C¨Ò¦p¡AcrRed ¬O 255¡AcrGreen ¬O 32768¡C¤£¹L¡A¨Ï¥Î¦â±m±`¼Æ·|¨Ï±o¤½¦¡§ó®e©ö²z¸Ñ¡C©Ò¦³ Basic »yªk¤¤ªº±`¼Æ¨ç¦¡³£¦³«e¸m¦r¤¸ cr¡C

ª`·N   ¦³¨Ç®æ¦¡¤ÆÄݩʨ䣨ϥα`¼Æ¨ç¦¡¡C¨Ò¦p¡A¦pªG±z¤£­n¦L¥X¾P°â¶q§C©ó $50,000 ªº {«È¤á.¥h¦~·~ÁZ} ­È¡A¥i¥H¼¶¼g¥H¤U±ø¥ó¦¡®æ¦¡¤Æ¤½¦¡¨Ó§í¨îÄݩʡG
Rem Conditional formatting example 2
If {«È¤á.¥h¦~·~ÁZ} < 50000 Then
formula = True '§í¨î¼Æ­È
Else
formula = False '¤£§í¨î¼Æ­È
End If

©Î¥Î§ó²³æªº¤èªk¡G

Rem ±ø¥ó®æ¦¡½d¨Ò 3 -
Rem µ¥©ó½d¨Ò 2
formula = {«È¤á.¥h¦~·~ÁZ} < 50000

¦pªG¥h¦~·~ÁZ§C©ó $50,000¡A«h¹Bºâ¦¡

{«È¤á.¥h¦~·~ÁZ} < 50000

¬° True¡A¤½¦¡¤]·|¶Ç¦^ True¡C¬Û¤Ï¦a¡A¦pªG¥h¦~·~ÁZ°ª©ó©Îµ¥©ó $50,000¡A¨º»ò

{«È¤á.¥h¦~·~ÁZ} < 50000

¬° False¡A¤½¦¡¤]·|¶Ç¦^ False¡C

½Ð°Ñ¾\

°õ¦æ³øªí­pºâ | ¤@¯ë¥Î³~±ø¥ó¦¡®æ¦¡¤Æ¨ç¦¡