[Solved] Pivot Grid (URGENT)

[Dipti]

Hi Admin,



I want to display

Pivot Data

with RadGrid control , i have gone through the link
http://demos.telerik.com/aspnet-ajax/grid/examples/programming/pivot/defaultcs.aspx

it helps me but i want some modification

like i dont want to bind grid with automatically generated columns
bcz i need some image fileds and hyperlink fileds and gridtemplate columns
so I want to work with atugeneratedcolumns set to false
and manually adding labels to itemtemplates.

Any help really appreciated (Need help with code)

Thanks

[Sebastian]

Hi Dipti,

Review the answer I provided in the other forum thread you opened with regards to this subject:

http://www.telerik.com/community/forums/aspnet-ajax/grid/pivot-grid-template-columns.aspx

Kind regards,
Sebastian
the Telerik team

Check out Telerik Trainer , the state of the art learning tool for Telerik products.

[Jyoti]

Hi

I am using telerik pivot grid with your trail version.

I want display my data as shown in attached file  with some modification

Below is my pivot grid source

<telerik:RadPivotGrid ID="RadPivotGrid1" runat="server" OnNeedDataSource="RadPivotGrid1_NeedDataSource"
                 AllowPaging="true" OnCellDataBound="RadPivotGrid1_CellDataBound"  >
                 <ClientSettings Scrolling-AllowVerticalScroll="true" EnableFieldsDragDrop="true">
                 </ClientSettings>
                 <TotalsSettings GrandTotalsVisibility="RowsOnly" />
                 <Fields>
                          <telerik:PivotGridRowField DataField="BookingMonth">
                                   <CellTemplate>
                          <%--     <strong><%# Container.DataItem %></strong>--%>
                                            <asp:Label ID="Label1" runat="server">
                                                                                       <%# GetMonthName(Container.DataItem)%>
                                            </asp:Label>
                                   </CellTemplate>
                          </telerik:PivotGridRowField>
        
                                   <telerik:PivotGridColumnField DataField="MISType" UniqueName="MISType">
                         
                          </telerik:PivotGridColumnField>
                          <telerik:PivotGridColumnField DataField="BookedYear" UniqueName="BookedYear">
                         
                          </telerik:PivotGridColumnField>
                          <telerik:PivotGridAggregateField DataField="MISValue" UniqueName="MISValue">  
                          </telerik:PivotGridAggregateField>                 
                
                 </Fields>       
        
         </telerik:RadPivotGrid>

But came across some issue

(please refer attached image)

1 .

The first row is my month name but I could not bind month name field directly to DataField because I want to display my moth name as

January

February

March

April

And so on

But after binding the row data get sorted so it will display like

April

December

February

And so on

Is there any option to avoid the compulsory sorting

To solve this problem I have bind  Booking month number to DataField of row then inside cell template I have called custom function

Which will return the month name based on supplied month number.

This fails in case of drag drop action if I drag that row to column then  it will displays the month number instead month name. Also inside filter popup it will displays month number only.

 

2.

Is there any way to add formulated column in pivot grid

Ex Inside Bookings there is Booked year which has  MISValue

After the Booked year I want to add one more column Year % change the values of this column will be ( 2013BookingValue/ (2012 BookingValue-1)) means (129.00/(94.00-1))

Is it possible to add formulated column.

 

Pivot grid has support to above mentioned issue then we will think to buy the licensed version.

 

Is there any functionality difference between trail version and licensed version.

 

 

Thanks in advance.

[Radoslav]

Hello Jyoti,

Unfortunately the RadPivotGrid does not support the desired functionalities. However I will send your requirements to our developers for further considerations. At a meantime you can achieve the first one by using additional field with numbers which are corresponding to the months names. Then after binding you can replace the numbers with corresponding months into the CellDataBound event. More information about formatting values into the cells you can find here:
http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/appearance/conditionalformatting/defaultcs.aspx

I hope this helps.

Regards,
Radoslav
Telerik