柱形图

该示例展示了使用柱形图展示每类产品的库存总量

<!DOCTYPE html> <html lang="en"> <head> <meta charset="utf-8" /> <meta http-equiv="X-UA-Compatible" content="IE=edge" /> <title>ActiveReportsJS sample</title> <meta name="viewport" content="width=device-width, initial-scale=1.0" /> <link href="https://fonts.googleapis.com/css2?family=Montserrat:ital,wght@0,300;0,400;0,500;0,600;0,700;1,400&display=swap" rel="stylesheet" /> <link rel="stylesheet" href="https://cdn.materialdesignicons.com/2.8.94/css/materialdesignicons.min.css" /> <script src="/activereportsjs/demos/arjs/dist/ie-polyfills.js"></script> <script src="/activereportsjs/demos/arjs/dist/ar-js-core.js"></script> <script src="/activereportsjs/demos/arjs/dist/ar-js-viewer.js"></script> <script src="/activereportsjs/demos/arjs/dist/ar-js-designer.js"></script> <script src="/activereportsjs/demos/arjs/dist/ar-js-pdf.js"></script> <script src="/activereportsjs/demos/arjs/dist/ar-js-html.js"></script> <script src="/activereportsjs/demos/arjs/dist/ar-js-xlsx.js"></script> <script src="/activereportsjs/demos/arjs-localization/dist/ar-js-locales.js"></script> <script src="/activereportsjs/demos/arjs-localization/dist/designer/zh-locale.js"></script> <script src="$DEMOROOT$/lib/purejs/license.js"></script> <link rel="stylesheet" type="text/css" href="/activereportsjs/demos/arjs/styles/ar-js-ui.css" /> <link rel="stylesheet" type="text/css" href="/activereportsjs/demos/arjs/styles/ar-js-viewer.css" /> <link rel="stylesheet" type="text/css" href="/activereportsjs/demos/arjs/styles/ar-js-designer.css" /> <style> #root { height: 100vh; } #viewer-host, #designer-host { height: 100%; } #designer-host { display: none; } </style> </head> <body onload="load()" style="margin: 0"> <div id="root"> <div id="viewer-host"></div> <div id="designer-host"></div> </div> <script> var currentReport = undefined; var viewerHost = document.getElementById("viewer-host"); var designerHost = document.getElementById("designer-host"); function load() { var viewer = new ActiveReports.Viewer("#viewer-host", { language: "zh" }); var designer = new GC.ActiveReports.ReportDesigner.Designer( "#designer-host", { language: "zh" } ); designer.setActionHandlers({ onRender(report) { currentReport = report.definition; viewer.open(currentReport); viewerHost.style.display = "block"; designerHost.style.display = "none"; // return Promise.resolve(); }, }); var designButton = { key: "$openDesigner", text: "编辑报表", iconCssClass: "mdi mdi-pencil", enabled: true, action: function (item) { designer.setReport({ definition: currentReport, displayName: "OData", }); viewerHost.style.display = "none"; designerHost.style.display = "block"; }, }; viewer.toolbar.addItem(designButton); viewer.toolbar.updateLayout({ default: [ "$openDesigner", "$split", "$navigation", "$split", "$refresh", "$split", "$history", "$split", "$zoom", "$fullscreen", "$split", "$print", "$split", "$singlepagemode", "$continuousmode", "$galleymode", ], }); fetch("simple-chart.rdlx-json") .then(function (data) { return data.json(); }) .then(function (report) { currentReport = report; viewer.open(report); }); } </script> </body> </html>
{"Name":"Chart.rdlx","Type":"report","Body":{"Type":"section","Name":"Body","Height":"7in","ReportItems":[{"Type":"dvchart","Bar":{"BottomWidth":0.55,"NeckHeight":1,"Overlap":0,"TopWidth":0.55,"Width":0.55},"Footer":{"Type":"dvchartfooter","Style":{"PaddingTop":"2pt","PaddingBottom":"4pt","StyleName":"=\"\""},"TextStyle":{"StyleName":"=\"\""},"Height":""},"Header":{"Type":"dvchartheader","Title":"Products Count by Categories","Style":{"PaddingTop":"4pt","PaddingBottom":"2pt","StyleName":"=\"\""},"TextStyle":{"FontFamily":"Verdana","FontSize":"14pt","FontWeight":"Bold","StyleName":"=\"\""},"Height":""},"Legend":{"Orientation":"Vertical","Style":{"PaddingRight":"10pt","PaddingTop":"4pt","PaddingBottom":"2pt","StyleName":"=\"\""},"TextStyle":{"StyleName":"=\"\""},"TitleStyle":{"StyleName":"=\"\""},"Type":"dvchartgloballegend"},"Palette":"Aspect","PlotArea":{"Type":"dvchartplotarea","Axes":[{"Type":"dvchartaxis","LabelStyle":{"FontFamily":"Verdana","FontSize":"9pt","FontWeight":"Bold","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","StyleName":"=\"\"","Color":"#3c3c3c"},"LineStyle":{"Border":{"Style":"Solid","Color":"#3c3c3c"},"StyleName":"=\"\""},"MajorGridStyle":{"Border":{"Style":"Solid","Color":"Gray"},"StyleName":"=\"\""},"MajorTickStyle":{"StyleName":"=\"\""},"MinorGridStyle":{"StyleName":"=\"\""},"MinorTickStyle":{"StyleName":"=\"\""},"Plots":["Plot 1"],"Style":{"StyleName":"=\"\""},"TextStyle":{"StyleName":"=\"\""},"TitleStyle":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","StyleName":"=\"\"","Color":"#3c3c3c"}},{"Type":"dvchartaxis","LabelStyle":{"FontFamily":"Verdana","FontSize":"9pt","FontWeight":"Bold","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","StyleName":"=\"\"","Color":"#3c3c3c"},"LineStyle":{"Border":{"Style":"Solid","Color":"#3c3c3c"},"StyleName":"=\"\""},"MajorGrid":true,"MajorGridStyle":{"Border":{"Style":"Solid","Color":"Gray"},"StyleName":"=\"\""},"MajorTickStyle":{"StyleName":"=\"\""},"MajorUnit":"2","Max":"14","Min":"0","MinorGrid":true,"MinorGridStyle":{"Border":{"Style":"Solid","Color":"LightGrey","Width":"0.5pt"},"StyleName":"=\"\""},"MinorTickStyle":{"StyleName":"=\"\""},"Plots":["Plot 1"],"Style":{"StyleName":"=\"\""},"TextStyle":{"StyleName":"=\"\""},"Title":"Products Count","TitleStyle":{"FontSize":"12pt","FontWeight":"Bold","PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","StyleName":"=\"\"","Color":"#3c3c3c"},"AxisType":"Y"}],"Legends":[{"Type":"dvchartlegend","Position":"Bottom","Style":{"PaddingTop":"10pt","PaddingBottom":"10pt","StyleName":"=\"\"","Border":{"Color":"#3c3c3c"}},"TextStyle":{"FontFamily":"Verdana","FontSize":"8pt","StyleName":"=\"\"","Color":"#3c3c3c"},"TitleStyle":{"StyleName":"=\"\"","Color":"#3c3c3c"},"Title":"Legend"}],"Style":{"StyleName":"=\"\""}},"Plots":[{"Type":"dvchartplot","PlotChartType":"Column","PlotChartSubtype":"Clustered","PlotName":"Plot 1","Encodings":{"Values":[{"Type":"dvchartvalueaggregateencoding","Field":{"Value":["=Count(Fields!ProductId.Value)"]}}],"Category":{"Type":"dvchartcategoryencoding","Field":{"Value":["=Fields!CategoryName.Value"]}}},"Config":{"LineStyle":{"Color":"Black"},"Style":{"Border":{"Style":"None","Width":"1pt"},"StyleName":"=\"\""},"SymbolShape":"Dot","SymbolStyle":{"StyleName":"=\"\""},"Text":{"ConnectingLine":{"Border":{"Width":"1pt"},"TopBorder":{"Width":""},"BottomBorder":{"Width":""},"LeftBorder":{"Width":""},"RightBorder":{"Width":""},"StyleName":"=\"\""},"Style":{"FontFamily":"Verdana","Color":"#e6e6e6","StyleName":"=\"\""},"TextPosition":"Center","Template":"{valueField.value}"}}}],"DataSetName":"Products","NewSection":false,"Name":"Chart1","Width":"11in","Height":"7in","Style":{"PaddingLeft":"2pt","PaddingRight":"2pt","PaddingTop":"2pt","PaddingBottom":"2pt","StyleName":"=\"\""},"KeepTogether":false}],"Style":{"StyleName":"=\"\""}},"Page":{"PageWidth":"12in","PageHeight":"8in","PageOrientation":"Landscape","RightMargin":"0.5in","LeftMargin":"0.5in","TopMargin":"0.5in","BottomMargin":"0.5in","ColumnSpacing":"0in","Columns":1},"Width":"11in","CustomProperties":[{"Name":"Products_Data_Set_Fields","Value":"{\"ProductId\":{\"aggregate\":\"Count\",\"dataType\":\"Integer\"},\"ProductName\":{\"aggregate\":\"Count\",\"dataType\":\"String\"},\"QuantityPerUnit\":{\"aggregate\":\"Count\",\"dataType\":\"String\"},\"UnitPrice\":{\"aggregate\":\"Sum\",\"dataType\":\"Float\"},\"UnitsInStock\":{\"aggregate\":\"Sum\",\"dataType\":\"Integer\"},\"ReorderLevel\":{\"aggregate\":\"Sum\",\"dataType\":\"Integer\"},\"Discontinued\":{\"aggregate\":\"Count\",\"dataType\":\"Boolean\"},\"CategoryId\":{\"aggregate\":\"Count\",\"dataType\":\"Integer\"},\"CategoryName\":{\"aggregate\":\"Count\",\"dataType\":\"String\"},\"Description\":{\"aggregate\":\"Count\",\"dataType\":\"String\"}}"},{"Name":"DisplayType","Value":"Galley"},{"Name":"SizeType","Value":"Default"}],"DataSources":[{"Name":"NorthwindProducts","ConnectionProperties":{"ConnectString":"jsondata={\"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\"}]};schemadata={\"$id\":\"http://example.com/example.json\",\"type\":\"object\",\"definitions\":{},\"$schema\":\"http://json-schema.org/draft-07/schema#\",\"properties\":{\"Data\":{\"$id\":\"/properties/Data\",\"type\":\"array\",\"items\":{\"$id\":\"/properties/Data/items\",\"type\":\"object\",\"properties\":{\"ProductId\":{\"$id\":\"/properties/Data/items/properties/ProductId\",\"type\":\"integer\",\"title\":\"The ProductId Schema\",\"default\":0,\"examples\":[123]},\"ProductName\":{\"$id\":\"/properties/Data/items/properties/ProductName\",\"type\":\"string\",\"title\":\"The ProductName Schema\",\"default\":0,\"examples\":[\"abc\"]},\"QuantityPerUnit\":{\"$id\":\"/properties/Data/items/properties/QuantityPerUnit\",\"type\":\"string\",\"title\":\"The QuantityPerUnit Schema\",\"default\":0,\"examples\":[\"abc\"]},\"UnitPrice\":{\"$id\":\"/properties/Data/items/properties/UnitPrice\",\"type\":\"number\",\"title\":\"The UnitPrice Schema\",\"default\":0,\"examples\":[1.23]},\"UnitsInStock\":{\"$id\":\"/properties/Data/items/properties/UnitsInStock\",\"type\":\"integer\",\"title\":\"The UnitsInStock Schema\",\"default\":0,\"examples\":[123]},\"ReorderLevel\":{\"$id\":\"/properties/Data/items/properties/ReorderLevel\",\"type\":\"integer\",\"title\":\"The ReorderLevel Schema\",\"default\":0,\"examples\":[123]},\"Discontinued\":{\"$id\":\"/properties/Data/items/properties/Discontinued\",\"type\":\"boolean\",\"title\":\"The Discontinued Schema\",\"default\":0,\"examples\":[false]},\"CategoryId\":{\"$id\":\"/properties/Data/items/properties/CategoryId\",\"type\":\"integer\",\"title\":\"The CategoryId Schema\",\"default\":0,\"examples\":[123]},\"CategoryName\":{\"$id\":\"/properties/Data/items/properties/CategoryName\",\"type\":\"string\",\"title\":\"The CategoryName Schema\",\"default\":0,\"examples\":[\"abc\"]},\"Description\":{\"$id\":\"/properties/Data/items/properties/Description\",\"type\":\"string\",\"title\":\"The Description Schema\",\"default\":0,\"examples\":[\"abc\"]},}}}}}","DataProvider":"JSON","IntegratedSecurity":false,"Prompt":""},"Transaction":false}],"DataSets":[{"AccentSensitivity":"Auto","CaseSensitivity":"Auto","Collation":"","Fields":[{"Name":"ProductId","DataField":"ProductId"},{"Name":"ProductName","DataField":"ProductName"},{"Name":"QuantityPerUnit","DataField":"QuantityPerUnit"},{"Name":"UnitPrice","DataField":"UnitPrice"},{"Name":"UnitsInStock","DataField":"UnitsInStock"},{"Name":"ReorderLevel","DataField":"ReorderLevel"},{"Name":"Discontinued","DataField":"Discontinued"},{"Name":"CategoryId","DataField":"CategoryId"},{"Name":"CategoryName","DataField":"CategoryName"},{"Name":"Description","DataField":"Description"}],"KanatypeSensitivity":"Auto","WidthSensitivity":"Auto","Query":{"CommandText":"$.Data[*]","CommandType":"Text","DataSourceName":"NorthwindProducts","Timeout":0},"Name":"Products"}],"Layers":[{"Type":"layer","Name":"default"}],"TransformationInfo":[]}