Web Designer
Get Started / Tutorial 6: Create Report with Chart / Tutorial 6.1: Create Simple Report with Chart
In This Topic
    Tutorial 6.1: Create Simple Report with Chart
    In This Topic

    Let us see how easy it is to represent data in charts. This tutorial guides you through the steps to create a report with Chart data region.

    After you complete this tutorial, you will have a report that looks similar to the following.

    An Example for Report with a Chart

    Access the ActiveReports Web Designer and Add Data Set

    Run the Web Designer sample (WebDesigner_MVC(Core)) that you can download from the following link:

    https://github.com/activereports/WebSamples15/tree/master/WebDesignerSamples

    The Web Designer is opened in browser ready to create your reports. By default you have a Blank RDL Report.

     

    Bind Data to Report

    1. Connect to a data source.
      1. Go to Data tab and click Add next to Data Sources.
      2. In the Data Source Editor, fill-in the Name field as 'Products'.
      3. Select Provider as 'JSON provider'.
      4. Select JSON Data Type, select 'Embedded'.
      5. In the JSON Data field, expand and copy-paste the following text:

        JSON Data-Products

        {"Data":[{"ProductId":1,"ProductName":"Chai","QuantityPerUnit":"10 boxes x 20 bags","UnitPrice":18,"UnitsInStock":39,"ReorderLevel":10,"Discontinued":false,"CategoryId":1,"CategoryName":"Beverages","Description":"Soft drinks, coffees, teas, beers, and ales"},{"ProductId":2,"ProductName":"Chang","QuantityPerUnit":"24 - 12 oz bottles","UnitPrice":19,"UnitsInStock":17,"ReorderLevel":25,"Discontinued":false,"CategoryId":1,"CategoryName":"Beverages","Description":"Soft drinks, coffees, teas, beers, and ales"},{"ProductId":3,"ProductName":"Aniseed Syrup","QuantityPerUnit":"12 - 550 ml bottles","UnitPrice":10,"UnitsInStock":13,"ReorderLevel":25,"Discontinued":false,"CategoryId":2,"CategoryName":"Condiments","Description":"Sweet and savory sauces, relishes, spreads, and seasonings"},{"ProductId":4,"ProductName":"Chef Anton's Cajun Seasoning","QuantityPerUnit":"48 - 6 oz jars","UnitPrice":22,"UnitsInStock":53,"ReorderLevel":0,"Discontinued":false,"CategoryId":2,"CategoryName":"Condiments","Description":"Sweet and savory sauces, relishes, spreads, and seasonings"},{"ProductId":5,"ProductName":"Chef Anton's Gumbo Mix","QuantityPerUnit":"36 boxes","UnitPrice":21.35,"UnitsInStock":0,"ReorderLevel":0,"Discontinued":true,"CategoryId":2,"CategoryName":"Condiments","Description":"Sweet and savory sauces, relishes, spreads, and seasonings"},{"ProductId":6,"ProductName":"Grandma's Boysenberry Spread","QuantityPerUnit":"12 - 8 oz jars","UnitPrice":25,"UnitsInStock":120,"ReorderLevel":25,"Discontinued":false,"CategoryId":2,"CategoryName":"Condiments","Description":"Sweet and savory sauces, relishes, spreads, and seasonings"},{"ProductId":7,"ProductName":"Uncle Bob's Organic Dried Pears","QuantityPerUnit":"12 - 1 lb pkgs.","UnitPrice":30,"UnitsInStock":15,"ReorderLevel":10,"Discontinued":false,"CategoryId":7,"CategoryName":"Produce","Description":"Dried fruit and bean curd"},{"ProductId":8,"ProductName":"Northwoods Cranberry Sauce","QuantityPerUnit":"12 - 12 oz jars","UnitPrice":40,"UnitsInStock":6,"ReorderLevel":0,"Discontinued":false,"CategoryId":2,"CategoryName":"Condiments","Description":"Sweet and savory sauces, relishes, spreads, and seasonings"},{"ProductId":9,"ProductName":"Mishi Kobe Niku","QuantityPerUnit":"18 - 500 g pkgs.","UnitPrice":97,"UnitsInStock":29,"ReorderLevel":0,"Discontinued":true,"CategoryId":6,"CategoryName":"Meat/Poultry","Description":"Prepared meats"},{"ProductId":10,"ProductName":"Ikura","QuantityPerUnit":"12 - 200 ml jars","UnitPrice":31,"UnitsInStock":31,"ReorderLevel":0,"Discontinued":false,"CategoryId":8,"CategoryName":"Seafood","Description":"Seaweed and fish"},{"ProductId":11,"ProductName":"Queso Cabrales","QuantityPerUnit":"1 kg pkg.","UnitPrice":21,"UnitsInStock":22,"ReorderLevel":30,"Discontinued":false,"CategoryId":4,"CategoryName":"Dairy Products","Description":"Cheeses"},{"ProductId":12,"ProductName":"Queso Manchego La Pastora","QuantityPerUnit":"10 - 500 g pkgs.","UnitPrice":38,"UnitsInStock":86,"ReorderLevel":0,"Discontinued":false,"CategoryId":4,"CategoryName":"Dairy Products","Description":"Cheeses"},{"ProductId":13,"ProductName":"Konbu","QuantityPerUnit":"2 kg box","UnitPrice":6,"UnitsInStock":24,"ReorderLevel":5,"Discontinued":false,"CategoryId":8,"CategoryName":"Seafood","Description":"Seaweed and fish"},{"ProductId":14,"ProductName":"Tofu","QuantityPerUnit":"40 - 100 g pkgs.","UnitPrice":23.25,"UnitsInStock":35,"ReorderLevel":0,"Discontinued":false,"CategoryId":7,"CategoryName":"Produce","Description":"Dried fruit and bean curd"},{"ProductId":15,"ProductName":"Genen Shouyu","QuantityPerUnit":"24 - 250 ml bottles","UnitPrice":15.5,"UnitsInStock":39,"ReorderLevel":5,"Discontinued":false,"CategoryId":2,"CategoryName":"Condiments","Description":"Sweet and savory sauces, relishes, spreads, and seasonings"},{"ProductId":16,"ProductName":"Pavlova","QuantityPerUnit":"32 - 500 g boxes","UnitPrice":17.45,"UnitsInStock":29,"ReorderLevel":10,"Discontinued":false,"CategoryId":3,"CategoryName":"Confections","Description":"Desserts, candies, and sweet breads"},{"ProductId":17,"ProductName":"Alice Mutton","QuantityPerUnit":"20 - 1 kg tins","UnitPrice":39,"UnitsInStock":0,"ReorderLevel":0,"Discontinued":true,"CategoryId":6,"CategoryName":"Meat/Poultry","Description":"Prepared meats"},{"ProductId":18,"ProductName":"Carnarvon Tigers","QuantityPerUnit":"16 kg pkg.","UnitPrice":62.5,"UnitsInStock":42,"ReorderLevel":0,"Discontinued":false,"CategoryId":8,"CategoryName":"Seafood","Description":"Seaweed and fish"},{"ProductId":19,"ProductName":"Teatime Chocolate Biscuits","QuantityPerUnit":"10 boxes x 12 pieces","UnitPrice":9.2,"UnitsInStock":25,"ReorderLevel":5,"Discontinued":false,"CategoryId":3,"CategoryName":"Confections","Description":"Desserts, candies, and sweet breads"},{"ProductId":20,"ProductName":"Sir Rodney's Marmalade","QuantityPerUnit":"30 gift boxes","UnitPrice":81,"UnitsInStock":40,"ReorderLevel":0,"Discontinued":false,"CategoryId":3,"CategoryName":"Confections","Description":"Desserts, candies, and sweet breads"},{"ProductId":21,"ProductName":"Sir Rodney's Scones","QuantityPerUnit":"24 pkgs. x 4 pieces","UnitPrice":10,"UnitsInStock":3,"ReorderLevel":5,"Discontinued":false,"CategoryId":3,"CategoryName":"Confections","Description":"Desserts, candies, and sweet breads"},{"ProductId":22,"ProductName":"Gustaf's Knäckebröd","QuantityPerUnit":"24 - 500 g pkgs.","UnitPrice":21,"UnitsInStock":104,"ReorderLevel":25,"Discontinued":false,"CategoryId":5,"CategoryName":"Grains/Cereals","Description":"Breads, crackers, pasta, and cereal"},{"ProductId":23,"ProductName":"Tunnbröd","QuantityPerUnit":"12 - 250 g pkgs.","UnitPrice":9,"UnitsInStock":61,"ReorderLevel":25,"Discontinued":false,"CategoryId":5,"CategoryName":"Grains/Cereals","Description":"Breads, crackers, pasta, and cereal"},{"ProductId":24,"ProductName":"Guaraná Fantástica","QuantityPerUnit":"12 - 355 ml cans","UnitPrice":4.5,"UnitsInStock":20,"ReorderLevel":0,"Discontinued":true,"CategoryId":1,"CategoryName":"Beverages","Description":"Soft drinks, coffees, teas, beers, and ales"},{"ProductId":25,"ProductName":"NuNuCa Nuß-Nougat-Creme","QuantityPerUnit":"20 - 450 g glasses","UnitPrice":14,"UnitsInStock":76,"ReorderLevel":30,"Discontinued":false,"CategoryId":3,"CategoryName":"Confections","Description":"Desserts, candies, and sweet breads"},{"ProductId":26,"ProductName":"Gumbär Gummibärchen","QuantityPerUnit":"100 - 250 g bags","UnitPrice":31.23,"UnitsInStock":15,"ReorderLevel":0,"Discontinued":false,"CategoryId":3,"CategoryName":"Confections","Description":"Desserts, candies, and sweet breads"},{"ProductId":27,"ProductName":"Schoggi Schokolade","QuantityPerUnit":"100 - 100 g pieces","UnitPrice":43.9,"UnitsInStock":49,"ReorderLevel":30,"Discontinued":false,"CategoryId":3,"CategoryName":"Confections","Description":"Desserts, candies, and sweet breads"},{"ProductId":28,"ProductName":"Rössle Sauerkraut","QuantityPerUnit":"25 - 825 g cans","UnitPrice":45.6,"UnitsInStock":26,"ReorderLevel":0,"Discontinued":true,"CategoryId":7,"CategoryName":"Produce","Description":"Dried fruit and bean curd"},{"ProductId":29,"ProductName":"Thüringer Rostbratwurst","QuantityPerUnit":"50 bags x 30 sausgs.","UnitPrice":123.79,"UnitsInStock":0,"ReorderLevel":0,"Discontinued":true,"CategoryId":6,"CategoryName":"Meat/Poultry","Description":"Prepared meats"},{"ProductId":30,"ProductName":"Nord-Ost Matjeshering","QuantityPerUnit":"10 - 200 g glasses","UnitPrice":25.89,"UnitsInStock":10,"ReorderLevel":15,"Discontinued":false,"CategoryId":8,"CategoryName":"Seafood","Description":"Seaweed and fish"},{"ProductId":31,"ProductName":"Gorgonzola Telino","QuantityPerUnit":"12 - 100 g pkgs","UnitPrice":12.5,"UnitsInStock":0,"ReorderLevel":20,"Discontinued":false,"CategoryId":4,"CategoryName":"Dairy Products","Description":"Cheeses"},{"ProductId":32,"ProductName":"Mascarpone Fabioli","QuantityPerUnit":"24 - 200 g pkgs.","UnitPrice":32,"UnitsInStock":9,"ReorderLevel":25,"Discontinued":false,"CategoryId":4,"CategoryName":"Dairy Products","Description":"Cheeses"},{"ProductId":33,"ProductName":"Geitost","QuantityPerUnit":"500 g","UnitPrice":2.5,"UnitsInStock":112,"ReorderLevel":20,"Discontinued":false,"CategoryId":4,"CategoryName":"Dairy Products","Description":"Cheeses"},{"ProductId":34,"ProductName":"Sasquatch Ale","QuantityPerUnit":"24 - 12 oz bottles","UnitPrice":14,"UnitsInStock":111,"ReorderLevel":15,"Discontinued":false,"CategoryId":1,"CategoryName":"Beverages","Description":"Soft drinks, coffees, teas, beers, and ales"},{"ProductId":35,"ProductName":"Steeleye Stout","QuantityPerUnit":"24 - 12 oz bottles","UnitPrice":18,"UnitsInStock":20,"ReorderLevel":15,"Discontinued":false,"CategoryId":1,"CategoryName":"Beverages","Description":"Soft drinks, coffees, teas, beers, and ales"},{"ProductId":36,"ProductName":"Inlagd Sill","QuantityPerUnit":"24 - 250 g jars","UnitPrice":19,"UnitsInStock":112,"ReorderLevel":20,"Discontinued":false,"CategoryId":8,"CategoryName":"Seafood","Description":"Seaweed and fish"},{"ProductId":37,"ProductName":"Gravad lax","QuantityPerUnit":"12 - 500 g pkgs.","UnitPrice":26,"UnitsInStock":11,"ReorderLevel":25,"Discontinued":false,"CategoryId":8,"CategoryName":"Seafood","Description":"Seaweed and fish"},{"ProductId":38,"ProductName":"Côte de Blaye","QuantityPerUnit":"12 - 75 cl bottles","UnitPrice":263.5,"UnitsInStock":17,"ReorderLevel":15,"Discontinued":false,"CategoryId":1,"CategoryName":"Beverages","Description":"Soft drinks, coffees, teas, beers, and ales"},{"ProductId":39,"ProductName":"Chartreuse verte","QuantityPerUnit":"750 cc per bottle","UnitPrice":18,"UnitsInStock":69,"ReorderLevel":5,"Discontinued":false,"CategoryId":1,"CategoryName":"Beverages","Description":"Soft drinks, coffees, teas, beers, and ales"},{"ProductId":40,"ProductName":"Boston Crab Meat","QuantityPerUnit":"24 - 4 oz tins","UnitPrice":18.4,"UnitsInStock":123,"ReorderLevel":30,"Discontinued":false,"CategoryId":8,"CategoryName":"Seafood","Description":"Seaweed and fish"},{"ProductId":41,"ProductName":"Jack's New England Clam Chowder","QuantityPerUnit":"12 - 12 oz cans","UnitPrice":9.65,"UnitsInStock":85,"ReorderLevel":10,"Discontinued":false,"CategoryId":8,"CategoryName":"Seafood","Description":"Seaweed and fish"},{"ProductId":42,"ProductName":"Singaporean Hokkien Fried Mee","QuantityPerUnit":"32 - 1 kg pkgs.","UnitPrice":14,"UnitsInStock":26,"ReorderLevel":0,"Discontinued":true,"CategoryId":5,"CategoryName":"Grains/Cereals","Description":"Breads, crackers, pasta, and cereal"},{"ProductId":43,"ProductName":"Ipoh Coffee","QuantityPerUnit":"16 - 500 g tins","UnitPrice":46,"UnitsInStock":17,"ReorderLevel":25,"Discontinued":false,"CategoryId":1,"CategoryName":"Beverages","Description":"Soft drinks, coffees, teas, beers, and ales"},{"ProductId":44,"ProductName":"Gula Malacca","QuantityPerUnit":"20 - 2 kg bags","UnitPrice":19.45,"UnitsInStock":27,"ReorderLevel":15,"Discontinued":false,"CategoryId":2,"CategoryName":"Condiments","Description":"Sweet and savory sauces, relishes, spreads, and seasonings"},{"ProductId":45,"ProductName":"Rogede sild","QuantityPerUnit":"1k pkg.","UnitPrice":9.5,"UnitsInStock":5,"ReorderLevel":15,"Discontinued":false,"CategoryId":8,"CategoryName":"Seafood","Description":"Seaweed and fish"},{"ProductId":46,"ProductName":"Spegesild","QuantityPerUnit":"4 - 450 g glasses","UnitPrice":12,"UnitsInStock":95,"ReorderLevel":0,"Discontinued":false,"CategoryId":8,"CategoryName":"Seafood","Description":"Seaweed and fish"},{"ProductId":47,"ProductName":"Zaanse koeken","QuantityPerUnit":"10 - 4 oz boxes","UnitPrice":9.5,"UnitsInStock":36,"ReorderLevel":0,"Discontinued":false,"CategoryId":3,"CategoryName":"Confections","Description":"Desserts, candies, and sweet breads"},{"ProductId":48,"ProductName":"Chocolade","QuantityPerUnit":"10 pkgs.","UnitPrice":12.75,"UnitsInStock":15,"ReorderLevel":25,"Discontinued":false,"CategoryId":3,"CategoryName":"Confections","Description":"Desserts, candies, and sweet breads"},{"ProductId":49,"ProductName":"Maxilaku","QuantityPerUnit":"24 - 50 g pkgs.","UnitPrice":20,"UnitsInStock":10,"ReorderLevel":15,"Discontinued":false,"CategoryId":3,"CategoryName":"Confections","Description":"Desserts, candies, and sweet breads"},{"ProductId":50,"ProductName":"Valkoinen suklaa","QuantityPerUnit":"12 - 100 g bars","UnitPrice":16.25,"UnitsInStock":65,"ReorderLevel":30,"Discontinued":false,"CategoryId":3,"CategoryName":"Confections","Description":"Desserts, candies, and sweet breads"},{"ProductId":51,"ProductName":"Manjimup Dried Apples","QuantityPerUnit":"50 - 300 g pkgs.","UnitPrice":53,"UnitsInStock":20,"ReorderLevel":10,"Discontinued":false,"CategoryId":7,"CategoryName":"Produce","Description":"Dried fruit and bean curd"},{"ProductId":52,"ProductName":"Filo Mix","QuantityPerUnit":"16 - 2 kg boxes","UnitPrice":7,"UnitsInStock":38,"ReorderLevel":25,"Discontinued":false,"CategoryId":5,"CategoryName":"Grains/Cereals","Description":"Breads, crackers, pasta, and cereal"},{"ProductId":53,"ProductName":"Perth Pasties","QuantityPerUnit":"48 pieces","UnitPrice":32.8,"UnitsInStock":0,"ReorderLevel":0,"Discontinued":true,"CategoryId":6,"CategoryName":"Meat/Poultry","Description":"Prepared meats"},{"ProductId":54,"ProductName":"Tourtière","QuantityPerUnit":"16 pies","UnitPrice":7.45,"UnitsInStock":21,"ReorderLevel":10,"Discontinued":false,"CategoryId":6,"CategoryName":"Meat/Poultry","Description":"Prepared meats"},{"ProductId":55,"ProductName":"Pâté chinois","QuantityPerUnit":"24 boxes x 2 pies","UnitPrice":24,"UnitsInStock":115,"ReorderLevel":20,"Discontinued":false,"CategoryId":6,"CategoryName":"Meat/Poultry","Description":"Prepared meats"},{"ProductId":56,"ProductName":"Gnocchi di nonna Alice","QuantityPerUnit":"24 - 250 g pkgs.","UnitPrice":38,"UnitsInStock":21,"ReorderLevel":30,"Discontinued":false,"CategoryId":5,"CategoryName":"Grains/Cereals","Description":"Breads, crackers, pasta, and cereal"},{"ProductId":57,"ProductName":"Ravioli Angelo","QuantityPerUnit":"24 - 250 g pkgs.","UnitPrice":19.5,"UnitsInStock":36,"ReorderLevel":20,"Discontinued":false,"CategoryId":5,"CategoryName":"Grains/Cereals","Description":"Breads, crackers, pasta, and cereal"},{"ProductId":58,"ProductName":"Escargots de Bourgogne","QuantityPerUnit":"24 pieces","UnitPrice":13.25,"UnitsInStock":62,"ReorderLevel":20,"Discontinued":false,"CategoryId":8,"CategoryName":"Seafood","Description":"Seaweed and fish"},{"ProductId":59,"ProductName":"Raclette Courdavault","QuantityPerUnit":"5 kg pkg.","UnitPrice":55,"UnitsInStock":79,"ReorderLevel":0,"Discontinued":false,"CategoryId":4,"CategoryName":"Dairy Products","Description":"Cheeses"},{"ProductId":60,"ProductName":"Camembert Pierrot","QuantityPerUnit":"15 - 300 g rounds","UnitPrice":34,"UnitsInStock":19,"ReorderLevel":0,"Discontinued":false,"CategoryId":4,"CategoryName":"Dairy Products","Description":"Cheeses"},{"ProductId":61,"ProductName":"Sirop d'érable","QuantityPerUnit":"24 - 500 ml bottles","UnitPrice":28.5,"UnitsInStock":113,"ReorderLevel":25,"Discontinued":false,"CategoryId":2,"CategoryName":"Condiments","Description":"Sweet and savory sauces, relishes, spreads, and seasonings"},{"ProductId":62,"ProductName":"Tarte au sucre","QuantityPerUnit":"48 pies","UnitPrice":49.3,"UnitsInStock":17,"ReorderLevel":0,"Discontinued":false,"CategoryId":3,"CategoryName":"Confections","Description":"Desserts, candies, and sweet breads"},{"ProductId":63,"ProductName":"Vegie-spread","QuantityPerUnit":"15 - 625 g jars","UnitPrice":43.9,"UnitsInStock":24,"ReorderLevel":5,"Discontinued":false,"CategoryId":2,"CategoryName":"Condiments","Description":"Sweet and savory sauces, relishes, spreads, and seasonings"},{"ProductId":64,"ProductName":"Wimmers gute Semmelknödel","QuantityPerUnit":"20 bags x 4 pieces","UnitPrice":33.25,"UnitsInStock":22,"ReorderLevel":30,"Discontinued":false,"CategoryId":5,"CategoryName":"Grains/Cereals","Description":"Breads, crackers, pasta, and cereal"},{"ProductId":65,"ProductName":"Louisiana Fiery Hot Pepper Sauce","QuantityPerUnit":"32 - 8 oz bottles","UnitPrice":21.05,"UnitsInStock":76,"ReorderLevel":0,"Discontinued":false,"CategoryId":2,"CategoryName":"Condiments","Description":"Sweet and savory sauces, relishes, spreads, and seasonings"},{"ProductId":66,"ProductName":"Louisiana Hot Spiced Okra","QuantityPerUnit":"24 - 8 oz jars","UnitPrice":17,"UnitsInStock":4,"ReorderLevel":20,"Discontinued":false,"CategoryId":2,"CategoryName":"Condiments","Description":"Sweet and savory sauces, relishes, spreads, and seasonings"},{"ProductId":67,"ProductName":"Laughing Lumberjack Lager","QuantityPerUnit":"24 - 12 oz bottles","UnitPrice":14,"UnitsInStock":52,"ReorderLevel":10,"Discontinued":false,"CategoryId":1,"CategoryName":"Beverages","Description":"Soft drinks, coffees, teas, beers, and ales"},{"ProductId":68,"ProductName":"Scottish Longbreads","QuantityPerUnit":"10 boxes x 8 pieces","UnitPrice":12.5,"UnitsInStock":6,"ReorderLevel":15,"Discontinued":false,"CategoryId":3,"CategoryName":"Confections","Description":"Desserts, candies, and sweet breads"},{"ProductId":69,"ProductName":"Gudbrandsdalsost","QuantityPerUnit":"10 kg pkg.","UnitPrice":36,"UnitsInStock":26,"ReorderLevel":15,"Discontinued":false,"CategoryId":4,"CategoryName":"Dairy Products","Description":"Cheeses"},{"ProductId":70,"ProductName":"Outback Lager","QuantityPerUnit":"24 - 355 ml bottles","UnitPrice":15,"UnitsInStock":15,"ReorderLevel":30,"Discontinued":false,"CategoryId":1,"CategoryName":"Beverages","Description":"Soft drinks, coffees, teas, beers, and ales"},{"ProductId":71,"ProductName":"Flotemysost","QuantityPerUnit":"10 - 500 g pkgs.","UnitPrice":21.5,"UnitsInStock":26,"ReorderLevel":0,"Discontinued":false,"CategoryId":4,"CategoryName":"Dairy Products","Description":"Cheeses"},{"ProductId":72,"ProductName":"Mozzarella di Giovanni","QuantityPerUnit":"24 - 200 g pkgs.","UnitPrice":34.8,"UnitsInStock":14,"ReorderLevel":0,"Discontinued":false,"CategoryId":4,"CategoryName":"Dairy Products","Description":"Cheeses"},{"ProductId":73,"ProductName":"Röd Kaviar","QuantityPerUnit":"24 - 150 g jars","UnitPrice":15,"UnitsInStock":101,"ReorderLevel":5,"Discontinued":false,"CategoryId":8,"CategoryName":"Seafood","Description":"Seaweed and fish"},{"ProductId":74,"ProductName":"Longlife Tofu","QuantityPerUnit":"5 kg pkg.","UnitPrice":10,"UnitsInStock":4,"ReorderLevel":5,"Discontinued":false,"CategoryId":7,"CategoryName":"Produce","Description":"Dried fruit and bean curd"},{"ProductId":75,"ProductName":"Rhönbräu Klosterbier","QuantityPerUnit":"24 - 0.5 l bottles","UnitPrice":7.75,"UnitsInStock":125,"ReorderLevel":25,"Discontinued":false,"CategoryId":1,"CategoryName":"Beverages","Description":"Soft drinks, coffees, teas, beers, and ales"},{"ProductId":76,"ProductName":"Lakkalikööri","QuantityPerUnit":"500 ml","UnitPrice":18,"UnitsInStock":57,"ReorderLevel":20,"Discontinued":false,"CategoryId":1,"CategoryName":"Beverages","Description":"Soft drinks, coffees, teas, beers, and ales"},{"ProductId":77,"ProductName":"Original Frankfurter grüne Soße","QuantityPerUnit":"12 boxes","UnitPrice":13,"UnitsInStock":32,"ReorderLevel":15,"Discontinued":false,"CategoryId":2,"CategoryName":"Condiments","Description":"Sweet and savory sauces, relishes, spreads, and seasonings"}]}
      6. Keep the JSON Schema Type to 'Auto'.
      7. Test the datsource connection and click Add.
    2. Add a dataset.
      1. Click Add Data Set next to the added data source.
      2. In the Edit Data Set dialog, fill-in a dataset name and enter the Query: $.Data[*]
      3. Validate the query to obtain the bound fields and select OK to add the dataset.

    Create Report Layout

    The report uses the Chart data region to display data. Drag and drop the Chart data region Chart Toolbar Icon onto the design area of the report.
    Dragging the Chart control onto the design area 

    Define Plots

    We will create a chart with two series plotted along the Y-axis. For that, we need to add two plots to the chart area.

    1. With the Chart setected, from the Properties tab, click Show Items next to Plots property. You see that default Plot1 is already added.
    2. Add one more plot and set its Name as Plot2. Now you have two chart plots - Plot1 and Plot2.

      Let us now set the properties for the plots.
    3. From the Explorer Report Explorer Icon, select Plot - Plot1 and go to Properties tab to set the properties for Plot1 as follows:
      1. In the Values property, click Show Items, and then select Add.
      2. Click Filter Property Icon to edit the Value properties.
      3. Again in the Values property, click Show Items, and then select Add.
      4. Click the radio button to display the fields and select 'UnitsInStock'.
                   
        Note that UnitsInStock field is added to the Data Fields adorner.
      5. With Plot - Plot 1 selected, go to Encodings>Category and click Show Items, and then select Add.
      6. Click the radio button to display the fields and select 'CategoryName'.
      7. Set Show Values Names in Legend to 'True'.
      8. Go to Chart tab and from Set Plot Template, select Line.
        Selecting Line Chart type from the Chart Tab
    4. From the Explorer Report Explorer Icon, select Plot - Plot2 and go to Properties pane to set the properties for Plot2 as follows:
      1. Repeat steps 3.1- 3.4 to set Values property for Plot2 to 'UnitPrice'.            
      2. Go to Encodings>Category and click Show Items, and then select Add Item.
      3. Click the radio button to display the fields and select 'CategoryName'.
      4. Set Show Values Names in Legend to 'True'.
      5. Go to Chart tab and from Set Plot Template, select Column.

    Define Axes, Labels and Legends

    1. From the Explorer Report Explorer Icon, select Y Axis - [Plot 1].
    2. Set Common>Title property to 'Units In Stock'.
    3. Similarly, select Y Axis - [Plot 2] and set Common>Title property to 'Unit Price'.
    4. Set Labels > Format property to 'Currency'.
    5. From the Explorer Report Explorer Icon, select X Axis - [Plot 1].
    6. Set the Title of the X axis to 'Category Name'.
    7. From the Properties pane, set Plots property to two plots as Plot 1 and Plot 2:
      Properties for X Axis - Plot 1
    8. Set Labels > Label Angle property to -45 deg.
    9. From the Explorer, select Global Legend and set its Common > Position to Top.

    Add Titles

    Let us add titles to our chart, and to the X and Y axes.

    1. From the Explorer Report Explorer Icon, select Header under Chart1 (or the name of your chart).
      Adding header to the chart
    2. From the Properties pane, set Caption to Products.   


    Chart with 'Products' caption

    Preview and Save Report

    1. Click Preview Preview Button to view your report in the final output.
    2. Exit the preview mode by clicking Back on the top left side of the designer.
    3. Click Save to open the Save dialog box. Enter the report name and click Save Report.