PivotGridRowField header need same like column Header

[Syed]

Hi,
I need to set the Pivot grid PivotGridRowField header as same like PivotGridColumnField.
the Pivot grid both Row header and column header should be uniform.
Each rowfield header should have border shame like Colum filed header.

2) I want to export the Pivot grid it works fine but i need the Pivot grid row header should be added in export as column header.

[Antonio Stoilkov]

Hi Syed,

The zones that you have shown in the provided image are actually the RowHeaderZone (or Area) and the ColumnHeader which are two different types of sections. If you want to have the same fields in the RowHeaderZone as in the ColumnHeaderZone you could define the same fields as shown below. You could choose to hide the RowHeaderZone or the ColumnHeaderZone by using the RadPivotGrid ShowRowHeaderZone ShowColumnHeaderZone properties. 

<Fields>
    <telerik:PivotGridRowField DataField="Year" Caption="Year" UniqueName="DiscountRow">
    </telerik:PivotGridRowField>
    <telerik:PivotGridRowField DataField="Quarter" Caption="Quarter" UniqueName="UnitPriceRow">
    </telerik:PivotGridRowField>
    <telerik:PivotGridColumnField DataField="Year" Caption="Year" UniqueName="Discount">
    </telerik:PivotGridColumnField>
    <telerik:PivotGridColumnField DataField="Quarter" Caption="Quarter" UniqueName="UnitPrice">
    </telerik:PivotGridColumnField>
    <telerik:PivotGridAggregateField DataField="Quantity" Caption="Quantity" UniqueName="Quantity"
        Aggregate="Average" DataFormatString="{0:F2}">
    </telerik:PivotGridAggregateField>
</Fields>

Additionally, I would recommend going through the help article below which describes RadPivotGrid Fields and visually shows the differences.

• http://www.telerik.com/help/aspnet-ajax/pivotgrid-fields.html

Regards,
Antonio Stoilkov
Telerik

[Syed]

Hi ,
Thanks for your response,

But iam not asking about same Row File and Colum Filed .
I want the look and feel of both Row Field header and Column field header should be same.
For our project we are using Pivot grid and Rad Grid ,we need same look of pivot grid header as rad grid.
help me how to override the css of Pivot grid Row fild header as same like Colum header.
please see the attached file.

rowheader1.jpg  is the original out put
rowheaderneedsamelikeuniform2.png  needed output.

Thanks and Regards
Shanu

[Antonio Stoilkov]

Hello,

In order to achieve your scenario you could use the CSS provided below.

.RadPivotGrid .rpgRowsZone span.rpgFieldItem {
    background: none;
    border: none;
}

Additionally, if you want to override the how PivotGrid Fields look for the whole RadPivotGrid you could remove the .rpgRowsZone class selector as shown below.

.RadPivotGrid span.rpgFieldItem {
    background: none;
    border: none;
}

Regards,
Antonio Stoilkov
Telerik

[Syed]

Hi,
Thanks