This is a migrated thread and some comments may be shown as answers.

[Solved] Export each detail grid to a different sheet

1 Answer 137 Views

Grid

This is a migrated thread and some comments may be shown as answers.

Chris asked on 16 Apr 2015, 03:27 PM

Hello everyone,

I am having an issue and I am attempting to fix it with a different strategy. SO first I will explain my issue and see if anyone has an answer. THen I will explain my idea for a work around and see if anyone can get me going there.

The issue:

I have a grid with a detail grid in each row. Basically it is a list of employees with data concerning that employees goals in the detail grid. This all works great. Data is there everything is solid.

The detail grid are grouped programmatically by a "goal type" column. Again, this all work perfectly.

Here is where it gets wonky. If I export to pdf the entire structure is pristine. Looks exactly as it does on the web page.

However, If I export to Excel things start to get screwy. The "parent" grid rows are there but they have a header...which is ok, but then sometimes the detail grid information is where it should be and other times it is pushed down under the wrong employee name.

Before anyone asks I am using the promises and the prevent default to make sure the data is filled before saving, as shown in all the examples.

I am pretty sure it is an issue with the grouping inside the detail grid. If I remove it then the excel document is perfect...other then not being grouped.

My ideas and request for strategies and or input:

My first idea is this. Is there any way to remove the grouping on the detail grid programmatically before I save the excel doc and have the managers who are exporting just create their filters on their own. This is not ideal but I think it could work.

My second idea and I think it is a much better one is to export each employee and their data on a different sheet/tab within the workbook. Similar to this example.

http://docs.telerik.com/kendo-ui/web/grid/how-to/excel/multiple-grid-export

I have no idea how to do this in the context of the parent grid and the detail grid. The example shows two "parent" grids on one page not grids within grids.

it would have to be a loop or another set of deferreds and promises but I need some input here.

Any help would be appreciated.

[Solved] Export each detail grid to a different sheet

1 Answer, 1 is accepted