Crystal Reports  

±N¸ê®Æ¿ý¿ï¾Ü¤U±À¦Ü¸ê®Æ®w¦øªA¾¹

¥[³t³øªí³B²z³Ì­«­nªº¤@¥ó¨Æ¡A´N¬O­­¨î±q¸ê®Æ®w¶Ç¦^ªº¸ê®Æ¶q¡C§¹¦¨³o¶µ§@·~ªº¥D­n¤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

¤U±À¸ê®Æ¿ý¿ï¾Ü—½d¨Ò»¡©ú

¦¹½d¨Ò±N»¡©ú¼¶¼g¥i¤U±À¦Ü¸ê®Æ®w¦øªA¾¹ªº¸ê®Æ¿ý¿ï¾Üªº¦n³B¡C

¦b Xtreme ¸ê®Æ®w½d¨Ò¤¤¡A­q³f¥DÀÉ¸ê®Æªí¤¤¦³ 2,192 µ§¸ê®Æ¿ý¡A¨ä¤¤ 181 µ§ªº­q³f¤é´Á¦b 2001 ¦~¤§«e¡C°²³]³øªí¤¤¥u­n³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 µ§¡C­Y­n¬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¤W­z¨â­Ó¤½¦¡³£·|²£¥Í¬Û¦Pªº³øªí¡A¦ý²Ä¤G­Ó¤½¦¡«h¹B¥Î¤F¸ê®Æ®w¦øªA¾¹³B²z¦Û¤v¸ê®Æªº¥\¯à©M³Ì¨Î¤Æµ¥ÀuÂI¡C

¸ê®Æ¿ý¿ï¾Ü®Ä¯à¯µ³Z

³]©w¸ê®Æ¿ý¿ï¾Ü­n¨D®É¡AÀ³¦Ò¶q¤U¦C®Ä¯à¤è­±ªº°ÝÃD¡G

¤@¯ë

SQL ¸ê®Æ®w

½Ð°Ñ¾\

°ò¥»¸ê®Æ¿ý¿ï¾Ü | SQL ¹Bºâ¦¡