RadPivotGrid functionality

6 posts, 0 answers
  1. wallisp1
    wallisp1 avatar
    2 posts
    Member since:
    Aug 2013

    Posted 19 Aug 2013 Link to this post

    Hi,
     I am investigating the replacement of the retired Microsoft OWC with a component with similar functionality. I have looked through the demos and I would like to verify that the following logic is achievable using the PivotGrid control.

    Call the PivotGrid webpage passing a parameter of either a MS SQL database table or MS Analysis Services OLAP cube and programmatically bind to that dynamic data source.

    If a default view has been previously created and saved in a SQL system table then that saved view is retrieved and the PivotGrid restored back Q: Using the Persistance.Framework demo functionality can the view layout be written into an SQL table?

    If no default views exists, and the user is authorised to create views, then display an empty view of the data with all the drop areas (like the Fields List demo sample) to allow the user to construct their own view of the data. If the user is not authorised to create new views then the PivotGrid drop areas are all disabled and not displayed.

    If other views exist in the system table then allow these to be selected from a dropdown list and the PivotGrid restored back.

    Switch the displayed view between either the PivotGrid or a Chart based on the PivotGrid.

    I think all this is achievable but I would like confirmation before downloading the 30 day trial and attempting a prototype ahead of purchasing.

    Finally, could this be achieved using the Kendo UI as well as the ASP controls?

    Thanks,

    Paul.
  2. Antonio Stoilkov
    Admin
    Antonio Stoilkov avatar
    530 posts

    Posted 22 Aug 2013 Link to this post

    Hi Paul,

    The described scenario could be achieved using the RadPivotGrid control. You could programatically in code behind set to what the RadPivotGrid should be bound to. For persisting the setting you could take a look at the links below. Note that currently the RadPivotGrid FilterExpressions could not be persisted but we plan to implement the functionality as soon as possible. Additionally, the KendoUI controls does not have a RadPivotGrid control and it is not possible to achieve the same functionality using them.

    You could try implementing the desired functionality and if you have any additional questions during the development please do not hesitate to contact us again.

    Regards,
    Antonio Stoilkov
    Telerik
    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 the blog feed now.
  3. UI for ASP.NET Ajax is Ready for VS 2017
  4. wallisp1
    wallisp1 avatar
    2 posts
    Member since:
    Aug 2013

    Posted 22 Aug 2013 Link to this post

    Thanks for the response Antonio. I had not found the link to what properties of what controls the Persistance Framework can serialize. I had looked at the Persistance demo using the RadPivotGrid

    http://demos.telerik.com/aspnet-ajax/persistence-framework/examples/custom-serializer-provider/defaultcs.aspx

    and had made the assumption that all the controls were being saved/restored. So referencing the demo sample for the RadPivotGrid:

    http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/olap/defaultcs.aspx

    does this mean that to save/restore a layout constructed in this demo it would be necessary to write custom code that walks the filter fields, row fields, column fields, aggregate fields and a custom process to save/restore all or only that the filter fields needs to be custom coded and the Persistence Framework will handle the rest (I don't see all the other field properties listed in the RadPivotGrid section of the Persistance Framework reference) ?

    In a nutshell I need to be able to reproduce the functionality of the OLAP RadPivotGrid demo with a variable data source and with the addition of full save/restore capability of layout and filter, row, column and aggregate fields.
  5. Antonio Stoilkov
    Admin
    Antonio Stoilkov avatar
    530 posts

    Posted 27 Aug 2013 Link to this post

    Hi Paul,

    You are correct in your observations. The PersistanceFramework will persist all settings excluding the RadPivotGrid filtering for each field. In order to achieve your scenario you could manually save the filters and use the PersistanceFramework for everything else. Note that we have planned implementing filtering persistence. However, we could not pinpoint an exact date or release that the functionality will be available.

    Regards,
    Antonio Stoilkov
    Telerik
    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 the blog feed now.
  6. Asad
    Asad avatar
    1 posts
    Member since:
    Jun 2012

    Posted 09 Oct 2013 Link to this post

    Your API does not provide, exactly how to access the filters state from RadPivotGrid1 object, any pointer will be help full.
  7. Antonio Stoilkov
    Admin
    Antonio Stoilkov avatar
    530 posts

    Posted 14 Oct 2013 Link to this post

    Hi Asad,

    In order to achieve your scenario you could use the RadPersistanceFramework SaveCustomSettings event and save the RadPivotGrid Filters property which contains all filters. You could take a look at the help article below which describes how to use the SaveCustomSettings event.

    Regards,
    Antonio Stoilkov
    Telerik
    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 the blog feed now.
Back to Top
UI for ASP.NET Ajax is Ready for VS 2017