Hello.

I am using Export to Excel functionality.

Is there a way of adding page numbers to the excel generated from the grid?

I have tried the following but it does not work.

function excelExport(e) {
        var sheet = e.workbook.sheets[0];

        sheet.pageNumber = true;

}

Or is there any property which can be set when defining the Excel?

       .Excel(excel => excel
        .FileName("Users.xlsx")
        .Filterable(true)
        .ProxyURL(Url.Action("Excel_Export_Save", "UserAndGroup"))
       )

Thanks

I have a Grid with a mix of static and dynamic columns.  The static columns have a lot going on -- the user can choose groups of columns to display.  There's formatting, commands, etc. I retrieve the main list of models from the database based on some filter criteria from the user.  Based on the user selection for displayed columns, I augment the data returned with additional data and fill out more data on the models. 

However, the tricky part is that users can customize additional fields they want to see in this table.  These fields are dynamic.  Our application is for building forms, so they define their own fields.  Let's say a customer defines 200 fields they want to have on their form.  Of those 200 fields, they wish to display 4 of them in the grid I'm struggling with.  These fields are stored in a table "flat",so like:

CustomerID       FieldID    FieldName

1                        1              "age"

The answers to these are stored like:

FieldID      UserID     Value:

1                1              25

I retrieve the data for these dynamic fields with a combination of Linq and SQL.  I pivot the data, so get:

UserID        1              3                4         6

1                25          "foo"            "bar"      3/4/2010

Currently, I'm taking these results and I'm adding it to a Dictionary<> per Model.  Then I dynamically add them to my Kendo MVC grid:

             
              foreach (var key in Model.AdminColumns.Keys)
              {
                  c.Template(@<text>@item. </text>).ClientTemplate(String.Format("#=CustomFields['{0}']#", key.ToUpper())).HeaderTemplate(Model.AdminColumns[key]);
                  }
              })

I can display the data just fine.  However, I really need to add sorting and filtering to these columns.  I understand that's not supported the way I'm doing it.  The problem is, I can't seem to find a solution that will give me what I need.  I can't change the nature of the data obviously.  But, I'm willing to take a new approach.  However, I keep running into road blocks.  I tried using the dynamic keyword and building a model, but the grid helper didn't like that.  I was thinking of going down the path of returning a json model with the dynamic fields merged in as first class members of each dataitem, but then i'm not sure how to define the grid.

Do you have any suggestions?  My complete grid code is shown below.  

Hi,

I have 2 CategoryAxis, by Month and Year:

Is there a way to align the Year within that Years Months. For instance currently the years are split evenly along the graph and not sitting within the Jan > Dec of the current year. See attached image.

Thanks.

HI

I have found that MaskedTextBox ClearPromptChar(true) NOT WORKS in Grid/EditorTemplates*.

Is there have any solution ?

*see attachment.

*Telerik DevCraft R2 2017 SP1.

Best regards

Chris

Hi,

I want to set my grid in percentage  and not by pixels, I don't find the way to do it, because although I set the grid to be set by percentage it's always required pixels in the div uses the class "k-grid-content"

can you help me? I want the grid to look good in pc and also in laptop/

Thanks!

I developed a Kendo MVC Grid which displays a pop-up for updates. Popup Edit screen is a Custom template with a dropdown list that calls the controller to populate the . In this case, I am populating the prefixes. The  is populated fine, but when I click on a row on the grid to edit an item, I need to pre-select the value in the drop-down. let's say if a particular row has a value of "Mr." as a prefix, I need it to be pre-selected in the popup .

If the use of a  @Html.EditorFor(model => model.Prefix), it perfectly populates the editor fine. This doesn't work for Dropdown.

The editor template is called MemberEdit and the code in it is as below:

The Grid code is as shown below: 

The Model is as below:

i have downloaded and installed latest version of kendo UI for mvc into existing project. since then the datetimepicker doesn't stay open,can anyone help me with this.

thanks 

Hi,

I tried to set the grid height in percents and it's doesn't effect?

how can I do it? I want it to looks  good in pc and laptop and I don't want to have 2 vertical scrollbar (one for the window and one for the grid)/ i want only for the grid.

Thanks

Hi,

I have a chart in Excel i'd like to replicate, i've attached an image of it (Chart1). I've currently gotten this far (Chart2).

Here's the code:

2 Issues:

1. I'm not sure how to stack the sum of TimesheetHours into the Month and Year from TimesheetWorkDateMonthYear (DateTime)
2. I don't now how to get the Key to should the Month and Year instead of the Person (FullName)

My Class: