Crystal Reports  

®Ú¾Ú©R¥O/SQL ¬d¸ß©w¸qµêÀÀ¸ê®Æªí

¦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

­Y­n«Ø¥ß¦Û¤vªº©R¥Oª«¥ó

  1. ¦bÄæ¦ìÁ`ºÞ¤¤¥H·Æ¹«¥kÁä«ö¤@¤U [¸ê®Æ®wÄæ¦ì]¡A¦A«ö¤@¤U [¸ê®Æ®w±M®a]¡C
  2. ¦b [¸ê®Æ®w±M®a] ¹ï¸Ü¤è¶ô¤¤¡AÂsÄý¸ê®Æ§¨¥H§ä¥X±zªº¸ê®Æ¨Ó·½¡C
  3. «ö¨â¤U¸ê®Æ¨Ó·½¤U¤èªº [¥[¤J©R¥O] ¸`ÂI¡C
  4. ¦b [¥[¤J©R¥O¦Ü³øªí] ¹ï¸Ü¤è¶ô¤¤¡A¬°¶}±Òªº¸ê®Æ¨Ó·½¿é¤J¾A·íªº¬d¸ß/©R¥O¡C

    ¨Ò¦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
  5. «ö¤@¤U [½T©w]¡C

    ±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

­Y­n½s¿è©R¥Oª«¥ó

  1. ¦b¸ê®Æ®w±M®aªº [¿ï¨úªº¸ê®Æªí] °Ï°ì¤¤¡A½Ð¿ï¨ú­n½s¿èªº©R¥O¡C
  2. ¥H·Æ¹«¥kÁä«ö¤@¤U¸Ó©R¥O¡A¦A±q±¶®|¥\¯àªí¤¤¿ï¨ú [½s¿è©R¥O]¡C
  3. ¦b [­×§ï©R¥O] ¹ï¸Ü¤è¶ô¤¤¶i¦æ·Q­nªºÅܧó¡A§¹¦¨®É¦A«ö¤@¤U [½T©w]¡C

·í±z¦b [¥[¤J©R¥O¦Ü³øªí] ¹ï¸Ü¤è¶ô©Î [­×§ï©R¥O] ¹ï¸Ü¤è¶ô¤¤¤u§@®É¡A¥i¥H«Ø¥ß°Ñ¼ÆÄæ¦ì¡C

­Y­n«Ø¥ß©R¥Oª«¥óªº°Ñ¼Æ

  1. ¦b [¥[¤J©R¥O¦Ü³øªí] ¹ï¸Ü¤è¶ô©Î [­×§ï©R¥O] ¹ï¸Ü¤è¶ôªº [°Ñ¼Æ²M³æ] °Ï°ì¤¤¡A½Ð«ö¤@¤U [«Ø¥ß]¡C
  2. ¦b [©R¥O°Ñ¼Æ] ¹ï¸Ü¤è¶ô¤¤¡A©ó´£¨ÑªºÄæ¦ì¤¤¿é¤J¤U¦C¸ê°T¡G
    • °Ñ¼Æ¦WºÙ

      ½Ð¿é¤J±z·Q­n¥Î¨ÓÃѧO°Ñ¼Æªº¦WºÙ¡C

    • ´£¥Ü¤å¦r

      ½Ð¿é¤Jµ{¦¡´£¥Ü®É­nÅã¥Üªº¤å¦r

    • ¼Æ­ÈÃþ«¬

      ½Ð¿é¤J°Ñ¼ÆÄæ¦ìªº¸ê®Æ«¬§O

    • ¹w³]­È

      ½Ð¿é¤J·í¨Ï¥ÎªÌ¨S¦³´£¨Ñ·s­È®É¡A­nµ{¦¡¨Ï¥Îªº­È

  3. «ö¤@¤U [½T©w]¡C

    ±zªº°Ñ¼Æ«K·|¥[¤J [°Ñ¼Æ²M³æ] ¤¤¡C±z¥u»Ý¦^¨ì [­×§ï©R¥O] ¹ï¸Ü¤è¶ô¤¤¡A«K¥i­×§ï©Î§R°£°Ñ¼Æ¡C

­Y­n±N°Ñ¼Æ¥[¤J©R¥Oª«¥ó¤¤

  1. ±N´å¼Ð¸m©ó¬d¸ß¤å¦r¤¤¡C
  2. ¦b [°Ñ¼Æ²M³æ] ¤¤«ö¨â¤U°Ñ¼Æªº¦WºÙ¡C

    °Ñ¼Æ«K·|¥[¤J¦Ü´å¼Ð©Ò¦bªº¦ì¸m¤¤¡C¥¦¬Ý°_¨Ó¹³¬O³o¼Ë¡G

    WHERE
        Customer.`Country` = '{?CountryParam}'

    ¦pªG±z·Q­nÅܧó¤w¸g«Ø¥ßªº°Ñ¼ÆÄæ¦ì¡A½Ð²¾¦ÜÄæ¦ìÁ`ºÞ¡A¦A±q°Ñ¼ÆÄæ¦ì¸`ÂI¤¤¥[¥H¿ï¨ú¡C

½Ð°Ñ¾\

´¡¤J¸ê®Æ®wÄæ¦ì