Customized Report with pivotgrid

2 posts, 0 answers
  1. Sanju
    Sanju avatar
    3 posts
    Member since:
    Nov 2012

    Posted 31 Jul 2013 Link to this post

    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.
  2. Angel Petrov
    Admin
    Angel Petrov avatar
    1007 posts

    Posted 05 Aug 2013 Link to this post

    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
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to the blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top