¥[³t³øªí³B²z³Ì«nªº¤@¥ó¨Æ¡A´N¬O¨î±q¸ê®Æ®w¶Ç¦^ªº¸ê®Æ¶q¡C§¹¦¨³o¶µ§@·~ªº¥Dn¤u¨ã´N¬O¸ê®Æ¿ý¿ï¾Ü¤½¦¡¡C
Crystal Reports for SQL ¸ê®Æ¨Ó·½©Ò´£¨ÑªºÅX°Êµ{¦¡¤¹³\±N¸ê®Æ¿ý¿ï¾Ü¡u¤U±À¡v¦Ü¸ê®Æ®w¦øªA¾¹¡C·í±z®Ú¾Ú SQL ¸ê®Æ¨Ó·½«ü©w³øªí¤¤ªº¸ê®Æ¿ý¿ï¾Ü¤½¦¡®É¡ACrystal Reports ·|¤ÀªR¸Ó¸ê®Æ¡B±q¤¤²£¥Í SQL ¬d¸ß¨Ã±N SQL ¬d¸ß¶Ç»¼¦Ü¸ê®Æ®w¦øªA¾¹¡C±µ¤U¨Ó¸ê®Æ®w¿ï¾Ü·|¦b¤U¦C¨âÓ¶¥¬q¤¤§¹¦¨¡G
¥Ñ©ó¸ê®Æ®w¦øªA¾¹ªº³t«×³q±`¤ñ¤u§@¯¸§Ö¡A¦]¦¹±z¥i¥H§Q¥Î³oÓÀuÂI¡A«ü©w¦b²Ä¤@Ó¶¥¬q§Y¥Ñ¦øªA¾¹³B²z¸ê®Æ¿ý¿ï¾Ü¤½¦¡¡C³o¼Ë¤@¨Ó«K¥i±N²Ä¤GÓ¶¥¬qªº¥»¾÷¸ê®Æ¿ý¿ï¾Ü§@·~³Ì¤p¤Æ¡C¤U¦C¸ê®Æ¿ý¿ï¾ÜºØÃþ¥i¤U±À¦Ü¦øªA¾¹¡G
¦¹½d¨Ò±N»¡©ú¼¶¼g¥i¤U±À¦Ü¸ê®Æ®w¦øªA¾¹ªº¸ê®Æ¿ý¿ï¾Üªº¦n³B¡C
¦b Xtreme ¸ê®Æ®w½d¨Ò¤¤¡Aq³f¥DÀÉ¸ê®Æªí¤¤¦³ 2,192 µ§¸ê®Æ¿ý¡A¨ä¤¤ 181 µ§ªºq³f¤é´Á¦b 2001 ¦~¤§«e¡C°²³]³øªí¤¤¥un³o¨Ç¸ê®Æ¿ý¡C±z¥i¥H¨Ï¥Î³oÓ¸ê®Æ¿ý¿ï¾Ü¤½¦¡¡G
Year ({Orders.Order Date}) < 2001
²£¥Íªº SQL ¬d¸ß·|±N 2,192 µ§¸ê®Æ¿ý¥þ³¡¶Çµ¹ Crystal Reports¡AµM«á¸ê®Æ¿ý¿ï¾Ü¤½¦¡·|±N½d³òÁY¤p¨ì 181 µ§¡CYn¬d¬Ý³o¶µ§@·~¡A½Ð«ö¤@¤U [¸ê®Æ®w] ¥\¯àªí¤Wªº [Åã¥Ü SQL ¬d¸ß]¡A¨Ãª`·N SQL ¬d¸ß¨S¦³ WHERE ¤l¥y¡C³o¬O¦]¬° Crystal Reports µLªk¤U±À WHERE ¤l¥y¤¤ªº Year ( ) ¨ç¦¡¡C
¦b¥t¤@¤è±¡A³oÓ¸ê®Æ¿ý¿ï¾Ü¤½¦¡·|²£¥Í¬Û¦Pªº³øªí¡G
{Orders.Order Date} < #Jan 1, 2001#
¦ý¬O²Ä¤GÓ¤½¦¡¥i¦b¸ê®Æ®w¦øªA¾¹¤W°õ¦æ¡A¦]¦¹«K¥i¤U±À¡C²£¥Íªº SQL ¬d¸ß±N¥u¶Ç°e 181 µ§¸ê®Æ¿ý¦Ü Crystal Reports¡C¦p¦¹¤@¨Ó¡A·í Crystal Reports Åçºâ¸ê®Æ¿ý¿ï¾Ü¤½¦¡«á¡A«K¤£»Ýn¦A¶i¤@¨B§R¥h¸ê®Æ¿ý¡C«ö¤@¤U [¸ê®Æ®w] ¥\¯àªí¤Wªº [Åã¥Ü SQL ¬d¸ß]¡A¨Ã½Ðª`·N²£¥Íªº SQL ¬d¸ß¨ã¦³ WHERE ¤l¥y¡C
®Ú¾Ú¦¹½d¨Òªº»¡©ú¡A·í±z¼W±j±zªº¸ê®Æ¿ý¿ï¾Ü¤½¦¡®É¡A³øªíªº³B²z³t«×±N·|Åܧ֡C¦b³oºØ±¡ªp¤U¡A¤Wz¨âÓ¤½¦¡³£·|²£¥Í¬Û¦Pªº³øªí¡A¦ý²Ä¤GÓ¤½¦¡«h¹B¥Î¤F¸ê®Æ®w¦øªA¾¹³B²z¦Û¤v¸ê®Æªº¥\¯à©M³Ì¨Î¤Æµ¥ÀuÂI¡C
³]©w¸ê®Æ¿ý¿ï¾Ün¨D®É¡AÀ³¦Ò¶q¤U¦C®Ä¯à¤è±ªº°ÝÃD¡G
¤@¯ë
¨Ò¦p¡AÁ×§K¨Ï¥Î ToText( ) ±N¼Æ¦r¸ê®Æ®wÄæ¦ìÂà´«¦¨¦r¦ê¸ê®Æ®wÄæ¦ì¡C
SQL ¸ê®Æ®w