or
10 answers
306 views
hello,
I am use this example http://dojo.telerik.com/AZamu/2, with local binding I was modify to sort and filter and it don't work, this is my code:
<!DOCTYPE html>
<html>
<head>
<base href="http://demos.telerik.com/kendo-ui/pivotgrid/local-flat-data-binding">
<style>html { font-size: 12px; font-family: Arial, Helvetica, sans-serif; }</style>
<title></title>
<link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.common.min.css" />
<link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.default.min.css" />
<link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.dataviz.min.css" />
<link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.dataviz.default.min.css" />
<script src="http://cdn.kendostatic.com/2014.3.1411/js/jquery.min.js"></script>
<script src="http://cdn.kendostatic.com/2014.3.1411/js/kendo.all.min.js"></script>
</head>
<body>
<script src="../content/shared/js/products.js"></script>
<div id="example">
<div id="configurator"></div>
<div id="pivotgrid"></div>
<script>
$(document).ready(function () {
var pivotgrid = $("#pivotgrid").kendoPivotGrid({
columnWidth: 120,
height: 570,
filterable: true,
sortable: true,
dataSource: {
data: products,
schema: {
model: {
fields: {
ProductName: { type: "string" },
UnitPrice: { type: "number" },
UnitsInStock: { type: "number" },
Discontinued: { type: "boolean" },
CategoryName: { field: "Category.CategoryName" }
}
},
cube: {
dimensions: {
ProductName: { caption: "All Products" },
CategoryName: { caption: "All Categories" },
Discontinued: { caption: "Discontinued" }
},
measures: {
"Sum": { field: "UnitPrice", format: "{0:c}", aggregate: "sum" },
"Average": { field: "UnitPrice", format: "{0:c}", aggregate: "average" }
}
}
},
columns: [{ name: "CategoryName", expand: true }, { name: "ProductName" } ],
rows: [{ name: "Discontinued", expand: true }],
measures: ["Sum"]
}
}).data("kendoPivotGrid");
$("#configurator").kendoPivotConfigurator({
dataSource: pivotgrid.dataSource,
height: 570
});
});
</script>
<style>
#pivotgrid
{
display: inline-block;
vertical-align: top;
width: 70%;
}
#configurator
{
display: inline-block;
vertical-align: top;
}
</style>
</div>
</body>
</html>
Why It don't work wiht local bind?
Thanks.
I am use this example http://dojo.telerik.com/AZamu/2, with local binding I was modify to sort and filter and it don't work, this is my code:
<!DOCTYPE html>
<html>
<head>
<base href="http://demos.telerik.com/kendo-ui/pivotgrid/local-flat-data-binding">
<style>html { font-size: 12px; font-family: Arial, Helvetica, sans-serif; }</style>
<title></title>
<link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.common.min.css" />
<link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.default.min.css" />
<link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.dataviz.min.css" />
<link rel="stylesheet" href="http://cdn.kendostatic.com/2014.3.1411/styles/kendo.dataviz.default.min.css" />
<script src="http://cdn.kendostatic.com/2014.3.1411/js/jquery.min.js"></script>
<script src="http://cdn.kendostatic.com/2014.3.1411/js/kendo.all.min.js"></script>
</head>
<body>
<script src="../content/shared/js/products.js"></script>
<div id="example">
<div id="configurator"></div>
<div id="pivotgrid"></div>
<script>
$(document).ready(function () {
var pivotgrid = $("#pivotgrid").kendoPivotGrid({
columnWidth: 120,
height: 570,
filterable: true,
sortable: true,
dataSource: {
data: products,
schema: {
model: {
fields: {
ProductName: { type: "string" },
UnitPrice: { type: "number" },
UnitsInStock: { type: "number" },
Discontinued: { type: "boolean" },
CategoryName: { field: "Category.CategoryName" }
}
},
cube: {
dimensions: {
ProductName: { caption: "All Products" },
CategoryName: { caption: "All Categories" },
Discontinued: { caption: "Discontinued" }
},
measures: {
"Sum": { field: "UnitPrice", format: "{0:c}", aggregate: "sum" },
"Average": { field: "UnitPrice", format: "{0:c}", aggregate: "average" }
}
}
},
columns: [{ name: "CategoryName", expand: true }, { name: "ProductName" } ],
rows: [{ name: "Discontinued", expand: true }],
measures: ["Sum"]
}
}).data("kendoPivotGrid");
$("#configurator").kendoPivotConfigurator({
dataSource: pivotgrid.dataSource,
height: 570
});
});
</script>
<style>
#pivotgrid
{
display: inline-block;
vertical-align: top;
width: 70%;
}
#configurator
{
display: inline-block;
vertical-align: top;
}
</style>
</div>
</body>
</html>
Why It don't work wiht local bind?
Thanks.
Alex Hajigeorgieva
Telerik team
answered
on
18 Nov 2020
7 answers
525 views
Hi,
I am following this https://github.com/telerik/kendo-ui-core/blob/master/docs/api/javascript/data/pivotdatasource.md to build a pivot grid.
How can I check the data source that is used in the following read method? I want to take a look at the structure and build my own olap data source. But when I click the link, it gives 500 error.
<script>var dataSource = new kendo.data.PivotDataSource({ type: "xmla", measures: { values: ["[Measures].[Internet Order Lines Count]", "[Measures].[Days Current Quarter to Date]"], axis: "rows" }, transport: { connection: { catalog: "Adventure Works DW 2008R2", cube: "Adventure Works" }, }, schema: { type: "xmla" }});dataSource.fetch();</script>
Preslav
Telerik team
answered
on
13 Nov 2020
6 answers
107 views
I have added some fields with caption names like this:
location: { caption: "Butik" }
but the problem is that its not used for grouping
it seems like a bug to me, is there way around it?
https://stackoverflow.com/questions/31749074/kendo-pivotgrid-translation-bug
Tsvetomir
Telerik team
answered
on
06 Nov 2020
3 answers
54 views
Hi,
With PivotGrid is it possible to view the underlying data that makes up a calculated value. For example clicking on a cell and seeing all the rows that make up the calculated value for that cell.
Cheers,
Angel Petrov
Telerik team
answered
on
18 May 2020
3 answers
321 views
When I try to run the a function, the grid does not detect this and gives an error.
Preslav
Telerik team
answered
on
22 Apr 2020
1 answer
122 views
Hi Telerik,
Does pivot grid has ability to enable this mode?
If yes, can you share sample code.
Tsvetomir
Telerik team
answered
on
28 Nov 2019
1 answer
174 views
Hi,
I'd like to use the PivotGrid control in a scenario where there may be several layers of grouping in the Rows.
At the moment on the demos page I can see that when you expand a group (eg "All Products"), the expanded items are not directly below the All Products heading but off to the right. This very quickly eats up horizontal room.
Is it possible to instead nest the expanded items almost directly below the heading (maybe only slightly to the right), like you'd expect in a tree view?
I'm including a screenshot of what it looks like and what I'd like to be able to do.
Cheers,
Ilya
Tsvetomir
Telerik team
answered
on
01 Nov 2019
1 answer
102 views
Hi,
My requirement is to populate json data with Pivot grid using date as a filter and each fields data should be populated in single row of that particular date.
Is there any custom option available for pivot grid for my requirement?
please suggest.
Boyan Dimitrov
Telerik team
answered
on
17 Dec 2018
3 answers
118 views
Is there an example of grid and pivot grid connected to normal database or rest api to get remote json data?
In the example I see only Olap or local json data into js file.
Thank you
In the example I see only Olap or local json data into js file.
Thank you
Alex Hajigeorgieva
Telerik team
answered
on
15 Oct 2018
1 answer
79 views
I'm using kendo ui with mvc pivto grid local_flat_data_binding. I have problem in the chrome's console saying that 'kendoPivotConfigurator is not a function'
Here is my layout's code
@Scripts.Render("~/bundles/jquery")<br> @Scripts.Render("~/bundles/jqueryval")<br> <br> @Styles.Render("~/Content/css")<br> @Scripts.Render("~/bundles/modernizr")<br> <br> <br> <link rel="stylesheet" href="http://kendo.cdn.telerik.com/2018.2.620/styles/kendo.common-bootstrap.min.css" /><br> <link rel="stylesheet" href="http://kendo.cdn.telerik.com/2018.2.620/styles/kendo.bootstrap.min.css" /><br><br> <script src="http://kendo.cdn.telerik.com/2018.2.620/js/kendo.all.min.js"></script><br> <script src="http://kendo.cdn.telerik.com/2018.2.620/js/kendo.aspnetmvc.min.js"></script><br><br> <script src="https://kendo.cdn.telerik.com/2018.2.620/js/jszip.min.js"></script><br><br> <script src="http://kendo.cdn.telerik.com/2018.2.620/js/kendo.all.min.js"></script><br> <script src="http://kendo.cdn.telerik.com/2018.2.620/js/kendo.timezones.min.js"></script><br> <script src="http://kendo.cdn.telerik.com/2018.2.620/js/kendo.aspnetmvc.min.js"></script>
my html page and the controller are exactly like the examples sample.
Thank you
