Questions on Kendo UI for jQuery Forum

1 answer

44 views

Is there support for equivalent of RowTableLayout=Compact ?

Hi,

I can see that the PivotGrid has a "Compact" display mode in the ASP.NET AJAX libraries: https://docs.telerik.com/devtools/aspnet-ajax/controls/pivotgrid/layouts/overview

Is there a "Compact" mode that renders nested rows with only a slight offset instead of creating a whole new column in the jQuery libraries, or even in ASP.NET MVC version?

Kind regards,
Ilya

PivotGrid

PivotGridV2

answered on 18 Jul 2024

0 answers

158 views

PivotGrid Custom measures for subtotal

Hi

I need create one measure for total sales amount Proportion by product category. For Example:

column measure

Productcate , Productname salesamount amount%

A, A1 100, 58%

A, A2 50 29%

A, A3 20 11%

A subtotal 170 73%

B, B1 50 83%

B, B2 10 17%

b subtotal 60 27%

Total 230 100%

How to design this code function?

Thanks.

James

PivotGrid

asked on 14 Sep 2023

1 answer

233 views

cdn.kendostatic.com vs kendo.cdn.telerik.com

I've never really paid attention to this but got curious when trying to debug something.

What's the difference between cdn.kendostatic.com and kendo.cdn.telerik.com?

In some Telerik documentation there are references to kendo.cdn.telerik.com. When I created a Telerik app in VS 2022, most references use cdn.kendostatic.com.

Should one be used over the other?

PivotGrid

answered on 18 Apr 2023

0 answers

114 views

Kendo Pivotgrid

Hi,

How can I apply xmla data from asp.net core api to kendo pivotgrid using jquery.

So I created an endpoint that returns xmla data. just having a problem binding the data to the pivotgrid.

PivotGrid

PivotGridV2

asked on 12 Apr 2023

1 answer

243 views

Escaping special characters in Kendo PivotGrid for JQuery V1

Hi there,

Legacy PivotGrid does not support special characters in the column field headers (and possibly elsewhere), e.g. '&'. Is there a recommended escaping strategy - for example if I have a 'you & me' string, how do I transform it? and should I do it before datasource-ing the Pivot or in a header template?

(Looks like PivotGrid V2 does support this out of the box)

Thanks,
Georgi

PivotGrid

answered on 21 Dec 2022

1 answer

588 views

KendoUi Font icons are not loading

Actually we have kendoUi in angularjs project. which ic giving error in developer console like server not responding 404 error for webcomponentsicon.ttf and webcomponentsicon.woff. because of this icons are not loading. can anyone please help me to clear this issue

Hierarchical Data Source

answered on 15 Jun 2022

1 answer

427 views

Pivote Grid error: Uncaught TypeError: e.aggregate is not a function

I am attempting to locally run in my environment the code from the following demo:

https://demos.telerik.com/kendo-ui/pivotgrid/local-flat-data-binding

If I use the code functionally as-is it works fine. If however I change to an older version I receive the following error:

Uncaught TypeError: e.aggregate is not a function

My application is using version 2014.2.1008 which does provide the Pivot Grid even as it is a very old version. Is this a known issue resolved in a later version? Or perhaps I am just doing something wrong. Below is my code:

<!DOCTYPE html>
<html lang="en">
<head>
	<meta charset="utf-8"/>
    <title>Pivot Grid Demo</title>
    <link rel="stylesheet" href="http://kendo.cdn.telerik.com/2014.2.1008/styles/kendo.common.min.css" />
    <link rel="stylesheet" href="http://kendo.cdn.telerik.com/2014.2.1008/styles/kendo.default.min.css" />
    <link rel="stylesheet" href="http://kendo.cdn.telerik.com/2014.2.1008/styles/kendo.default.mobile.min.css" />
    <script src="http://kendo.cdn.telerik.com/2014.2.1008/js/jquery.min.js"></script>
    <script src="http://kendo.cdn.telerik.com/2014.2.1008/js/kendo.all.min.js"></script>
    <style>
        #configurator {
            width: 400px;
            min-width: 400px;
            display: inline-block;
            vertical-align: top;
        }

        #pivotgrid {
            width: 67%;
            display: inline-block;
            vertical-align: top;
        }
    </style>
</head>
<body>
    <script src="https://demos.telerik.com/kendo-ui/content/shared/js/products.js"></script>
	<div id="example">
	    <div class="hidden-on-narrow" id="configurator"></div>
	    <div class="hidden-on-narrow" id="pivotgrid"></div>
	
	    <div class="responsive-message"></div>
	
	    <script>
	        $(document).ready(function () {
	            var pivotgrid = $("#pivotgrid").kendoPivotGrid({
	                filterable: true,
	                sortable: true,
	                columnWidth: 120,
	                height: 570,
	                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,
	                filterable: true,
	                sortable:true,
	                height: 570
	            });
	        });
	    </script>
	</div>
</body>
</html>

PivotGrid

answered on 13 Oct 2021

1 answer

251 views

Pivot Grid, Column Values Populated When No Column Selected/Listed

I am currently working with the Pivot Grid; its quite nice. I have noticed though that if the Column is removed, the grid itself still retains data and formatting unique to that column. Using the demo as an example:
https://demos.telerik.com/jsp-ui/pivotgrid/index

The default columns are:

[Date].[Calendar] and [Product].[Category]

The default measure is:

[Measures].[Reseller Freight Cost]

If you remove all three of the above, both column fields and the measure, the resulting PivotGrid will still reflect a financial amount even though only a Row is populated with a Field.

See screen shot:

This is confusing to me and my users; why is it working this way? Is it possible to change this behavior?

PivotGrid

answered on 20 Sep 2021

1 answer

653 views

Pivot Grid Datasource, can JSON be used?

I'm struggling to get a Pivot Grid to populate. The demo works fine locally; however the datasource for it is XML from the datacube/dll. I have been using other widgets successfully with data delivered as JSON; is it possible to use JSON for the Pivot Grid? Are there any examples of this or even other examples of a Pivot Grid aside from the demo? Thanks in advance.

PivotGrid

answered on 02 Sep 2021

1 answer

121 views

Trigger Pivot grid element externally

Hi, I'm currently on trial and exploring the Kendo Pivot Grid feature.

I'm wondering is it possible to trigger interaction of the pivot grid element from externally element.
For example a button that when click, will expand this particular column members.

PivotGrid

answered on 25 Nov 2020