Using SQL's Pivot table

2 posts, 0 answers
  1. Scott Manning
    Scott Manning avatar
    20 posts
    Member since:
    Oct 2012

    Posted 07 Jul 2015 Link to this post

    Can the Radpivotgrid make use of the pivot commands in SQL to have the SQL system handle the summary processing?  

    For example the SQL script below seemed to not format correctly in the pivotgrid

     

    create table Report
     (
     deck char(3),
     Jib_in float,
     rev float,
     rev_insight float,
     jib_out float,
     creation float
     )

     insert into Report  values
     ('A_1',0.345,0,0,1.23,20140212),
     ('B_2',0.456,0,4,2.34,20140215),
     ('C_3',0.554,0,6,0.45,20140217),
     ('D_4',0.231,0,8,7.98,20140222),
     ('E_5',0.453,0,0,5.67,20140219),
     ('F_6',0.344,0,3,7.23,20140223)



    SELECT HEADER, [A_1],[B_2],[C_3],[D_4],[E_5],[F_6]        
    FROM    
    (SELECT DECK,HEADER, VALUE FROM REPORT   
    UNPIVOT      

    VALUE FOR HEADER IN ([JIB_IN],[REV_INSIGHT],[JIB_OUT],[CREATION])  
    ) UNPIV
    ) SRC     
    PIVOT    
    (
    SUM(VALUE) 
    FOR DECK IN ([A_1],[B_2],[C_3],[D_4],[E_5],[F_6]) 
    ) PIV

  2. Angel Petrov
    Admin
    Angel Petrov avatar
    1006 posts

    Posted 10 Jul 2015 Link to this post

    Hi,

    I am sorry to say but such functionality is not supported. With the current implementation the pivot control should handle the calculation instead of displaying the calculated values.

    If this is an important requirement for your project you can log a feature request in our feedback portal. If this is a commonly requested feature we may implement it for a future release.

    Regards,
    Angel Petrov
    Telerik
    Do you want to have your say when we set our development plans? Do you want to know when a feature you care about is added or when a bug fixed? Explore the Telerik Feedback Portal and vote to affect the priority of the items
  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top