[]
デモ ヘルプ APIリファレンス
トライアル版
(Showing Draft Content)

BandedList

BandedListは、他のレポートコントロールが配置することができるフリーフォームのバンドを持つデータ領域です。BandedListはデフォルトとして**［HEADER］、［FOOTER］、［DETAILS］**の3つのバンドで構成されています。［DETAILS］バンドは、データのレコード件数分繰り返し出力され、［HEADER］と［FOOTER］は、BandedListの最初と最後に出力されます。

BandedListで使用することができる主なプロパティを説明します。すべてのプロパティを表示するには、プロパティモードを**［詳細プロパティを表示］**にする必要があります。

データ

  • データセット： BandedListにに関連付けるデータセットを選択します。ドロップダウンリストには、レポートのデータセットコレクションにあるすべてのデータセットが表示されます。

  • データセットパラメータ： データセットにパラメータを追加することができます。追加したパラメータはプレビュー時にレポートに表示するデータのフィルタリングに使用できます。

  • フィルタ： データのフィルタリングを行う場合、コレクションにフィルタを追加します。コレクションに新しいフィルタを追加するには、次の3つの値を設定する必要があります。

    • 式： フィルタリングに使用する式を入力します。

    • 演算子： フィルタリングの方法を次の演算子から選択します。

      • Equal： 一致するデータが選択されます。
      • Like： 左側の値と右側の値が同様であるデータが選択されます。Like演算子の詳細情報については、MSDNを参照してください。
      • NotEqual： 一致しないデータが選択されます。
      • GreaterThan： 指定した値より大きな値のデータが選択されます。
      • GreaterThanOrEqual： 指定した値以上のデータが選択されます。
      • LessThan： 指定した値未満のデータが選択されます。
      • LessThanOrEqual： 指定した値以下のデータが選択されます。
      • TopN： 上位N番目までのデータが選択されます。
      • BottomN： 下位N番目までのデータが選択されます。
      • TopPercent： 累積合計が指定された割合以上になる、上位のデータが選択されます。
      • BottomPercent： 累積合計が指定された割合以上になる、下位のデータが選択されます。
      • In： 指定した値のリストに含まれるデータのみが選択されます。
      • Between： 指定した2つの値の間に入るデータが選択されます。

    • 値： 選択された演算子に基づいて左側の式と比較する値を入力します。Between演算子を選択した場合、2つの値ボックスが有効になります。In演算子を選択した場合、多くの値を入力することができます。

レイアウト

  • 改ページ： 改ページ設定を選択します。RDLレポートのみ有効です。

    • Start： リストの前に改ページを行います。
    • End： リストの後に改ページを行います。
    • StartAndEnd： リストの前後に改ページを行います。

  • ヘッダ行のみのページの出力を防止： 孤立したヘッダがページに表示されているかどうかを示します。

  • フッタ行のみのページの出力を防止： 孤立したフッタが次のページに表示されているかどうかを示します。

  • 新規セクション： 領域は自分のセクション内にあるかを示します。

  • 1ページ内に収める： リストの途中で改ページを行うか設定します。設定し、リストが複数ページにまたがる場合は、出力前に改ページされます。RDLレポートのみ有効です。

  • 空白を埋める： 余分な空白の出力を抑制するか設定します。RDLレポートのみ有効です。

BandedListのヘッダ部分を選択した場合、ヘッダのプロパティを設定できます。ヘッダで使用できる主なプロパティを説明します。

  • レイアウト

    • 全ページに繰り返し表示： BandedListが複数ページにまたがる場合は、各ページにヘッダバンドを出力するか設定します。

    • 内容に応じて拡大： 出力するデータに合わせてバンドの高さを拡大するか設定します。

    • 内容に応じて縮小： 出力するデータに合わせてバンドの高さを縮小するか設定します。

    • 改ページ： 改ページ設定を選択します。RDLレポートのみ有効です。

      • Start： ヘッダの前に改ページを行います。
      • End： ヘッダの後に改ページを行います。
      • StartAndEnd： ヘッダの前後に改ページを行います。

    • 1ページ内に収める： バンドの途中で改ページを行うか設定します。設定し、バンドが複数ページにまたがる場合は、出力前に改ページされます。

DETAILS

BandedListの詳細行部分を選択した場合、詳細行のプロパティを設定できます。詳細行で使用できる主なプロパティを説明します。

  • レイアウト

    • 内容に応じて拡大： 出力するデータに合わせてバンドの高さを拡大するか設定します。

    • 内容に応じて縮小： 出力するデータに合わせてバンドの高さを縮小するか設定します。

    • 改ページ： 改ページ設定を選択します。RDLレポートのみ有効です。

      • Start： 詳細行の前に改ページを行います。
      • End： 詳細行の後に改ページを行います。
      • StartAndEnd： 詳細行の前後に改ページを行います。

    • 1ページ内に収める： バンドの途中で改ページを行うか設定します。設定し、バンドが複数ページにまたがる場合は、出力前に改ページされます。

BandedListのフッタ部分を選択した場合、フッタのプロパティを設定できます。フッタで使用できる主なプロパティを説明します。

  • レイアウト

    • ページ下部に印刷： フッタバンドをページ下部に出力するか設定します。

    • 全ページに繰り返し表示： BandedListが複数ページにまたがる場合は、各ページにフッタバンドを出力するか設定します。

    • 内容に応じて拡大： 出力するデータに合わせてバンドの高さを拡大するか設定します。

    • 内容に応じて縮小： 出力するデータに合わせてバンドの高さを縮小するか設定します。

    • 改ページ： 改ページ設定を選択します。RDLレポートのみ有効です。

      • Start： フッタの前に改ページを行います。
      • End： フッタの後に改ページを行います。
      • StartAndEnd： フッタの前後に改ページを行います。

    • 1ページ内に収める： バンドの途中で改ページを行うか設定します。設定し、バンドが複数ページにまたがる場合は、出力前に改ページされます。

GROUP

BandedListにグループを追加しグループ部分を選択した場合、グループのプロパティを設定できます。グループで使用できる主なプロパティを説明します。

  • グループ

    • 名前： まだレポートに使用されていない一意のグループの名前を入力します。

    • 式： データをグループ化するために使用する式を入力します。

    • 改ページ： リストのグループ化に対してどの位置で改ページをするかを指定します。

      • Start： リストの前に改ページを行います。
      • End： リストの後に改ページを行います。
      • StartAndEnd： リストの前後に改ページを行います。

    • 親： 再帰的な階層のために親グループとして使用する式を入力します。

    • 見出しマップラベル： 目次（見出しマップ）にこのアイテムを表すためのラベルとして使用する式を入力します。

    • 新規セクション： グループ毎に独自のページ番号セクションを構成するため、グループ毎にページ番号を出力するかどうかを設定します。

使用例

次の例では、商品の一覧を含む請求書を表示し、リストの最後に購入した製品の小計と合計を表示するレポートを作成する方法を示します。

**メモ：**この例ではレポートファイルに、以下のようなデータを埋め込み、使用します。

