none
Unpivot SharePoint list data in SSRS

    Question


  • I need to unpivot data from a sharepoint list to support a report.

    the data looks like this

    Policy  comissiona comissionb comissionc

    a           1                 2                 3

    b           4                 5                  6

    i want the result

    as

    policy comission    total 

    a comission a        1

    a comissionb           2

    a  comissionc         3

    b  comission a       4

    bcomissionb           5

    b comissionc         6


     Thanks


    Tuesday, December 24, 2013 2:24 PM

All replies

  • Hi Vision2040,

    Based on my research, it’s not supported that making Unpivot data from a sharepoint list currently.In general, we can use PIVOT and UNPIVOT relational operators to change a table-valued expression into another table.

    For the details, please refer to the link:
    http://technet.microsoft.com/en-us/library/ms177410(v=sql.105).aspx

    Regards,
    Heidi Duan

     


    Heidi Duan
    TechNet Community Support

    Wednesday, December 25, 2013 8:33 AM
  • Hi,

    Yes it can be done with sql but  in my case i cant stage the data so i need some vb function  which takes the fields and transforms

    Thanks

    Wednesday, December 25, 2013 2:38 PM