Pivot GridView

Posted by: fandresmo on 10 September 2017, 11:39 am EST

  • Posted 10 September 2017, 11:39 am EST

    I am new using C1 controls, but I managed to group some columns in a gridview control and adding some bands above those columns, however I also need to pivot the information. I mean, i need to show columns as rows and viceversa whilst keeping bands not above the columns this time but at the left of the "pivoted" rows.

    Please let me know if that is possible and how. I am using ASP.NET with VB.NET

    Regards
  • Replied 10 September 2017, 11:39 am EST

    Hello,

    Please refer to our blog on how to display C1GridView as Pivot Grid :
    http://our.componentone.com/2011/07/22/pivot-c1gridview/

    Thanks,
    Richa
  • Replied 10 September 2017, 11:39 am EST

    Hello,

    Thank you so much for your kind help. I figured out how to pivot the table before my post. But as I wrote previously, my problem comes when I want to use Bands... I added some band so the table has grouped rows, but when I try to pivot the table, I can't do it.

    Perhaps do you have some other examples using bands as well as pivoting the table, so I can have those bands at left instead at top?

    Please let me know

    Best regards
  • Replied 10 September 2017, 11:39 am EST

    Hello,

    The feature that you are requesting is more of OLAP functionality and our C1GridView does not support this.

    Unfortunately, we do not have OLAP for ASP.NET. However, the feature that you are requesting is available in our Olap for Silverlight and our new Olap for LightSwitch. You may try using those components.

    Thanks,
    Richa
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels