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.
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.