データソース ```javascript [{ "ShipName": "高原亭", "ShipAddress": "横浜市旭区左近山 3-18-XXX", "ShipCity": "Toulouse", "ShipPostalCode": "31000", "ShipCountry": "France", "CustomerID": "LAMAI", "Customers_CompanyName": "高原亭", "Address": "牛久市下根町 1504-XX", "City": "Toulouse", "PostalCode": "31000", "Country": "France", "Salesperson": "Michael Suyama", "OrderID": "10350", "OrderDate": "12/12/94", "RequiredDate": "1/9/95", "ShippedDate": "1/3/95", "Shippers_CompanyName": "United Package", "ProductID": "50", "ProductName": "Valkoinen suklaa", "UnitPrice": 13.00, "Quantity": "15", "Discount": 0.100000001, "ExtendedPrice": 175.50, "Freight": 64.19 }, { "ShipName": "高原亭", "ShipAddress": "牛久市下根町 1504-XX", "ShipCity": "Toulouse", "ShipPostalCode": "31000", "ShipCountry": "France", "CustomerID": "LAMAI", "Customers_CompanyName": "La maison d'Asie", "Address": "横浜市旭区左近山 3-18-XXX", "City": "Toulouse", "PostalCode": "31000", "Country": "France", "Salesperson": "Michael Suyama", "OrderID": "10350", "OrderDate": "12/12/94", "RequiredDate": "1/9/95", "ShippedDate": "1/3/95", "Shippers_CompanyName": "United Package", "ProductID": "69", "ProductName": "Gudbrandsdalsost", "UnitPrice": 28.80, "Quantity": "18", "Discount": 0.100000001, "ExtendedPrice": 466.56, "Freight": 64.19 }, { "ShipName": "Ernst Handel", "ShipAddress": "Kirchgasse 6", "ShipCity": "Graz", "ShipPostalCode": "8010", "ShipCountry": "Austria", "CustomerID": "ERNSH", "Customers_CompanyName": "Ernst Handel", "Address": "Kirchgasse 6", "City": "Graz", "PostalCode": "8010", "Country": "Austria", "Salesperson": "Nancy Davolio", "OrderID": "10351", "OrderDate": "12/12/94", "RequiredDate": "1/9/95", "ShippedDate": "12/21/94", "Shippers_CompanyName": "Speedy Express", "ProductID": "38", "ProductName": "Côte de Blaye", "UnitPrice": 210.80, "Quantity": "20", "Discount": 0.050000001, "ExtendedPrice": 5.20, "Freight": 162.33 }, { "ShipName": "Ernst Handel", "ShipAddress": "Kirchgasse 6", "ShipCity": "Graz", "ShipPostalCode": "8010", "ShipCountry": "Austria", "CustomerID": "ERNSH", "Customers_CompanyName": "Ernst Handel", "Address": "Kirchgasse 6", "City": "Graz", "PostalCode": "8010", "Country": "Austria", "Salesperson": "Nancy Davolio", "OrderID": "10351", "OrderDate": "12/12/94", "RequiredDate": "1/9/95", "ShippedDate": "12/21/94", "Shippers_CompanyName": "Speedy Express", "ProductID": "41", "ProductName": "Jack's New England Clam Chowder", "UnitPrice": 7.70, "Quantity": "13", "Discount": 0, "ExtendedPrice": 100.10, "Freight": 162.33 }, { "ShipName": "Ernst Handel", "ShipAddress": "Kirchgasse 6", "ShipCity": "Graz", "ShipPostalCode": "8010", "ShipCountry": "Austria", "CustomerID": "ERNSH", "Customers_CompanyName": "Ernst Handel", "Address": "Kirchgasse 6", "City": "Graz", "PostalCode": "8010", "Country": "Austria", "Salesperson": "Nancy Davolio", "OrderID": "10351", "OrderDate": "12/12/94", "RequiredDate": "1/9/95", "ShippedDate": "12/21/94", "Shippers_CompanyName": "Speedy Express", "ProductID": "44", "ProductName": "Gula Malacca", "UnitPrice": 15.50, "Quantity": "77", "Discount": 0.050000001, "ExtendedPrice": 133.82, "Freight": 162.33 }, { "ShipName": "Ernst Handel", "ShipAddress": "Kirchgasse 6", "ShipCity": "Graz", "ShipPostalCode": "8010", "ShipCountry": "Austria", "CustomerID": "ERNSH", "Customers_CompanyName": "Ernst Handel", "Address": "Kirchgasse 6", "City": "Graz", "PostalCode": "8010", "Country": "Austria", "Salesperson": "Nancy Davolio", "OrderID": "10351", "OrderDate": "12/12/94", "RequiredDate": "1/9/95", "ShippedDate": "12/21/94", "Shippers_CompanyName": "Speedy Express", "ProductID": "65", "ProductName": "Louisiana Fiery Hot Pepper Sauce", "UnitPrice": 16.80, "Quantity": "10", "Discount": 0.050000001, "ExtendedPrice": 159.60, "Freight": 162.33 }, { "ShipName": "Furia Bacalhau e Frutos do Mar", "ShipAddress": "Jardim das rosas n. 32", "ShipCity": "Lisboa", "ShipPostalCode": "1675", "ShipCountry": "Portugal", "CustomerID": "FURIB", "Customers_CompanyName": "Furia Bacalhau e Frutos do Mar", "Address": "Jardim das rosas n. 32", "City": "Lisboa", "PostalCode": "1675", "Country": "Portugal", "Salesperson": "Janet Leverling", "OrderID": "10352", "OrderDate": "12/13/94", "RequiredDate": "12/27/94", "ShippedDate": "12/19/94", "Shippers_CompanyName": "Federal Shipping", "ProductID": "24", "ProductName": "Guaraná Fantástica", "UnitPrice": 3.60, "Quantity": "10", "Discount": 0, "ExtendedPrice": 36.00, "Freight": 1.30 }, { "ShipName": "Furia Bacalhau e Frutos do Mar", "ShipAddress": "Jardim das rosas n. 32", "ShipCity": "Lisboa", "ShipPostalCode": "1675", "ShipCountry": "Portugal", "CustomerID": "FURIB", "Customers_CompanyName": "Furia Bacalhau e Frutos do Mar", "Address": "Jardim das rosas n. 32", "City": "Lisboa", "PostalCode": "1675", "Country": "Portugal", "Salesperson": "Janet Leverling", "OrderID": "10352", "OrderDate": "12/13/94", "RequiredDate": "12/27/94", "ShippedDate": "12/19/94", "Shippers_CompanyName": "Federal Shipping", "ProductID": "54", "ProductName": "Tourtière", "UnitPrice": 5.90, "Quantity": "20", "Discount": 0.150000006, "ExtendedPrice": 100.30, "Freight": 1.30 }, { "ShipName": "Piccolo und mehr", "ShipAddress": "Geislweg 14", "ShipCity": "Salzburg", "ShipPostalCode": "5020", "ShipCountry": "Austria", "CustomerID": "PICCO", "Customers_CompanyName": "Piccolo und mehr", "Address": "Geislweg 14", "City": "Salzburg", "PostalCode": "5020", "Country": "Austria", "Salesperson": "Robert King", "OrderID": "10353", "OrderDate": "12/14/94", "RequiredDate": "1/11/95", "ShippedDate": "12/26/94", "Shippers_CompanyName": "Federal Shipping", "ProductID": "11", "ProductName": "Queso Cabrales", "UnitPrice": 16.80, "Quantity": "12", "Discount": 0.200000003, "ExtendedPrice": 161.28, "Freight": 360.63 }, { "ShipName": "Piccolo und mehr", "ShipAddress": "Geislweg 14", "ShipCity": "Salzburg", "ShipPostalCode": "5020", "ShipCountry": "Austria", "CustomerID": "PICCO", "Customers_CompanyName": "Piccolo und mehr", "Address": "Geislweg 14", "City": "Salzburg", "PostalCode": "5020", "Country": "Austria", "Salesperson": "Robert King", "OrderID": "10353", "OrderDate": "12/14/94", "RequiredDate": "1/11/95", "ShippedDate": "12/26/94", "Shippers_CompanyName": "Federal Shipping", "ProductID": "38", "ProductName": "Côte de Blaye", "UnitPrice": 210.80, "Quantity": "50", "Discount": 0.200000003, "ExtendedPrice": 432.00, "Freight": 360.63 }, { "ShipName": "Pericles Comidas clásicas", "ShipAddress": "Calle Dr. Jorge Cash 321", "ShipCity": "México D.F.", "ShipPostalCode": "05033", "ShipCountry": "Mexico", "CustomerID": "PERIC", "Customers_CompanyName": "Pericles Comidas clásicas", "Address": "Calle Dr. Jorge Cash 321", "City": "México D.F.", "PostalCode": "05033", "Country": "Mexico", "Salesperson": "Laura Callahan", "OrderID": "10354", "OrderDate": "12/15/94", "RequiredDate": "1/12/95", "ShippedDate": "12/21/94", "Shippers_CompanyName": "Federal Shipping", "ProductID": "1", "ProductName": "Chai", "UnitPrice": 14.40, "Quantity": "12", "Discount": 0, "ExtendedPrice": 172.80, "Freight": 53.80 }, { "ShipName": "Pericles Comidas clásicas", "ShipAddress": "Calle Dr. Jorge Cash 321", "ShipCity": "México D.F.", "ShipPostalCode": "05033", "ShipCountry": "Mexico", "CustomerID": "PERIC", "Customers_CompanyName": "Pericles Comidas clásicas", "Address": "Calle Dr. Jorge Cash 321", "City": "México D.F.", "PostalCode": "05033", "Country": "Mexico", "Salesperson": "Laura Callahan", "OrderID": "10354", "OrderDate": "12/15/94", "RequiredDate": "1/12/95", "ShippedDate": "12/21/94", "Shippers_CompanyName": "Federal Shipping", "ProductID": "29", "ProductName": "Thüringer Rostbratwurst", "UnitPrice": 99.00, "Quantity": "4", "Discount": 0, "ExtendedPrice": 396.00, "Freight": 53.80 }, { "ShipName": "Around the Horn", "ShipAddress": "Brook Farm\r\r\nStratford St. Mary", "ShipCity": "Colchester", "ShipRegion": "Essex", "ShipPostalCode": "CO7 6JX", "ShipCountry": "UK", "CustomerID": "AROUT", "Customers_CompanyName": "Around the Horn", "Address": "120 Hanover Sq.", "City": "London", "PostalCode": "WA1 1DP", "Country": "UK", "Salesperson": "Michael Suyama", "OrderID": "10355", "OrderDate": "12/16/94", "RequiredDate": "1/13/95", "ShippedDate": "12/21/94", "Shippers_CompanyName": "Speedy Express", "ProductID": "24", "ProductName": "Guaraná Fantástica", "UnitPrice": 3.60, "Quantity": "25", "Discount": 0, "ExtendedPrice": 90.00, "Freight": 41.95 }, { "ShipName": "Around the Horn", "ShipAddress": "Brook Farm\r\r\nStratford St. Mary", "ShipCity": "Colchester", "ShipRegion": "Essex", "ShipPostalCode": "CO7 6JX", "ShipCountry": "UK", "CustomerID": "AROUT", "Customers_CompanyName": "Around the Horn", "Address": "120 Hanover Sq.", "City": "London", "PostalCode": "WA1 1DP", "Country": "UK", "Salesperson": "Michael Suyama", "OrderID": "10355", "OrderDate": "12/16/94", "RequiredDate": "1/13/95", "ShippedDate": "12/21/94", "Shippers_CompanyName": "Speedy Express", "ProductID": "57", "ProductName": "Ravioli Angelo", "UnitPrice": 15.60, "Quantity": "25", "Discount": 0, "ExtendedPrice": 390.00, "Freight": 41.95 }, { "ShipName": "Die Wandernde Kuh", "ShipAddress": "Adenauerallee 900", "ShipCity": "Stuttgart", "ShipPostalCode": "70563", "ShipCountry": "Germany", "CustomerID": "WANDK", "Customers_CompanyName": "Die Wandernde Kuh", "Address": "Adenauerallee 900", "City": "Stuttgart", "PostalCode": "70563", "Country": "Germany", "Salesperson": "Michael Suyama", "OrderID": "10356", "OrderDate": "12/19/94", "RequiredDate": "1/16/95", "ShippedDate": "12/28/94", "Shippers_CompanyName": "United Package", "ProductID": "31", "ProductName": "Gorgonzola Telino", "UnitPrice": 10.00, "Quantity": "30", "Discount": 0, "ExtendedPrice": 300.00, "Freight": 36.71 }, { "ShipName": "Die Wandernde Kuh", "ShipAddress": "Adenauerallee 900", "ShipCity": "Stuttgart", "ShipPostalCode": "70563", "ShipCountry": "Germany", "CustomerID": "WANDK", "Customers_CompanyName": "Die Wandernde Kuh", "Address": "Adenauerallee 900", "City": "Stuttgart", "PostalCode": "70563", "Country": "Germany", "Salesperson": "Michael Suyama", "OrderID": "10356", "OrderDate": "12/19/94", "RequiredDate": "1/16/95", "ShippedDate": "12/28/94", "Shippers_CompanyName": "United Package", "ProductID": "55", "ProductName": "Pâté chinois", "UnitPrice": 19.20, "Quantity": "12", "Discount": 0, "ExtendedPrice": 230.40, "Freight": 36.71 }, { "ShipName": "Die Wandernde Kuh", "ShipAddress": "Adenauerallee 900", "ShipCity": "Stuttgart", "ShipPostalCode": "70563", "ShipCountry": "Germany", "CustomerID": "WANDK", "Customers_CompanyName": "Die Wandernde Kuh", "Address": "Adenauerallee 900", "City": "Stuttgart", "PostalCode": "70563", "Country": "Germany", "Salesperson": "Michael Suyama", "OrderID": "10356", "OrderDate": "12/19/94", "RequiredDate": "1/16/95", "ShippedDate": "12/28/94", "Shippers_CompanyName": "United Package", "ProductID": "69", "ProductName": "Gudbrandsdalsost", "UnitPrice": 28.80, "Quantity": "20", "Discount": 0, "ExtendedPrice": 576.00, "Freight": 36.71 }, { "ShipName": "LILA-Supermercado", "ShipAddress": "Carrera 52 con Ave. Bolívar #65-98 Llano Largo", "ShipCity": "Barquisimeto", "ShipRegion": "Lara", "ShipPostalCode": "3508", "ShipCountry": "Venezuela", "CustomerID": "LILAS", "Customers_CompanyName": "LILA-Supermercado", "Address": "Carrera 52 con Ave. Bolívar #65-98 Llano Largo", "City": "Barquisimeto", "Region": "Lara", "PostalCode": "3508", "Country": "Venezuela", "Salesperson": "Nancy Davolio", "OrderID": "10357", "OrderDate": "12/20/94", "RequiredDate": "1/17/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "10", "ProductName": "Ikura", "UnitPrice": 24.80, "Quantity": "30", "Discount": 0.200000003, "ExtendedPrice": 595.20, "Freight": 34.88 }, { "ShipName": "LILA-Supermercado", "ShipAddress": "Carrera 52 con Ave. Bolívar #65-98 Llano Largo", "ShipCity": "Barquisimeto", "ShipRegion": "Lara", "ShipPostalCode": "3508", "ShipCountry": "Venezuela", "CustomerID": "LILAS", "Customers_CompanyName": "LILA-Supermercado", "Address": "Carrera 52 con Ave. Bolívar #65-98 Llano Largo", "City": "Barquisimeto", "Region": "Lara", "PostalCode": "3508", "Country": "Venezuela", "Salesperson": "Nancy Davolio", "OrderID": "10357", "OrderDate": "12/20/94", "RequiredDate": "1/17/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "26", "ProductName": "Gumbär Gummibärchen", "UnitPrice": 24.90, "Quantity": "16", "Discount": 0, "ExtendedPrice": 398.40, "Freight": 34.88 }, { "ShipName": "LILA-Supermercado", "ShipAddress": "Carrera 52 con Ave. Bolívar #65-98 Llano Largo", "ShipCity": "Barquisimeto", "ShipRegion": "Lara", "ShipPostalCode": "3508", "ShipCountry": "Venezuela", "CustomerID": "LILAS", "Customers_CompanyName": "LILA-Supermercado", "Address": "Carrera 52 con Ave. Bolívar #65-98 Llano Largo", "City": "Barquisimeto", "Region": "Lara", "PostalCode": "3508", "Country": "Venezuela", "Salesperson": "Nancy Davolio", "OrderID": "10357", "OrderDate": "12/20/94", "RequiredDate": "1/17/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "60", "ProductName": "Camembert Pierrot", "UnitPrice": 27.20, "Quantity": "8", "Discount": 0.200000003, "ExtendedPrice": 174.08, "Freight": 34.88 }, { "ShipName": "La maison d'Asie", "ShipAddress": "1 rue Alsace-Lorraine", "ShipCity": "Toulouse", "ShipPostalCode": "31000", "ShipCountry": "France", "CustomerID": "LAMAI", "Customers_CompanyName": "La maison d'Asie", "Address": "1 rue Alsace-Lorraine", "City": "Toulouse", "PostalCode": "31000", "Country": "France", "Salesperson": "Steven Buchanan", "OrderID": "10358", "OrderDate": "12/21/94", "RequiredDate": "1/18/95", "ShippedDate": "12/28/94", "Shippers_CompanyName": "Speedy Express", "ProductID": "24", "ProductName": "Guaraná Fantástica", "UnitPrice": 3.60, "Quantity": "10", "Discount": 0.050000001, "ExtendedPrice": 34.20, "Freight": 19.64 }, { "ShipName": "La maison d'Asie", "ShipAddress": "1 rue Alsace-Lorraine", "ShipCity": "Toulouse", "ShipPostalCode": "31000", "ShipCountry": "France", "CustomerID": "LAMAI", "Customers_CompanyName": "La maison d'Asie", "Address": "1 rue Alsace-Lorraine", "City": "Toulouse", "PostalCode": "31000", "Country": "France", "Salesperson": "Steven Buchanan", "OrderID": "10358", "OrderDate": "12/21/94", "RequiredDate": "1/18/95", "ShippedDate": "12/28/94", "Shippers_CompanyName": "Speedy Express", "ProductID": "34", "ProductName": "Sasquatch Ale", "UnitPrice": 11.20, "Quantity": "10", "Discount": 0.050000001, "ExtendedPrice": 106.40, "Freight": 19.64 }, { "ShipName": "La maison d'Asie", "ShipAddress": "1 rue Alsace-Lorraine", "ShipCity": "Toulouse", "ShipPostalCode": "31000", "ShipCountry": "France", "CustomerID": "LAMAI", "Customers_CompanyName": "La maison d'Asie", "Address": "1 rue Alsace-Lorraine", "City": "Toulouse", "PostalCode": "31000", "Country": "France", "Salesperson": "Steven Buchanan", "OrderID": "10358", "OrderDate": "12/21/94", "RequiredDate": "1/18/95", "ShippedDate": "12/28/94", "Shippers_CompanyName": "Speedy Express", "ProductID": "36", "ProductName": "Inlagd Sill", "UnitPrice": 15.20, "Quantity": "20", "Discount": 0.050000001, "ExtendedPrice": 288.80, "Freight": 19.64 }, { "ShipName": "Seven Seas Imports", "ShipAddress": "90 Wadhurst Rd.", "ShipCity": "London", "ShipPostalCode": "OX15 4NB", "ShipCountry": "UK", "CustomerID": "SEVES", "Customers_CompanyName": "Seven Seas Imports", "Address": "90 Wadhurst Rd.", "City": "London", "PostalCode": "OX15 4NB", "Country": "UK", "Salesperson": "Steven Buchanan", "OrderID": "10359", "OrderDate": "12/22/94", "RequiredDate": "1/19/95", "ShippedDate": "12/27/94", "Shippers_CompanyName": "Federal Shipping", "ProductID": "16", "ProductName": "Pavlova", "UnitPrice": 13.90, "Quantity": "56", "Discount": 0.050000001, "ExtendedPrice": 739.48, "Freight": 288.43 }, { "ShipName": "Seven Seas Imports", "ShipAddress": "90 Wadhurst Rd.", "ShipCity": "London", "ShipPostalCode": "OX15 4NB", "ShipCountry": "UK", "CustomerID": "SEVES", "Customers_CompanyName": "Seven Seas Imports", "Address": "90 Wadhurst Rd.", "City": "London", "PostalCode": "OX15 4NB", "Country": "UK", "Salesperson": "Steven Buchanan", "OrderID": "10359", "OrderDate": "12/22/94", "RequiredDate": "1/19/95", "ShippedDate": "12/27/94", "Shippers_CompanyName": "Federal Shipping", "ProductID": "31", "ProductName": "Gorgonzola Telino", "UnitPrice": 10.00, "Quantity": "70", "Discount": 0.050000001, "ExtendedPrice": 665.00, "Freight": 288.43 }, { "ShipName": "Seven Seas Imports", "ShipAddress": "90 Wadhurst Rd.", "ShipCity": "London", "ShipPostalCode": "OX15 4NB", "ShipCountry": "UK", "CustomerID": "SEVES", "Customers_CompanyName": "Seven Seas Imports", "Address": "90 Wadhurst Rd.", "City": "London", "PostalCode": "OX15 4NB", "Country": "UK", "Salesperson": "Steven Buchanan", "OrderID": "10359", "OrderDate": "12/22/94", "RequiredDate": "1/19/95", "ShippedDate": "12/27/94", "Shippers_CompanyName": "Federal Shipping", "ProductID": "60", "ProductName": "Camembert Pierrot", "UnitPrice": 27.20, "Quantity": "80", "Discount": 0.050000001, "ExtendedPrice": 67.20, "Freight": 288.43 }, { "ShipName": "Blondel père et fils", "ShipAddress": "24, place Kléber", "ShipCity": "Strasbourg", "ShipPostalCode": "67000", "ShipCountry": "France", "CustomerID": "BLONP", "Customers_CompanyName": "Blondel père et fils", "Address": "24, place Kléber", "City": "Strasbourg", "PostalCode": "67000", "Country": "France", "Salesperson": "Margaret Peacock", "OrderID": "10360", "OrderDate": "12/23/94", "RequiredDate": "1/20/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "28", "ProductName": "Rössle Sauerkraut", "UnitPrice": 36.40, "Quantity": "30", "Discount": 0, "ExtendedPrice": 92.00, "Freight": 131.70 }, { "ShipName": "Blondel père et fils", "ShipAddress": "24, place Kléber", "ShipCity": "Strasbourg", "ShipPostalCode": "67000", "ShipCountry": "France", "CustomerID": "BLONP", "Customers_CompanyName": "Blondel père et fils", "Address": "24, place Kléber", "City": "Strasbourg", "PostalCode": "67000", "Country": "France", "Salesperson": "Margaret Peacock", "OrderID": "10360", "OrderDate": "12/23/94", "RequiredDate": "1/20/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "29", "ProductName": "Thüringer Rostbratwurst", "UnitPrice": 99.00, "Quantity": "35", "Discount": 0, "ExtendedPrice": 465.00, "Freight": 131.70 }, { "ShipName": "Blondel père et fils", "ShipAddress": "24, place Kléber", "ShipCity": "Strasbourg", "ShipPostalCode": "67000", "ShipCountry": "France", "CustomerID": "BLONP", "Customers_CompanyName": "Blondel père et fils", "Address": "24, place Kléber", "City": "Strasbourg", "PostalCode": "67000", "Country": "France", "Salesperson": "Margaret Peacock", "OrderID": "10360", "OrderDate": "12/23/94", "RequiredDate": "1/20/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "38", "ProductName": "Côte de Blaye", "UnitPrice": 210.80, "Quantity": "10", "Discount": 0, "ExtendedPrice": 108.00, "Freight": 131.70 }, { "ShipName": "Blondel père et fils", "ShipAddress": "24, place Kléber", "ShipCity": "Strasbourg", "ShipPostalCode": "67000", "ShipCountry": "France", "CustomerID": "BLONP", "Customers_CompanyName": "Blondel père et fils", "Address": "24, place Kléber", "City": "Strasbourg", "PostalCode": "67000", "Country": "France", "Salesperson": "Margaret Peacock", "OrderID": "10360", "OrderDate": "12/23/94", "RequiredDate": "1/20/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "49", "ProductName": "Maxilaku", "UnitPrice": 16.00, "Quantity": "35", "Discount": 0, "ExtendedPrice": 560.00, "Freight": 131.70 }, { "ShipName": "Blondel père et fils", "ShipAddress": "24, place Kléber", "ShipCity": "Strasbourg", "ShipPostalCode": "67000", "ShipCountry": "France", "CustomerID": "BLONP", "Customers_CompanyName": "Blondel père et fils", "Address": "24, place Kléber", "City": "Strasbourg", "PostalCode": "67000", "Country": "France", "Salesperson": "Margaret Peacock", "OrderID": "10360", "OrderDate": "12/23/94", "RequiredDate": "1/20/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "54", "ProductName": "Tourtière", "UnitPrice": 5.90, "Quantity": "28", "Discount": 0, "ExtendedPrice": 165.20, "Freight": 131.70 }, { "ShipName": "QUICK-Stop", "ShipAddress": "Taucherstraße 10", "ShipCity": "Cunewalde", "ShipPostalCode": "01307", "ShipCountry": "Germany", "CustomerID": "QUICK", "Customers_CompanyName": "QUICK-Stop", "Address": "Taucherstraße 10", "City": "Cunewalde", "PostalCode": "01307", "Country": "Germany", "Salesperson": "Nancy Davolio", "OrderID": "10361", "OrderDate": "12/23/94", "RequiredDate": "1/20/95", "ShippedDate": "1/3/95", "Shippers_CompanyName": "United Package", "ProductID": "39", "ProductName": "Chartreuse verte", "UnitPrice": 14.40, "Quantity": "54", "Discount": 0.100000001, "ExtendedPrice": 699.84, "Freight": 183.17 }, { "ShipName": "QUICK-Stop", "ShipAddress": "Taucherstraße 10", "ShipCity": "Cunewalde", "ShipPostalCode": "01307", "ShipCountry": "Germany", "CustomerID": "QUICK", "Customers_CompanyName": "QUICK-Stop", "Address": "Taucherstraße 10", "City": "Cunewalde", "PostalCode": "01307", "Country": "Germany", "Salesperson": "Nancy Davolio", "OrderID": "10361", "OrderDate": "12/23/94", "RequiredDate": "1/20/95", "ShippedDate": "1/3/95", "Shippers_CompanyName": "United Package", "ProductID": "60", "ProductName": "Camembert Pierrot", "UnitPrice": 27.20, "Quantity": "55", "Discount": 0.100000001, "ExtendedPrice": 346.40, "Freight": 183.17 }, { "ShipName": "Bon app'", "ShipAddress": "12, rue des Bouchers", "ShipCity": "Marseille", "ShipPostalCode": "13008", "ShipCountry": "France", "CustomerID": "BONAP", "Customers_CompanyName": "Bon app'", "Address": "12, rue des Bouchers", "City": "Marseille", "PostalCode": "13008", "Country": "France", "Salesperson": "Janet Leverling", "OrderID": "10362", "OrderDate": "12/26/94", "RequiredDate": "1/23/95", "ShippedDate": "12/29/94", "Shippers_CompanyName": "Speedy Express", "ProductID": "25", "ProductName": "NuNuCa Nuß-Nougat-Creme", "UnitPrice": 11.20, "Quantity": "50", "Discount": 0, "ExtendedPrice": 560.00, "Freight": 96.04 }, { "ShipName": "Bon app'", "ShipAddress": "12, rue des Bouchers", "ShipCity": "Marseille", "ShipPostalCode": "13008", "ShipCountry": "France", "CustomerID": "BONAP", "Customers_CompanyName": "Bon app'", "Address": "12, rue des Bouchers", "City": "Marseille", "PostalCode": "13008", "Country": "France", "Salesperson": "Janet Leverling", "OrderID": "10362", "OrderDate": "12/26/94", "RequiredDate": "1/23/95", "ShippedDate": "12/29/94", "Shippers_CompanyName": "Speedy Express", "ProductID": "51", "ProductName": "Manjimup Dried Apples", "UnitPrice": 42.40, "Quantity": "20", "Discount": 0, "ExtendedPrice": 848.00, "Freight": 96.04 }, { "ShipName": "Bon app'", "ShipAddress": "12, rue des Bouchers", "ShipCity": "Marseille", "ShipPostalCode": "13008", "ShipCountry": "France", "CustomerID": "BONAP", "Customers_CompanyName": "Bon app'", "Address": "12, rue des Bouchers", "City": "Marseille", "PostalCode": "13008", "Country": "France", "Salesperson": "Janet Leverling", "OrderID": "10362", "OrderDate": "12/26/94", "RequiredDate": "1/23/95", "ShippedDate": "12/29/94", "Shippers_CompanyName": "Speedy Express", "ProductID": "54", "ProductName": "Tourtière", "UnitPrice": 5.90, "Quantity": "24", "Discount": 0, "ExtendedPrice": 141.60, "Freight": 96.04 }, { "ShipName": "Drachenblut Delikatessen", "ShipAddress": "Walserweg 21", "ShipCity": "Aachen", "ShipPostalCode": "52066", "ShipCountry": "Germany", "CustomerID": "DRACD", "Customers_CompanyName": "Drachenblut Delikatessen", "Address": "Walserweg 21", "City": "Aachen", "PostalCode": "52066", "Country": "Germany", "Salesperson": "Margaret Peacock", "OrderID": "10363", "OrderDate": "12/27/94", "RequiredDate": "1/24/95", "ShippedDate": "1/4/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "31", "ProductName": "Gorgonzola Telino", "UnitPrice": 10.00, "Quantity": "20", "Discount": 0, "ExtendedPrice": 200.00, "Freight": 30.54 }, { "ShipName": "Drachenblut Delikatessen", "ShipAddress": "Walserweg 21", "ShipCity": "Aachen", "ShipPostalCode": "52066", "ShipCountry": "Germany", "CustomerID": "DRACD", "Customers_CompanyName": "Drachenblut Delikatessen", "Address": "Walserweg 21", "City": "Aachen", "PostalCode": "52066", "Country": "Germany", "Salesperson": "Margaret Peacock", "OrderID": "10363", "OrderDate": "12/27/94", "RequiredDate": "1/24/95", "ShippedDate": "1/4/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "75", "ProductName": "Rhönbräu Klosterbier", "UnitPrice": 6.20, "Quantity": "12", "Discount": 0, "ExtendedPrice": 74.40, "Freight": 30.54 }, { "ShipName": "Drachenblut Delikatessen", "ShipAddress": "Walserweg 21", "ShipCity": "Aachen", "ShipPostalCode": "52066", "ShipCountry": "Germany", "CustomerID": "DRACD", "Customers_CompanyName": "Drachenblut Delikatessen", "Address": "Walserweg 21", "City": "Aachen", "PostalCode": "52066", "Country": "Germany", "Salesperson": "Margaret Peacock", "OrderID": "10363", "OrderDate": "12/27/94", "RequiredDate": "1/24/95", "ShippedDate": "1/4/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "76", "ProductName": "Lakkalikööri", "UnitPrice": 14.40, "Quantity": "12", "Discount": 0, "ExtendedPrice": 172.80, "Freight": 30.54 }, { "ShipName": "Eastern Connection", "ShipAddress": "35 King George", "ShipCity": "London", "ShipPostalCode": "WX3 6FW", "ShipCountry": "UK", "CustomerID": "EASTC", "Customers_CompanyName": "Eastern Connection", "Address": "35 King George", "City": "London", "PostalCode": "WX3 6FW", "Country": "UK", "Salesperson": "Nancy Davolio", "OrderID": "10364", "OrderDate": "12/27/94", "RequiredDate": "2/7/95", "ShippedDate": "1/4/95", "Shippers_CompanyName": "Speedy Express", "ProductID": "69", "ProductName": "Gudbrandsdalsost", "UnitPrice": 28.80, "Quantity": "30", "Discount": 0, "ExtendedPrice": 864.00, "Freight": 71.97 }, { "ShipName": "Eastern Connection", "ShipAddress": "35 King George", "ShipCity": "London", "ShipPostalCode": "WX3 6FW", "ShipCountry": "UK", "CustomerID": "EASTC", "Customers_CompanyName": "Eastern Connection", "Address": "35 King George", "City": "London", "PostalCode": "WX3 6FW", "Country": "UK", "Salesperson": "Nancy Davolio", "OrderID": "10364", "OrderDate": "12/27/94", "RequiredDate": "2/7/95", "ShippedDate": "1/4/95", "Shippers_CompanyName": "Speedy Express", "ProductID": "71", "ProductName": "Fløtemysost", "UnitPrice": 17.20, "Quantity": "5", "Discount": 0, "ExtendedPrice": 86.00, "Freight": 71.97 }, { "ShipName": "Antonio Moreno Taquería", "ShipAddress": "Mataderos 2312", "ShipCity": "México D.F.", "ShipPostalCode": "05023", "ShipCountry": "Mexico", "CustomerID": "ANTON", "Customers_CompanyName": "Antonio Moreno Taquería", "Address": "Mataderos 2312", "City": "México D.F.", "PostalCode": "05023", "Country": "Mexico", "Salesperson": "Janet Leverling", "OrderID": "10365", "OrderDate": "12/28/94", "RequiredDate": "1/25/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "United Package", "ProductID": "11", "ProductName": "Queso Cabrales", "UnitPrice": 16.80, "Quantity": "24", "Discount": 0, "ExtendedPrice": 403.20, "Freight": 22.00 }, { "ShipName": "Galería del gastronómo", "ShipAddress": "Rambla de Cataluña, 23", "ShipCity": "Barcelona", "ShipPostalCode": "8022", "ShipCountry": "Spain", "CustomerID": "GALED", "Customers_CompanyName": "Galería del gastrónomo", "Address": "Rambla de Cataluña, 23", "City": "Barcelona", "PostalCode": "08022", "Country": "Spain", "Salesperson": "Laura Callahan", "OrderID": "10366", "OrderDate": "12/29/94", "RequiredDate": "2/9/95", "ShippedDate": "1/30/95", "Shippers_CompanyName": "United Package", "ProductID": "65", "ProductName": "Louisiana Fiery Hot Pepper Sauce", "UnitPrice": 16.80, "Quantity": "5", "Discount": 0, "ExtendedPrice": 84.00, "Freight": 10.14 }, { "ShipName": "Galería del gastronómo", "ShipAddress": "Rambla de Cataluña, 23", "ShipCity": "Barcelona", "ShipPostalCode": "8022", "ShipCountry": "Spain", "CustomerID": "GALED", "Customers_CompanyName": "Galería del gastrónomo", "Address": "Rambla de Cataluña, 23", "City": "Barcelona", "PostalCode": "08022", "Country": "Spain", "Salesperson": "Laura Callahan", "OrderID": "10366", "OrderDate": "12/29/94", "RequiredDate": "2/9/95", "ShippedDate": "1/30/95", "Shippers_CompanyName": "United Package", "ProductID": "77", "ProductName": "Original Frankfurter grüne Soße", "UnitPrice": 10.40, "Quantity": "5", "Discount": 0, "ExtendedPrice": 52.00, "Freight": 10.14 }, { "ShipName": "Vaffeljernet", "ShipAddress": "Smagsløget 45", "ShipCity": "Århus", "ShipPostalCode": "8200", "ShipCountry": "Denmark", "CustomerID": "VAFFE", "Customers_CompanyName": "Vaffeljernet", "Address": "Smagsløget 45", "City": "Århus", "PostalCode": "8200", "Country": "Denmark", "Salesperson": "Robert King", "OrderID": "10367", "OrderDate": "12/29/94", "RequiredDate": "1/26/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "34", "ProductName": "Sasquatch Ale", "UnitPrice": 11.20, "Quantity": "36", "Discount": 0, "ExtendedPrice": 403.20, "Freight": 13.55 }, { "ShipName": "Vaffeljernet", "ShipAddress": "Smagsløget 45", "ShipCity": "Århus", "ShipPostalCode": "8200", "ShipCountry": "Denmark", "CustomerID": "VAFFE", "Customers_CompanyName": "Vaffeljernet", "Address": "Smagsløget 45", "City": "Århus", "PostalCode": "8200", "Country": "Denmark", "Salesperson": "Robert King", "OrderID": "10367", "OrderDate": "12/29/94", "RequiredDate": "1/26/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "54", "ProductName": "Tourtière", "UnitPrice": 5.90, "Quantity": "18", "Discount": 0, "ExtendedPrice": 106.20, "Freight": 13.55 }, { "ShipName": "Vaffeljernet", "ShipAddress": "Smagsløget 45", "ShipCity": "Århus", "ShipPostalCode": "8200", "ShipCountry": "Denmark", "CustomerID": "VAFFE", "Customers_CompanyName": "Vaffeljernet", "Address": "Smagsløget 45", "City": "Århus", "PostalCode": "8200", "Country": "Denmark", "Salesperson": "Robert King", "OrderID": "10367", "OrderDate": "12/29/94", "RequiredDate": "1/26/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "65", "ProductName": "Louisiana Fiery Hot Pepper Sauce", "UnitPrice": 16.80, "Quantity": "15", "Discount": 0, "ExtendedPrice": 252.00, "Freight": 13.55 }, { "ShipName": "Vaffeljernet", "ShipAddress": "Smagsløget 45", "ShipCity": "Århus", "ShipPostalCode": "8200", "ShipCountry": "Denmark", "CustomerID": "VAFFE", "Customers_CompanyName": "Vaffeljernet", "Address": "Smagsløget 45", "City": "Århus", "PostalCode": "8200", "Country": "Denmark", "Salesperson": "Robert King", "OrderID": "10367", "OrderDate": "12/29/94", "RequiredDate": "1/26/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "Federal Shipping", "ProductID": "77", "ProductName": "Original Frankfurter grüne Soße", "UnitPrice": 10.40, "Quantity": "7", "Discount": 0, "ExtendedPrice": 72.80, "Freight": 13.55 }, { "ShipName": "Ernst Handel", "ShipAddress": "Kirchgasse 6", "ShipCity": "Graz", "ShipPostalCode": "8010", "ShipCountry": "Austria", "CustomerID": "ERNSH", "Customers_CompanyName": "Ernst Handel", "Address": "Kirchgasse 6", "City": "Graz", "PostalCode": "8010", "Country": "Austria", "Salesperson": "Andrew Fuller", "OrderID": "10368", "OrderDate": "12/30/94", "RequiredDate": "1/27/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "United Package", "ProductID": "21", "ProductName": "Sir Rodney's Scones", "UnitPrice": 8.00, "Quantity": "5", "Discount": 0.100000001, "ExtendedPrice": 36.00, "Freight": 101.95 }, { "ShipName": "Ernst Handel", "ShipAddress": "Kirchgasse 6", "ShipCity": "Graz", "ShipPostalCode": "8010", "ShipCountry": "Austria", "CustomerID": "ERNSH", "Customers_CompanyName": "Ernst Handel", "Address": "Kirchgasse 6", "City": "Graz", "PostalCode": "8010", "Country": "Austria", "Salesperson": "Andrew Fuller", "OrderID": "10368", "OrderDate": "12/30/94", "RequiredDate": "1/27/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "United Package", "ProductID": "28", "ProductName": "Rössle Sauerkraut", "UnitPrice": 36.40, "Quantity": "13", "Discount": 0.100000001, "ExtendedPrice": 425.88, "Freight": 101.95 }, { "ShipName": "Ernst Handel", "ShipAddress": "Kirchgasse 6", "ShipCity": "Graz", "ShipPostalCode": "8010", "ShipCountry": "Austria", "CustomerID": "ERNSH", "Customers_CompanyName": "Ernst Handel", "Address": "Kirchgasse 6", "City": "Graz", "PostalCode": "8010", "Country": "Austria", "Salesperson": "Andrew Fuller", "OrderID": "10368", "OrderDate": "12/30/94", "RequiredDate": "1/27/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "United Package", "ProductID": "57", "ProductName": "Ravioli Angelo", "UnitPrice": 15.60, "Quantity": "25", "Discount": 0, "ExtendedPrice": 390.00, "Freight": 101.95 }, { "ShipName": "Ernst Handel", "ShipAddress": "Kirchgasse 6", "ShipCity": "Graz", "ShipPostalCode": "8010", "ShipCountry": "Austria", "CustomerID": "ERNSH", "Customers_CompanyName": "Ernst Handel", "Address": "Kirchgasse 6", "City": "Graz", "PostalCode": "8010", "Country": "Austria", "Salesperson": "Andrew Fuller", "OrderID": "10368", "OrderDate": "12/30/94", "RequiredDate": "1/27/95", "ShippedDate": "1/2/95", "Shippers_CompanyName": "United Package", "ProductID": "64", "ProductName": "Wimmers gute Semmelknödel", "UnitPrice": 26.60, "Quantity": "35", "Discount": 0.100000001, "ExtendedPrice": 837.90, "Freight": 101.95 }, { "ShipName": "Split Rail Beer & Ale", "ShipAddress": "P.O. Box 555", "ShipCity": "Lander", "ShipRegion": "WY", "ShipPostalCode": "82520", "ShipCountry": "USA", "CustomerID": "SPLIR", "Customers_CompanyName": "Split Rail Beer & Ale", "Address": "P.O. Box 555", "City": "Lander", "Region": "WY", "PostalCode": "82520", "Country": "USA", "Salesperson": "Laura Callahan", "OrderID": "10369", "OrderDate": "1/2/95", "RequiredDate": "1/30/95", "ShippedDate": "1/9/95", "Shippers_CompanyName": "United Package", "ProductID": "29", "ProductName": "Thüringer Rostbratwurst", "UnitPrice": 99.00, "Quantity": "20", "Discount": 0, "ExtendedPrice": 980.00, "Freight": 195.68 }, { "ShipName": "Split Rail Beer & Ale", "ShipAddress": "P.O. Box 555", "ShipCity": "Lander", "ShipRegion": "WY", "ShipPostalCode": "82520", "ShipCountry": "USA", "CustomerID": "SPLIR", "Customers_CompanyName": "Split Rail Beer & Ale", "Address": "P.O. Box 555", "City": "Lander", "Region": "WY", "PostalCode": "82520", "Country": "USA", "Salesperson": "Laura Callahan", "OrderID": "10369", "OrderDate": "1/2/95", "RequiredDate": "1/30/95", "ShippedDate": "1/9/95", "Shippers_CompanyName": "United Package", "ProductID": "56", "ProductName": "Gnocchi di nonna Alice", "UnitPrice": 30.40, "Quantity": "18", "Discount": 0.25, "ExtendedPrice": 410.40, "Freight": 195.68 }, { "ShipName": "Chop-suey Chinese", "ShipAddress": "Hauptstr. 31", "ShipCity": "Bern", "ShipPostalCode": "3012", "ShipCountry": "Switzerland", "CustomerID": "CHOPS", "Customers_CompanyName": "Chop-suey Chinese", "Address": "Hauptstr. 29", "City": "Bern", "PostalCode": "3012", "Country": "Switzerland", "Salesperson": "Michael Suyama", "OrderID": "10370", "OrderDate": "1/3/95", "RequiredDate": "1/31/95", "ShippedDate": "1/27/95", "Shippers_CompanyName": "United Package", "ProductID": "1", "ProductName": "Chai", "UnitPrice": 14.40, "Quantity": "15", "Discount": 0.150000006, "ExtendedPrice": 183.60, "Freight": 1.17 }, { "ShipName": "Chop-suey Chinese", "ShipAddress": "Hauptstr. 31", "ShipCity": "Bern", "ShipPostalCode": "3012", "ShipCountry": "Switzerland", "CustomerID": "CHOPS", "Customers_CompanyName": "Chop-suey Chinese", "Address": "Hauptstr. 29", "City": "Bern", "PostalCode": "3012", "Country": "Switzerland", "Salesperson": "Michael Suyama", "OrderID": "10370", "OrderDate": "1/3/95", "RequiredDate": "1/31/95", "ShippedDate": "1/27/95", "Shippers_CompanyName": "United Package", "ProductID": "64", "ProductName": "Wimmers gute Semmelknödel", "UnitPrice": 26.60, "Quantity": "30", "Discount": 0, "ExtendedPrice": 798.00, "Freight": 1.17 }, { "ShipName": "Chop-suey Chinese", "ShipAddress": "Hauptstr. 31", "ShipCity": "Bern", "ShipPostalCode": "3012", "ShipCountry": "Switzerland", "CustomerID": "CHOPS", "Customers_CompanyName": "Chop-suey Chinese", "Address": "Hauptstr. 29", "City": "Bern", "PostalCode": "3012", "Country": "Switzerland", "Salesperson": "Michael Suyama", "OrderID": "10370", "OrderDate": "1/3/95", "RequiredDate": "1/31/95", "ShippedDate": "1/27/95", "Shippers_CompanyName": "United Package", "ProductID": "74", "ProductName": "Longlife Tofu", "UnitPrice": 8.00, "Quantity": "20", "Discount": 0.150000006, "ExtendedPrice": 136.00, "Freight": 1.17 }, { "ShipName": "La maison d'Asie", "ShipAddress": "1 rue Alsace-Lorraine", "ShipCity": "Toulouse", "ShipPostalCode": "31000", "ShipCountry": "France", "CustomerID": "LAMAI", "Customers_CompanyName": "La maison d'Asie", "Address": "1 rue Alsace-Lorraine", "City": "Toulouse", "PostalCode": "31000", "Country": "France", "Salesperson": "Nancy Davolio", "OrderID": "10371", "OrderDate": "1/3/95", "RequiredDate": "1/31/95", "ShippedDate": "1/24/95", "Shippers_CompanyName": "Speedy Express", "ProductID": "36", "ProductName": "Inlagd Sill", "UnitPrice": 15.20, "Quantity": "6", "Discount": 0.200000003, "ExtendedPrice": 72.96, "Freight": 0.45 }, { "ShipName": "Queen Cozinha", "ShipAddress": "Alameda dos Canàrios, 891", "ShipCity": "São Paulo", "ShipRegion": "SP", "ShipPostalCode": "05487-020", "ShipCountry": "Brazil", "CustomerID": "QUEEN", "Customers_CompanyName": "Queen Cozinha", "Address": "Alameda dos Canàrios, 891", "City": "São Paulo", "Region": "SP", "PostalCode": "05487-020", "Country": "Brazil", "Salesperson": "Steven Buchanan", "OrderID": "10372", "OrderDate": "1/4/95", "RequiredDate": "2/1/95", "ShippedDate": "1/9/95", "Shippers_CompanyName": "United Package", "ProductID": "20", "ProductName": "Sir Rodney's Marmalade", "UnitPrice": 64.80, "Quantity": "12", "Discount": 0.25, "ExtendedPrice": 583.20, "Freight": 890.78 }, { "ShipName": "Queen Cozinha", "ShipAddress": "Alameda dos Canàrios, 891", "ShipCity": "São Paulo", "ShipRegion": "SP", "ShipPostalCode": "05487-020", "ShipCountry": "Brazil", "CustomerID": "QUEEN", "Customers_CompanyName": "Queen Cozinha", "Address": "Alameda dos Canàrios, 891", "City": "São Paulo", "Region": "SP", "PostalCode": "05487-020", "Country": "Brazil", "Salesperson": "Steven Buchanan", "OrderID": "10372", "OrderDate": "1/4/95", "RequiredDate": "2/1/95", "ShippedDate": "1/9/95", "Shippers_CompanyName": "United Package", "ProductID": "38", "ProductName": "Côte de Blaye", "UnitPrice": 210.80, "Quantity": "40", "Discount": 0.25, "ExtendedPrice": 324.00, "Freight": 890.78 }, { "ShipName": "Queen Cozinha", "ShipAddress": "Alameda dos Canàrios, 891", "ShipCity": "São Paulo", "ShipRegion": "SP", "ShipPostalCode": "05487-020", "ShipCountry": "Brazil", "CustomerID": "QUEEN", "Customers_CompanyName": "Queen Cozinha", "Address": "Alameda dos Canàrios, 891", "City": "São Paulo", "Region": "SP", "PostalCode": "05487-020", "Country": "Brazil", "Salesperson": "Steven Buchanan", "OrderID": "10372", "OrderDate": "1/4/95", "RequiredDate": "2/1/95", "ShippedDate": "1/9/95", "Shippers_CompanyName": "United Package", "ProductID": "60", "ProductName": "Camembert Pierrot", "UnitPrice": 27.20, "Quantity": "70", "Discount": 0.25, "ExtendedPrice": 428.00, "Freight": 890.78 }, { "ShipName": "Queen Cozinha", "ShipAddress": "Alameda dos Canàrios, 891", "ShipCity": "São Paulo", "ShipRegion": "SP", "ShipPostalCode": "05487-020", "ShipCountry": "Brazil", "CustomerID": "QUEEN", "Customers_CompanyName": "Queen Cozinha", "Address": "Alameda dos Canàrios, 891", "City": "São Paulo", "Region": "SP", "PostalCode": "05487-020", "Country": "Brazil", "Salesperson": "Steven Buchanan", "OrderID": "10372", "OrderDate": "1/4/95", "RequiredDate": "2/1/95", "ShippedDate": "1/9/95", "Shippers_CompanyName": "United Package", "ProductID": "72", "ProductName": "Mozzarella di Giovanni", "UnitPrice": 27.80, "Quantity": "42", "Discount": 0.25, "ExtendedPrice": 875.70, "Freight": 890.78 }] ```

