Using SQL's Pivot table

[Scott Manning]

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

[Angel Petrov]

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