Customized Report with pivotgrid

[Sanju]

Hi Dear,

I am using radpivotgrid for achieving a customized report that have

Row -> Customer Name (Retrieving from Data Source)
Main Column -> Carrier Name (Retrieving from Data Source)
2 Sub Columns under Main Column -> "Minimum" and "MarkUp" - These are headings of the column
2 Data Columns under it need to show the minimum and markup values, that retrieved from data source.

And this need to be exported to excel. (please see below attachments for further clarification). Please suggest me to solve this.
1) Customer Carrier Report.png--> this is the output I am getting with pivot rad grid
2) Expected OutPut.png --> This is what I need to achieve.

[Angel Petrov]

Hello Sanju,

In order to configure the pivot like demonstrated in the picture provided you can use this field setup:

<Fields>
                <telerik:PivotGridRowField DataField="Customer Name">
                </telerik:PivotGridRowField>
                <telerik:PivotGridColumnField DataField="Carrier Name">
                </telerik:PivotGridColumnField>
                <telerik:PivotGridAggregateField DataField="Minimum" Aggregate="Sum" >
                </telerik:PivotGridAggregateField>
                <telerik:PivotGridAggregateField DataField="MarkUp" Aggregate="Sum" >
                </telerik:PivotGridAggregateField>
            </Fields>

Additionally if some groups will have no data you can set the ShowGroupsWhenNoData property of the PivotGridColumnField to true. In attachments you can find a sample website in which the pivot is configured according to the requirements. As for how to export the content I strongly suggest that you examine this online demo.

Regards,
Angel Petrov
Telerik