whenever I am trying to add listWidth in Gantt chart it does not accept the width.
it always takes listwidth as zero.
Kendo spreadsheet keyboard navigation using arrow keys not working properly for the last column. please refer below .
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
3 - have ability to make filter simpler(UI, remove group option)
the scenario - I want to have the filter be above the grid & be able to apply the filtering on the server to limit the result set, but at the same time, when the result set is limited give the user the ability to filter the grid on the client using grid row filter
I am trying to bind it with dynamic columns SQL table paging. The issue is on the second scroll/page it failed the method.
Razor Page
@model System.Data.DataTable
@(Html.Kendo().Grid<dynamic>()
.Name("Grid")
.Sortable()
.Scrollable(sc => sc.Endless(true))
.Filterable()
.Groupable()
.DataSource(dataSource => dataSource
.Ajax()
.PageSize(100)
.Model(model =>
{
var id = "Id";
model.Id(id);
})
.Read(read => read.Action("Data_Read", "DynamicColumn"))
)
)
Controller DynamicColumn
public IActionResult Data_Read([DataSourceRequest] DataSourceRequest request)
{
var dt = GetViewsData(request.PageSize, request.Page);
var data = dt.ToDataSourceResult(request);
var viewData = new DataSourceResult()
{
Data = data.Data, //this return NULL on the second page/scroll request
Total = 181480 //total rows of table, just make it static
};
return Json(viewData);
}
public DataTable GetViewsData(int pageSize, int page)
{
try
{
int offSet = (page - 1) * 100;
string connString = "Server=.; Database=TheVault_VMC; Trusted_Connection=true; MultipleActiveResultSets=True; Encrypt=False;";
SqlConnection con = new SqlConnection(connString);
con.Open();
SqlCommand cmd = new SqlCommand("sp_GetData", con);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OFFSetRows", offSet);
cmd.Parameters.AddWithValue("@PageSize", pageSize);
SqlDataAdapter dataAdapter = new SqlDataAdapter(cmd);
var dataTable = new DataTable();
dataAdapter.Fill(dataTable);
dataAdapter.FillSchema(dataTable, SchemaType.Mapped);
con.Close();
return dataTable;
}
catch (Exception ex)
{
throw ex;
}
}
}
SQL Server Procedure
CREATE PROCEDURE [dbo].[sp_GetData]
@OFFSetRows INT,
@PageSize INT
As
BEGIN
SELECT Id, [Column1], [Column2], [Column3],[Column4],[Column5],[Column6]
FROM
[StagingDetail]
ORDER BY Id
OFFSET @OFFSetRows ROWS
FETCH NEXT @PageSize ROWS ONLY
END
The issue is the function ToDataSourceResult() returns NULL Data on the second request
Was wondering if there was a way to increase the indentation of the child grid when using the initDetails option?
I have this:
Want something like:
Is there any way of accieving this?
Thanks!
George
Hi team,
I often use the kendo custom download facility, works good usualy.
Now I have a problem with grid column grouping that seems broken due to the missing of chiplist component. (R2023.1.425).
But when you select all grid options in custom download, it does not select automatically the ChipList component. Please advise...
Another question please: what is the "DateInputCommon" entry. Should it be selected when taking any other date thing like "DatePicker" ?
Best regards,
Laurent.
Hi
I have tested the demo Scheduler Restriction and find its not giving accurate result when we manipulate date and time. I have added event with daily repeat occurrence (PFA the same 1.png) and open another event window with different date and time and change it manually with different date but same time whose already added (PFA the same 2.png) , hit save then its added successfully. (PFA the same 3.png) which is wrong according to this behaviour. its works fine when we open popup window on same date but only change time manually, problem is with changing date and time both to different ones. Hope you understand this. please resolve this asap.
Regards
Pankaj