GrapeCity ActiveReports for .NET 16.0J
チュートリアル6.1: グラフを使用したシンプルなレポートの作成
はじめに > チュートリアル6: グラフを使用したレポートの作成 > チュートリアル6.1: グラフを使用したシンプルなレポートの作成

グラフを使用して簡単にデータを表示することができます。このチュートリアルでは、Chartデータ領域を使用したレポートを作成する手順を紹介します。

このチュートリアルを完了すると、次のようなレポートが作成されます。

An Example for Report with a Chart

Webデザイナにアクセスする

［ユーザーフォルダ］\WebSamples\WebDesigner_MVCに格納されたWebDesigner_MVCサンプルを実行します。

Webデザイナがブラウザで開かれ、レポートのデザインが可能になります。デフォルトでは、空白のRDLレポートが表示されます。

レポートにデータをバインドする

  1. データソースを追加する
    1. データタブを開き、［データソース］の横の［+ 追加］アイコンをクリックします。
    2. ［データソースエディタ］ダイアログで、［名前］に「Products」と入力します。
    3. ［種類］のドロップダウンリストを開き、「JSON Provider」を選択します。
    4. ［JSONデータ形式］で「埋め込み」を選択します。
    5. ［埋め込むデータ形式］で、次のテキストを貼り付けます。

      JSON Data-Products

      {"Data":[{"ProductId":1,"ProductName":"\u679c\u6c41100% \u30aa\u30ec\u30f3\u30b8","SupplierId":1,"CategoryId":1,"QuantityPerUnit":"350ml\u00d750\u672c","UnitPrice":200.0000,"UnitsInStock":39,"UnitsOnOrder":0,"ReorderLevel":10,"Discontinued":true},{"ProductId":2,"ProductName":"\u679c\u6c41100% \u30b0\u30ec\u30fc\u30d7","SupplierId":1,"CategoryId":1,"QuantityPerUnit":"350ml\u00d750\u672c","UnitPrice":200.0000,"UnitsInStock":17,"UnitsOnOrder":40,"ReorderLevel":25,"Discontinued":false},{"ProductId":3,"ProductName":"\u679c\u6c41100% \u30ec\u30e2\u30f3","SupplierId":1,"CategoryId":1,"QuantityPerUnit":"250ml\u00d750\u672c","UnitPrice":1000.0000,"UnitsInStock":13,"UnitsOnOrder":70,"ReorderLevel":25,"Discontinued":false},{"ProductId":4,"ProductName":"\u679c\u6c41100% \u30d4\u30fc\u30c1","SupplierId":2,"CategoryId":1,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":1000.0000,"UnitsInStock":53,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":5,"ProductName":"\u30b3\u30fc\u30d2\u30fc\u30de\u30a4\u30eb\u30c9","SupplierId":2,"CategoryId":1,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":1000.0000,"UnitsInStock":0,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":true},{"ProductId":6,"ProductName":"\u30b3\u30fc\u30d2\u30fc\u30d3\u30bf\u30fc","SupplierId":3,"CategoryId":1,"QuantityPerUnit":"250ml\u00d740\u672c","UnitPrice":1000.0000,"UnitsInStock":120,"UnitsOnOrder":0,"ReorderLevel":25,"Discontinued":true},{"ProductId":7,"ProductName":"\u30b3\u30fc\u30d2\u30fc\u30df\u30eb\u30af","SupplierId":3,"CategoryId":1,"QuantityPerUnit":"500g","UnitPrice":500.0000,"UnitsInStock":15,"UnitsOnOrder":0,"ReorderLevel":10,"Discontinued":false},{"ProductId":8,"ProductName":"\u30d4\u30ea\u30d4\u30ea \u30d3\u30fc\u30eb","SupplierId":3,"CategoryId":1,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":100.0000,"UnitsInStock":6,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":9,"ProductName":"\u30aa\u30bf\u30eb\u767d\u30e9\u30d9\u30eb","SupplierId":4,"CategoryId":1,"QuantityPerUnit":"500g\u00d750\u30d1\u30c3\u30af","UnitPrice":2500.0000,"UnitsInStock":29,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":true},{"ProductId":10,"ProductName":"\u30d0\u30fc\u30c9\u30ef\u30a4\u30f3","SupplierId":4,"CategoryId":1,"QuantityPerUnit":"150g\u00d720\u888b","UnitPrice":210.0000,"UnitsInStock":31,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":11,"ProductName":"\u30db\u30ef\u30a4\u30c8\u30bd\u30eb\u30c8","SupplierId":5,"CategoryId":2,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":100.0000,"UnitsInStock":22,"UnitsOnOrder":30,"ReorderLevel":30,"Discontinued":false},{"ProductId":12,"ProductName":"\u30d6\u30e9\u30c3\u30af\u30da\u30c3\u30d1\u30fc","SupplierId":5,"CategoryId":2,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":100.0000,"UnitsInStock":86,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":13,"ProductName":"\u30d4\u30e5\u30a2\u30b7\u30e5\u30ac\u30fc","SupplierId":6,"CategoryId":2,"QuantityPerUnit":"150g\u00d720\u888b","UnitPrice":1000.0000,"UnitsInStock":24,"UnitsOnOrder":0,"ReorderLevel":5,"Discontinued":false},{"ProductId":14,"ProductName":"\u3046\u307e\u3044\u7d20","SupplierId":6,"CategoryId":2,"QuantityPerUnit":"500g","UnitPrice":2000.0000,"UnitsInStock":35,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":15,"ProductName":"\u30d4\u30e5\u30a2\u30c7\u30df\u30b0\u30e9\u30b9\u30bd\u30fc\u30b9","SupplierId":6,"CategoryId":2,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":1000.0000,"UnitsInStock":39,"UnitsOnOrder":0,"ReorderLevel":5,"Discontinued":false},{"ProductId":16,"ProductName":"\u3060\u3057\u304b\u3064\u304a","SupplierId":7,"CategoryId":2,"QuantityPerUnit":"50\u679a\u00d7200\u888b","UnitPrice":2400.0000,"UnitsInStock":29,"UnitsOnOrder":0,"ReorderLevel":10,"Discontinued":false},{"ProductId":17,"ProductName":"\u3060\u3057\u3053\u3093\u3076","SupplierId":7,"CategoryId":2,"QuantityPerUnit":"150g\u00d750\u30d1\u30c3\u30af","UnitPrice":500.0000,"UnitsInStock":0,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":true},{"ProductId":18,"ProductName":"\u30d4\u30ea\u30ab\u30e9\u30bf\u30d0\u30b9\u30b3","SupplierId":7,"CategoryId":2,"QuantityPerUnit":"150g\u00d720\u888b","UnitPrice":450.0000,"UnitsInStock":42,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":19,"ProductName":"\u306e\u308a\u5c71\u6912","SupplierId":8,"CategoryId":2,"QuantityPerUnit":"50\u679a\u00d7200\u888b","UnitPrice":1540.0000,"UnitsInStock":25,"UnitsOnOrder":0,"ReorderLevel":5,"Discontinued":false},{"ProductId":20,"ProductName":"\u7279\u88fd\u548c\u98a8\u91a4\u6cb9","SupplierId":8,"CategoryId":2,"QuantityPerUnit":"50\u679a\u00d7200\u888b","UnitPrice":1540.0000,"UnitsInStock":40,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":21,"ProductName":"\u30d0\u30cb\u30e9\u30af\u30ea\u30fc\u30e0\u30a2\u30a4\u30b9","SupplierId":8,"CategoryId":3,"QuantityPerUnit":"50\u679a\u00d7200\u888b","UnitPrice":1540.0000,"UnitsInStock":3,"UnitsOnOrder":40,"ReorderLevel":5,"Discontinued":false},{"ProductId":22,"ProductName":"\u30c1\u30e7\u30b3\u30af\u30ea\u30fc\u30e0\u30a2\u30a4\u30b9","SupplierId":9,"CategoryId":3,"QuantityPerUnit":"400g\u00d730\u675f","UnitPrice":200.0000,"UnitsInStock":104,"UnitsOnOrder":0,"ReorderLevel":25,"Discontinued":false},{"ProductId":23,"ProductName":"\u7d05\u8336\u30d0\u30fc","SupplierId":9,"CategoryId":3,"QuantityPerUnit":"400g\u00d730\u675f","UnitPrice":200.0000,"UnitsInStock":61,"UnitsOnOrder":0,"ReorderLevel":25,"Discontinued":false},{"ProductId":24,"ProductName":"\u3058\u3083\u304c\u30c1\u30c3\u30d7\u30b9","SupplierId":10,"CategoryId":3,"QuantityPerUnit":"250ml\u00d750\u672c","UnitPrice":1000.0000,"UnitsInStock":20,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":true},{"ProductId":25,"ProductName":"\u30a2\u30e1\u30ea\u30ab\u30f3\u30af\u30e9\u30c3\u30ab\u30fc","SupplierId":11,"CategoryId":3,"QuantityPerUnit":"20\u679a\u00d720\u888b","UnitPrice":1200.0000,"UnitsInStock":76,"UnitsOnOrder":0,"ReorderLevel":30,"Discontinued":false},{"ProductId":26,"ProductName":"\u30d0\u30ca\u30ca\u30ad\u30e3\u30f3\u30c7\u30a3\u30fc","SupplierId":11,"CategoryId":3,"QuantityPerUnit":"20\u679a\u00d720\u888b","UnitPrice":1000.0000,"UnitsInStock":15,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":27,"ProductName":"\u30e1\u30ed\u30f3\u30df\u30eb\u30af\u30ad\u30e3\u30f3\u30c7\u30a3\u30fc","SupplierId":11,"CategoryId":3,"QuantityPerUnit":"20\u679a\u00d720\u888b","UnitPrice":1600.0000,"UnitsInStock":49,"UnitsOnOrder":0,"ReorderLevel":30,"Discontinued":false},{"ProductId":28,"ProductName":"\u5c0f\u5009\u3042\u3093\u3071\u3093","SupplierId":12,"CategoryId":3,"QuantityPerUnit":"825g","UnitPrice":2300.0000,"UnitsInStock":26,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":true},{"ProductId":29,"ProductName":"\u30a4\u30f3\u30c9\u30ab\u30ec\u30fc\u30d1\u30f3","SupplierId":12,"CategoryId":3,"QuantityPerUnit":"500g\u00d750\u30d1\u30c3\u30af","UnitPrice":3000.0000,"UnitsInStock":0,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":true},{"ProductId":30,"ProductName":"\u30c1\u30fc\u30ba\u3042\u3093\u3071\u3093","SupplierId":13,"CategoryId":3,"QuantityPerUnit":"150g\u00d720\u888b","UnitPrice":200.0000,"UnitsInStock":10,"UnitsOnOrder":0,"ReorderLevel":15,"Discontinued":false},{"ProductId":31,"ProductName":"\u30ed\u30c3\u30ad\u30fc\u30c1\u30fc\u30ba","SupplierId":14,"CategoryId":4,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":100.0000,"UnitsInStock":0,"UnitsOnOrder":70,"ReorderLevel":20,"Discontinued":false},{"ProductId":32,"ProductName":"\u30d1\u30eb\u30e1\u30b6\u30f3\u30c1\u30fc\u30ba","SupplierId":14,"CategoryId":4,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":50.0000,"UnitsInStock":9,"UnitsOnOrder":40,"ReorderLevel":25,"Discontinued":false},{"ProductId":33,"ProductName":"\u30d5\u30ec\u30c3\u30b7\u30e5\u30d0\u30bf\u30fc","SupplierId":15,"CategoryId":4,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":100.0000,"UnitsInStock":112,"UnitsOnOrder":0,"ReorderLevel":20,"Discontinued":false},{"ProductId":34,"ProductName":"\u30e9\u30a4\u30d5\u30de\u30fc\u30ac\u30ea\u30f3","SupplierId":16,"CategoryId":4,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":1000.0000,"UnitsInStock":111,"UnitsOnOrder":0,"ReorderLevel":15,"Discontinued":false},{"ProductId":35,"ProductName":"\u30ed\u30fc\u30ab\u30ed\u30ea\u30fc\u725b\u4e73","SupplierId":16,"CategoryId":4,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":50.0000,"UnitsInStock":20,"UnitsOnOrder":0,"ReorderLevel":15,"Discontinued":false},{"ProductId":36,"ProductName":"\u725b\u4e73\u30de\u30a4\u30eb\u30c9","SupplierId":17,"CategoryId":4,"QuantityPerUnit":"150g\u00d720\u888b","UnitPrice":100.0000,"UnitsInStock":112,"UnitsOnOrder":0,"ReorderLevel":20,"Discontinued":false},{"ProductId":37,"ProductName":"\u30b9\u30c8\u30ed\u30d9\u30ea\u30fc\u30e8\u30fc\u30b0\u30eb\u30c8","SupplierId":17,"CategoryId":4,"QuantityPerUnit":"150g\u00d720\u888b","UnitPrice":500.0000,"UnitsInStock":11,"UnitsOnOrder":50,"ReorderLevel":25,"Discontinued":false},{"ProductId":38,"ProductName":"\u30d6\u30eb\u30fc\u30d9\u30ea\u30fc\u30e8\u30fc\u30b0\u30eb\u30c8","SupplierId":18,"CategoryId":4,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":300.0000,"UnitsInStock":17,"UnitsOnOrder":0,"ReorderLevel":15,"Discontinued":false},{"ProductId":39,"ProductName":"\u30e9\u30ba\u30d9\u30ea\u30fc\u30e8\u30fc\u30b0\u30eb\u30c8","SupplierId":18,"CategoryId":4,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":20.0000,"UnitsInStock":69,"UnitsOnOrder":0,"ReorderLevel":5,"Discontinued":false},{"ProductId":40,"ProductName":"\u30b3\u30b3\u30ca\u30c3\u30c4\u30df\u30eb\u30af","SupplierId":19,"CategoryId":4,"QuantityPerUnit":"150g\u00d720\u888b","UnitPrice":400.0000,"UnitsInStock":123,"UnitsOnOrder":0,"ReorderLevel":30,"Discontinued":false},{"ProductId":41,"ProductName":"\u30e2\u30fc\u30cb\u30f3\u30b0\u30d6\u30ec\u30c3\u30c9","SupplierId":19,"CategoryId":5,"QuantityPerUnit":"150g\u00d720\u888b","UnitPrice":40.0000,"UnitsInStock":85,"UnitsOnOrder":0,"ReorderLevel":10,"Discontinued":false},{"ProductId":42,"ProductName":"\u30d0\u30bf\u30fc\u30c8\u30fc\u30b9\u30c8","SupplierId":20,"CategoryId":5,"QuantityPerUnit":"400g\u00d730\u675f","UnitPrice":200.0000,"UnitsInStock":26,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":true},{"ProductId":43,"ProductName":"\u30d0\u30b1\u30c3\u30c8\u30d5\u30e9\u30f3\u30b9","SupplierId":20,"CategoryId":5,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":500.0000,"UnitsInStock":17,"UnitsOnOrder":10,"ReorderLevel":25,"Discontinued":false},{"ProductId":44,"ProductName":"\u6975\u4e0a\u30d1\u30b9\u30bf","SupplierId":20,"CategoryId":5,"QuantityPerUnit":"250ml\u00d720\u672c","UnitPrice":1000.0000,"UnitsInStock":27,"UnitsOnOrder":0,"ReorderLevel":15,"Discontinued":false},{"ProductId":45,"ProductName":"\u6975\u4e0a\u30de\u30ab\u30ed\u30cb","SupplierId":21,"CategoryId":5,"QuantityPerUnit":"200g\u00d730\u7bb1","UnitPrice":100.0000,"UnitsInStock":5,"UnitsOnOrder":70,"ReorderLevel":15,"Discontinued":false},{"ProductId":46,"ProductName":"\u4f1d\u7d71\u30b9\u30d1\u30b2\u30c3\u30c6\u30a3","SupplierId":21,"CategoryId":5,"QuantityPerUnit":"200g\u00d730\u7bb1","UnitPrice":1500.0000,"UnitsInStock":95,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":47,"ProductName":"\u30d8\u30eb\u30b7\u30fc\u30af\u30e9\u30c3\u30ab\u30fc","SupplierId":22,"CategoryId":5,"QuantityPerUnit":"20\u679a\u00d720\u888b","UnitPrice":1200.0000,"UnitsInStock":36,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":48,"ProductName":"\u30b3\u30fc\u30f3\u30d5\u30ec\u30fc\u30af\u30d7\u30ec\u30fc\u30f3","SupplierId":22,"CategoryId":5,"QuantityPerUnit":"20\u679a\u00d720\u888b","UnitPrice":20.0000,"UnitsInStock":15,"UnitsOnOrder":70,"ReorderLevel":25,"Discontinued":false},{"ProductId":49,"ProductName":"\u30b3\u30fc\u30f3\u30d5\u30ec\u30fc\u30af\u30c1\u30e7\u30b3","SupplierId":23,"CategoryId":5,"QuantityPerUnit":"20\u679a\u00d720\u888b","UnitPrice":10.0000,"UnitsInStock":10,"UnitsOnOrder":60,"ReorderLevel":15,"Discontinued":false},{"ProductId":50,"ProductName":"\u30b3\u30fc\u30f3\u30d5\u30ec\u30fc\u30af\u30b7\u30e5\u30ac\u30fc","SupplierId":23,"CategoryId":5,"QuantityPerUnit":"20\u679a\u00d720\u888b","UnitPrice":1540.0000,"UnitsInStock":65,"UnitsOnOrder":0,"ReorderLevel":30,"Discontinued":false},{"ProductId":51,"ProductName":"\u30a2\u30e1\u30ea\u30ab\u30f3\u30dd\u30fc\u30af","SupplierId":24,"CategoryId":6,"QuantityPerUnit":"200g","UnitPrice":5000.0000,"UnitsInStock":20,"UnitsOnOrder":0,"ReorderLevel":10,"Discontinued":false},{"ProductId":52,"ProductName":"\u3046\u3059\u5473\u30a6\u30a4\u30f3\u30ca\u30fc","SupplierId":24,"CategoryId":6,"QuantityPerUnit":"400g\u00d730\u675f","UnitPrice":200.0000,"UnitsInStock":38,"UnitsOnOrder":0,"ReorderLevel":25,"Discontinued":false},{"ProductId":53,"ProductName":"\u30d9\u30bf\u30fc\u30ed\u30fc\u30b9\u30c8\u30cf\u30e0","SupplierId":24,"CategoryId":6,"QuantityPerUnit":"50g\u00d75\u672c","UnitPrice":3500.0000,"UnitsInStock":0,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":true},{"ProductId":54,"ProductName":"\u30d9\u30bf\u30fc\u30d7\u30ec\u30b9\u30cf\u30e0","SupplierId":25,"CategoryId":6,"QuantityPerUnit":"50g\u00d75\u672c","UnitPrice":2500.0000,"UnitsInStock":21,"UnitsOnOrder":0,"ReorderLevel":10,"Discontinued":false},{"ProductId":55,"ProductName":"\u30d9\u30bf\u30fc\u751f\u30cf\u30e0","SupplierId":25,"CategoryId":6,"QuantityPerUnit":"50g\u00d75\u672c","UnitPrice":100.0000,"UnitsInStock":115,"UnitsOnOrder":0,"ReorderLevel":20,"Discontinued":false},{"ProductId":56,"ProductName":"\u7279\u88fd\u30b5\u30e9\u30df","SupplierId":26,"CategoryId":6,"QuantityPerUnit":"400g\u00d730\u675f","UnitPrice":400.0000,"UnitsInStock":21,"UnitsOnOrder":10,"ReorderLevel":30,"Discontinued":false},{"ProductId":57,"ProductName":"\u548c\u98a8\u30cf\u30f3\u30d0\u30fc\u30b0\u30ec\u30c8\u30eb\u30c8","SupplierId":26,"CategoryId":6,"QuantityPerUnit":"400g\u00d730\u675f","UnitPrice":700.0000,"UnitsInStock":36,"UnitsOnOrder":0,"ReorderLevel":20,"Discontinued":false},{"ProductId":58,"ProductName":"\u7167\u713c\u304d\u30df\u30fc\u30c8\u30dc\u30fc\u30eb","SupplierId":27,"CategoryId":6,"QuantityPerUnit":"150g\u00d720\u888b","UnitPrice":800.0000,"UnitsInStock":62,"UnitsOnOrder":0,"ReorderLevel":20,"Discontinued":false},{"ProductId":59,"ProductName":"\u30df\u30c3\u30af\u30b9\u30cf\u30e0","SupplierId":28,"CategoryId":6,"QuantityPerUnit":"140g\u00d73\u500b","UnitPrice":900.0000,"UnitsInStock":79,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":60,"ProductName":"\u30df\u30fc\u30c8\u30d0\u30fc","SupplierId":28,"CategoryId":6,"QuantityPerUnit":"140g\u00d73\u500b","UnitPrice":1000.0000,"UnitsInStock":19,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":61,"ProductName":"\u3082\u3081\u3093\u3069\u3046\u3075\u7279\u4e0a","SupplierId":29,"CategoryId":7,"QuantityPerUnit":"150g\u00d720\u672c","UnitPrice":40.0000,"UnitsInStock":113,"UnitsOnOrder":0,"ReorderLevel":25,"Discontinued":false},{"ProductId":62,"ProductName":"\u304d\u306c\u3054\u3057\u3069\u3046\u3075\u7279\u4e0a","SupplierId":29,"CategoryId":7,"QuantityPerUnit":"50g\u00d720\u500b","UnitPrice":400.0000,"UnitsInStock":17,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":63,"ProductName":"\u51b7\u51cd\u30df\u30c3\u30af\u30b9\u30d9\u30b8\u30bf\u30d6\u30eb","SupplierId":7,"CategoryId":7,"QuantityPerUnit":"150g\u00d720\u672c","UnitPrice":500.0000,"UnitsInStock":24,"UnitsOnOrder":0,"ReorderLevel":5,"Discontinued":false},{"ProductId":64,"ProductName":"\u51b7\u51cd\u30af\u30ea\u30fc\u30e0\u30b3\u30ed\u30c3\u30b1","SupplierId":12,"CategoryId":7,"QuantityPerUnit":"400g\u00d730\u675f","UnitPrice":15.0000,"UnitsInStock":22,"UnitsOnOrder":80,"ReorderLevel":30,"Discontinued":false},{"ProductId":65,"ProductName":"\u51b7\u51cd\u30b3\u30fc\u30f3\u30af\u30ea\u30fc\u30e0\u30b3\u30ed\u30c3\u30b1","SupplierId":2,"CategoryId":7,"QuantityPerUnit":"150g\u00d720\u672c","UnitPrice":150.0000,"UnitsInStock":76,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":66,"ProductName":"\u51b7\u51cd\u30dd\u30c6\u30c8\u30b3\u30ed\u30c3\u30b1","SupplierId":2,"CategoryId":7,"QuantityPerUnit":"150g\u00d720\u672c","UnitPrice":1500.0000,"UnitsInStock":4,"UnitsOnOrder":100,"ReorderLevel":20,"Discontinued":false},{"ProductId":67,"ProductName":"\u51b7\u51cd\u679d\u8c46","SupplierId":16,"CategoryId":7,"QuantityPerUnit":"200g\u00d712\u7f36","UnitPrice":550.0000,"UnitsInStock":52,"UnitsOnOrder":0,"ReorderLevel":10,"Discontinued":false},{"ProductId":68,"ProductName":"\u51b7\u51cd\u3084\u304d\u304a\u306b\u304e\u308a","SupplierId":8,"CategoryId":7,"QuantityPerUnit":"50g\u00d720\u500b","UnitPrice":460.0000,"UnitsInStock":6,"UnitsOnOrder":10,"ReorderLevel":15,"Discontinued":false},{"ProductId":69,"ProductName":"\u4e7e\u71e5\u30d0\u30ca\u30ca","SupplierId":15,"CategoryId":7,"QuantityPerUnit":"120g\u00d710\u500b","UnitPrice":650.0000,"UnitsInStock":26,"UnitsOnOrder":0,"ReorderLevel":15,"Discontinued":false},{"ProductId":70,"ProductName":"\u4e7e\u71e5\u30a2\u30c3\u30d7\u30eb","SupplierId":7,"CategoryId":7,"QuantityPerUnit":"190g\u00d712\u7f36","UnitPrice":148.0000,"UnitsInStock":15,"UnitsOnOrder":10,"ReorderLevel":30,"Discontinued":false},{"ProductId":71,"ProductName":"\u7279\u9078\u5473\u306e\u308a","SupplierId":15,"CategoryId":8,"QuantityPerUnit":"120g\u00d710\u500b","UnitPrice":850.0000,"UnitsInStock":26,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":72,"ProductName":"\u5317\u6d77\u9053\u6606\u5e03","SupplierId":14,"CategoryId":8,"QuantityPerUnit":"120g\u00d750\u500b","UnitPrice":720.0000,"UnitsInStock":14,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":73,"ProductName":"\u3084\u304d\u3044\u304b\u3059\u308b\u3081\u304f\u3093","SupplierId":17,"CategoryId":8,"QuantityPerUnit":"20g\u00d750\u888b","UnitPrice":145.0000,"UnitsInStock":101,"UnitsOnOrder":0,"ReorderLevel":5,"Discontinued":false},{"ProductId":74,"ProductName":"\u98df\u5353\u308f\u304b\u3081","SupplierId":4,"CategoryId":8,"QuantityPerUnit":"500g","UnitPrice":950.0000,"UnitsInStock":4,"UnitsOnOrder":20,"ReorderLevel":5,"Discontinued":false},{"ProductId":75,"ProductName":"\u3075\u308a\u304b\u3051\u304b\u3064\u304a\u98a8\u5473","SupplierId":12,"CategoryId":8,"QuantityPerUnit":"190g\u00d712\u7f36","UnitPrice":145.0000,"UnitsInStock":125,"UnitsOnOrder":0,"ReorderLevel":25,"Discontinued":false},{"ProductId":76,"ProductName":"\u3075\u308a\u304b\u3051\u9bad\u98a8\u5473","SupplierId":23,"CategoryId":8,"QuantityPerUnit":"190g\u00d720\u7f36","UnitPrice":685.0000,"UnitsInStock":57,"UnitsOnOrder":0,"ReorderLevel":20,"Discontinued":false},{"ProductId":77,"ProductName":"\u5927\u9678\u30b5\u30fc\u30e2\u30f3","SupplierId":12,"CategoryId":8,"QuantityPerUnit":"150g\u00d720\u672c","UnitPrice":244.0000,"UnitsInStock":32,"UnitsOnOrder":0,"ReorderLevel":15,"Discontinued":false},{"ProductId":78,"ProductName":"\u7279\u9078\u306b\u307c\u3057","SupplierId":16,"CategoryId":8,"QuantityPerUnit":"400g\u00d730\u675f","UnitPrice":20.0000,"UnitsInStock":0,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false},{"ProductId":79,"ProductName":"\u672c\u304c\u3064\u304a\u7279\u4e0a","SupplierId":21,"CategoryId":8,"QuantityPerUnit":"50g\u00d75\u672c","UnitPrice":144.0000,"UnitsInStock":0,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":true},{"ProductId":80,"ProductName":"\u3053\u308d\u3082\u306f\u3093\u307a\u3093","SupplierId":19,"CategoryId":8,"QuantityPerUnit":"20\u679a\u00d720\u888b","UnitPrice":100.0000,"UnitsInStock":0,"UnitsOnOrder":0,"ReorderLevel":0,"Discontinued":false}]}
    6. ［JSONスキーマ形式］を「自動生成」に設定します。
    7. ［テスト接続］をクリックしてデータソースへの接続をテストし、［追加］をクリックします。
  2. データセットを追加する
    1. 追加したデータソースの横にある［データセットの編集］をクリックします。
    2. ［データセットの編集］ダイアログで、データセットの名前を入力し、［クエリ］に「$.Data[*]」と入力します。
    3. ［検証］をクリックしてバウンドフィールドを取得し、［OK］をクリックしてデータセットを追加します。

レポートレイアウトを作成する

このレポートでは、Chartデータ領域を使用してデータを表示します。レポートコントロールの一覧から、Chartデータ領域Chart Toolbar Iconをレポートのデザイナ面上にドラッグ＆ドロップします。
Dragging the Chart control onto the design area 

プロットを定義する

Y軸にプロットされた2つの系列を持つチャートを作成します。そのために、Chartデータ領域に2つのプロットを追加する必要があります。

  1. ［プロパティ］タブをクリックし、［共通］セクションの［プロット］プロパティの隣にある［項目の表示］をクリックし、［プロット 1］が既に設定されていることを確認します。
  2. ［+ 項目の追加］をクリックして、もう1つのプロットを追加し、［プロット 2］として設定します。これで、［プロット 1］と［プロット 2］のプロットがグラフに設定されます。

    プロットのプロパティを設定しましょう。
  3. ［エクスプローラ］Report Explorer Iconをクリックして、［プロット-プロット 1］を選択し、［プロパティ］タブを表示します。
    1. ［共通］セクションの［値］プロパティの隣にある［項目の表示］をクリックし、［+ 項目の追加］を選択します。
    2. 表示される［値 0］の隣にあるFilter Property Iconをクリックし、［値プロパティ］を表示します。
    3. ［値］プロパティの隣にある［項目の表示］をクリックします。
    4. 表示されるボックスの隣にあるボタンをクリックしてフィールドのリストを表示し、「UnitsInStock」を選択します。
                 
      UnitsInStockフィールドは、データフィールドの下に表示されるフィールドボックスに表示されます。
    5. ［← 値のプロパティ］をクリックして［プロット］に戻り、［エンコーディング］セクションの［カテゴリ］プロパティの隣にある［項目の表示］をクリックし、［+ 項目の追加］を選択します。
    6. 表示されるボックスの隣にあるボタンをクリックしてフィールドのリストを表示し、「CategoryId」を選択します。
    7. ［エンコーディング］セクションの［カラーに値の名前を表示］プロパティを「はい」に設定します。
    8. リボンの［Chart］タブをクリックし、［プロットのテンプレートの設定］の隣にあるドロップダウンから「折れ線」を選択します。
      Selecting Line Chart type from the Chart Tab
  4. ［エクスプローラ］Report Explorer Iconをクリックし、［プロット-プロット 2］を選択し、［プロパティ］タブを表示します。
    1. ［プロット-プロット 2］にて手順3.1から手順3.4を繰り返し、［値プロパティ］の［値］プロパティを「UnitPrice」に設定します。    
    2. ［エンコーディング］セクションの［カテゴリ］プロパティの隣にある［項目の表示］をクリックし、［+ 項目の追加］を選択します。
    3. 表示されるボックスの隣にあるボタンをクリックしてフィールドのリストを表示し、「CategoryId」を選択します。
    4. ［エンコーディング］セクションの［カラーに値の名前を表示］プロパティを「はい」に設定します。
    5. リボンの［Chart］タブをクリックし、［プロットのテンプレートの設定］の隣にあるドロップダウンから「縦棒」を選択します。

軸、ラベル、凡例を定義する

  1. ［エクスプローラ］Report Explorer Iconをクリックし、［Y軸-［プロット 1］］を選択します。
  2. ［プロパティ］タブをクリックし、［共通］セクションの［タイトル］プロパティを「在庫数量」に設定します。
  3. ［エクスプローラ］Report Explorer Iconより、［Y軸-［プロット 2］］を選択します。
  4. ［プロパティ］タブより、［共通］セクションの［タイトル］プロパティを「単価」に設定します。
  5. ［プロパティ］タブより、［ラベル］セクションの［表示形式］プロパティを「通貨（桁数: 0）」に設定します。
  6. ［エクスプローラ］Report Explorer Iconより、［X軸-［プロット 1］］を選択します。
  7. ［プロパティ］タブより、［共通］セクションの［タイトル］プロパティを「カテゴリID」に設定します
  8. ［プロット］プロパティの隣にある［項目の表示］をクリックし、［+ 項目の追加］を選択して、次の画像のとおり設定します。
    Properties for X Axis - Plot 1
  9. ［ラベル］セクションの［ラベルの角度］プロパティを「45」に設定します。
  10. ［エクスプローラ］より、［グローバル凡例］を選択します。
  11. ［プロパティ］タブより、［共通］セクションの［位置］プロパティを「Top」に設定します。

レポートタイトルを追加する

グラフとX軸、Y軸にタイトルを追加しましょう。

  1. ［エクスプローラ］Report Explorer Iconをクリックし、Chart1（名前を変更した場合はそのChartの名前）の下にある［ヘッダ］を選択します。
    Adding header to the chart
  2. ［プロパティ］タブをクリックし、［共通］セクションの［キャプション］プロパティを「カテゴリ別商品」に変更します。   


Chart with 'Products' caption

レポートを表示／保存する

  1. ［プレビュー］Preview Buttonをクリックして、レポートの最終結果を表示します。
  2. プレビューモードを終了するには、デザイナの左上にある［戻る］をクリックします。
  3. ［名前を付けて保存］をクリックして、レポートの名前を任意のものに変更し、［レポートの保存］をクリックします。

 

 

Copyright © 2003 GrapeCity inc. All rights reserved.