Which control would be best?

[Kurt Kluth]

Have a project that I am working on where I must provide the end-user with the ability to perform a custom search on the data and each user may require different information to be returned.  Currently having the data (2 columns) being dumped into a Telerik datagrid and going to utilize the grid filter to allow them to filter the data even more. 

However I would like suggestions on which Telerik AJAX control might be best to fit my scenerio.  Currently there are 8 major categories and under that could be any number of sub groups (40 in total spread across the 8 categories) and any number of fields (628 in total).  The user is to select what fields they would like displayed in the datagrid. 

Have thought about using a TreeList and don't believe it to be difficult to populate the tree based upon our database records.  But I would then need to take the fields they selected and add them to the query which would populate the datagrid.  Is that possible? 

Or is there a better control for displaying those 628 fields in a much more user-friendly manner. 

Suggestions are welcome.

[Pavlina]

Hi Kurt,

To achieve the desired functionality you can use our new RadPivotGrid control. RadPivotGrid is a data summarization control where users can break down raw data in any manner they want. A pivot table can help quickly summarize the reports and highlight the desired information. It displays data in format such as spreadsheets or business intelligence applications.

Additionally, you can use RadPivotGrid ConfigurationPanel which gives the user ability to separate the logic for manipulating fields and displaying data. An online example which demonstrates this functionality is available here.

Kind regards,
Pavlina
the Telerik team

[Kurt Kluth]

Thank you for the suggestion.  As the RadPivotGrid control seems like a very good control not seeing that it fitting the needs.  I did attempt to use it but couldn't figure out how to just return the initial results to look like a standard radgrid and then allow the user to then control how they would like to view it. 

Attached is an image of what I am trying to accomplish and have thus far used the RadPanelBar and a combination of RadTreeView and RadListBox, however trying to determine which of those would be best to implement. 

Currently it is working if a user selects the fields they would like and then clicks update results it will then update the radgrid.  Some of the controls seem temperamental.  Though I have specified the width of the RadGrid, when I add columns dynamically it will auto grow beyond the width which I specified.  If I tell it that "TableLayout=Fixed", it works but the more columns I add it will cause the columns to be more condensed.  Which then takes away the ability to filter on the columns. 

[Boyan Dimitrov]

Hello Kurt,

Considering the attached image I would recommend using our RadPanelBar control combined with templates. The templates support gives you ability to customize your RadPanelBarItems in various ways.
I would like to suggest reviewing our RadPanelBar online demos to get familiar with all control functionalities.
Here you may find our RadPanelBar documentation resources divided in sections.
Please take a closer look at our RadPanelBar templates demo and help article.

Do not hesitate to contact us if you have any further questions.

All the best,
Boyan Dimitrov
the Telerik team