Pivot Grid with datafield name as row field

2 posts, 0 answers
  1. rajesh
    rajesh avatar
    6 posts
    Member since:
    Jun 2011

    Posted 25 Mar 2013 Link to this post

    Is it possible to create a Pivot Grid with datafield name as row field.
    The data source and the final report format is given below just as an example.
    I have attached screen shot in case formatting is lost during the posting.

    Date source
    firm_ID firm_name PMName Region Market Forum month YEAR valuefield1 valuefield2 valuefield3 valuefield4 valuefield5
    48 hello john USA Food Genie 10 2012 0.1 0.9 0.8 0.8 0.8
    48 hello john USA Food Genie 11 2012 0.1 0.8 0.3 0.8 0.8
    48 hello john USA Food Genie 12 2012 0.1 0.6 0.5 0.8 0.8
    Pivot Grid Format
    Firm name PM Name Region Market Forum
    hello john USA Food Genie 2012
              10      11
    valuefield1    
    valuefield2    
    valuefield3    
    valuefield4    
    valuefield5    
  2. Daniel
    Admin
    Daniel avatar
    4946 posts

    Posted 28 Mar 2013 Link to this post

    Hello Rajesh,

    I'm afraid RadPivotGrid will not be able to generate the desired structure from the datasource shown on the screenshot. It seems to me that this demo will be more suitable for your scenario:
    Displaying Pivot data with RadGrid

    Kind regards,
    Daniel
    the Telerik team
    If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
Back to Top