¦pªG±z¨Ï¥Îªº¸ê®Æ®w¤ä´©¬d¸ß»y¨¥ (¨Ò¦p SQL)¡A±z¥i¥H¼¶¼g¦Û¤vªº©R¥O°µ¬° Crystal Reports ¤¤ªº Table ª«¥ó¡C¦p¦¹¤@¨Ó¦³¸gÅ窺¸ê®Æ®w¨Ï¥ÎªÌ«K¥i§¹¥þ±±¨î¤U±À¦Ü¸ê®Æ®w¦øªA¾¹ªº¸ê®Æ³B²z¡C¤@Ó¦³¸gÅ窺¨Ï¥ÎªÌ¥i¥H¼¶¼g°ª«×³Ì¨Î¤Æªº©R¥O¡A¥H¤j´TÁY´î¦øªA¾¹©Ò¶Ç¦^ªº¸ê®Æ²Õ¤j¤p¡C
±z¥i¥H¨Ï¥Î¸ê®Æ®w±M®a¤¤ªº [¥[¤J©R¥O] ¸`ÂI¨Ó¼¶¼g¦Û¤vªº©R¥O¡A§Y¥i«Ø¥ßªí¥Ü©R¥O³B²zµ²ªGªºµêÀÀ¸ê®Æªí¡C
·í±z¨Ï¥Î¤w«Ø¥ß¬°©R¥OªºµêÀÀ¸ê®Æªí®É¡ACrystal Reports ¤£·|§ïÅܤw¶Ç°e¨ì¦øªA¾¹ªº SQL »yªk (¤]´N¬O»¡¡A¥¦¤£·|¦Û°Ê¥[¤J¤Þ¸¹©Î¶h¥X¦r¤¸)¡C¦¹¦æ¬°¤]¾A¥Î©ó©R¥O¤¤¨Ï¥Îªº°Ñ¼Æ¡C¦]¦¹¡A±z¥²¶·¥[¤J¸ê®Æ®wÅX°Êµ{¦¡©Ò»Ýªº¤Þ¸¹»P¶h¥X¦r¤¸¡C
Yn«Ø¥ß¦Û¤vªº©R¥Oª«¥ó
¨Ò¦p¡G
SELECT Customer.`Customer ID`, Customer.`Customer Name`, Customer.`Last Year's Sales`, Customer.`Region`, Customer.`Country`, Orders.`Order Amount`, Orders.`Customer ID`, Orders.`Order Date` FROM Customer Customer INNER JOIN Orders Orders ON Customer.`Customer ID` = Orders.`Customer ID` WHERE (Customer.`Country` = 'USA' OR Customer.`Country` = 'Canada') AND Customer.`Last Year's Sales` < 10000. ORDER BY Customer.`Country` ASC, Customer.`Region` ASC
±z·|¦^¨ì Crystal Reports ActiveX ³]p¤u¨ã¡C¦bÄæ¦ìÁ`ºÞ¤¤ªº [¸ê®Æ®wÄæ¦ì] ¤U·|¥X²{ [©R¥O] ¸ê®Æªí¡A¨ä¤¤¦C¥X±z«ü©wªº¸ê®Æ®wÄæ¦ì¡C
ª`·N ¦b¹w³]ª¬ªp¤U¡A±zªº©R¥O§YºÙ¬°¡u©R¥O¡v¡C±z¥u»Ý«ö¤U F2 «K¥iÅܧó¨ä§O¦W¡C
Yn½s¿è©R¥Oª«¥ó
·í±z¦b [¥[¤J©R¥O¦Ü³øªí] ¹ï¸Ü¤è¶ô©Î [×§ï©R¥O] ¹ï¸Ü¤è¶ô¤¤¤u§@®É¡A¥i¥H«Ø¥ß°Ñ¼ÆÄæ¦ì¡C
Yn«Ø¥ß©R¥Oª«¥óªº°Ñ¼Æ
½Ð¿é¤J±z·Qn¥Î¨ÓÃѧO°Ñ¼Æªº¦WºÙ¡C
½Ð¿é¤Jµ{¦¡´£¥Ü®ÉnÅã¥Üªº¤å¦r
½Ð¿é¤J°Ñ¼ÆÄæ¦ìªº¸ê®Æ«¬§O
½Ð¿é¤J·í¨Ï¥ÎªÌ¨S¦³´£¨Ñ·sȮɡAnµ{¦¡¨Ï¥ÎªºÈ
±zªº°Ñ¼Æ«K·|¥[¤J [°Ñ¼Æ²M³æ] ¤¤¡C±z¥u»Ý¦^¨ì [×§ï©R¥O] ¹ï¸Ü¤è¶ô¤¤¡A«K¥i×§ï©Î§R°£°Ñ¼Æ¡C
Yn±N°Ñ¼Æ¥[¤J©R¥Oª«¥ó¤¤
°Ñ¼Æ«K·|¥[¤J¦Ü´å¼Ð©Ò¦bªº¦ì¸m¤¤¡C¥¦¬Ý°_¨Ó¹³¬O³o¼Ë¡G
WHERE Customer.`Country` = '{?CountryParam}'
¦pªG±z·QnÅܧó¤w¸g«Ø¥ßªº°Ñ¼ÆÄæ¦ì¡A½Ð²¾¦ÜÄæ¦ìÁ`ºÞ¡A¦A±q°Ñ¼ÆÄæ¦ì¸`ÂI¤¤¥[¥H¿ï¨ú¡C