最終的には次の画像のようなレポートとなります。

  1. ページレポートを作成し、Containerコントロールをデザイン面上にドラッグ＆ドロップします。

  2. **［プロパティ］**ウィンドウから、幅、高さ、色のプロパティを設定します。

  3. 2つのImageコントロールをContainerコントロールにドラッグ＆ドロップし、コンテナの左側に並べて配置します。これらは請求書のロゴになります。

  4. 注文日と注文IDに関する情報を追加するために、Containerコントロールの右側に2つのTextBoxコントロールを追加し、**［OrderDate］および［OrderID］**のフィールドにバインドします。

  5. 「注文ID：」、「注文日：」、および**「請求書」のラベルを表示するために、3つのTextBox**コントロールを追加します。

  6. 請求先と出荷先情報を表示するために、別のContainerコントロールをドラッグ＆ドロップし、Container1の下に配置します。

  7. **［プロパティ］**ウィンドウから、幅、高さ、色のプロパティを設定します。

  8. Container2に**［Customers_CompanyName］、［Address］、［ShipName］、および［ShipAddress］のフィールドをドラッグ＆ドロップします。これらのフィールドに対して、「請求先：」、「住所：」、「出荷先：」、および「住所：」**のラベルを表示するためにテキストボックスを追加します。

  9. Container2の下に、BandedListデータ領域をドラッグ＆ドロップし、**［プロパティ］**ウィンドウから以下のプロパティを設定します。 |プロパティ名|設定値| |---|---| |左|0in| |上|2.5in| |幅|6.5in| |高さ|1.5in| |固定の幅|6.5in| |固定の高さ|6.5in|

  10. BandedListの詳細行のテキストボックスを**［ProductID］、［ProductName］、［Quantity］、［UnitPrice］、［Discount］、および［ExtendedPrice］**のフィールドにバインドします。

  11. BandedListのヘッダ行で、TextBoxコントロールの［値］プロパティを次のように設定します。 |コントロール名|設定値| |---|---| |TextBox1|商品ID| |TextBox2|製品名| |TextBox3|数量| |TextBox4|単価| |TextBox5|割引| |TextBox6|明細金額|

  12. 3つのTextBoxコントロールをBandedListのフッタ行の右側にドラッグ＆ドロップし、**［値］**プロパティを次のように設定します。 |コントロール名|設定値| |---|---| |TextBox1|=Sum(Fields!ExtendedPrice.Value)| |TextBox2|=Sum(Fields!Freight.Value)| |TextBox3|=Sum(Fields!Freight.Value)|

  13. BandedListのフッタ行の左側に、3つのTextBoxコントロールをドラッグ＆ドロップし、**［値］**プロパティを次のように設定します。 |コントロール名|設定値| |---|---| |TextBox1|小計| |TextBox2|送料| |TextBox3|合計|

  14. BandedListデータ領域を右クリックし、コンテキストメニューから**［グループ］** > **［グループの挿入］**を選択します。

  15. **［グループ］セクションの［式］**プロパティを「=Fields!OrderID.Value」に設定します。

  16. レポートに配置する各コントロールのサイズや位置を調整して、レポートの外観をカスタマイズします。

  1. レポートをプレビューします。