Field chooser available?

[Ewald Hofman]

I am busy with an investigation which ASP.NET grid control to use. Some of the other grid vendors have the ability of having a visual field chooser in which the end user can add and remove the colums by having a toolbox with the invisible columns.

Does the RadGrid have this functionality too?

[Tsvetina]

Hi Ewald,

RadGrid offers built-in hiding and showing columns functionality (client-side) using through the Header context menu feature. You can see it for yourself here, along with the other ready-to-use functionalities of the menu:
http://demos.telerik.com/aspnet-ajax/grid/examples/generalfeatures/headercontextfiltermenu/defaultcs.aspx

Best wishes,
Tsvetina
the Telerik team

[E]

Hi,

Does column(s) chooser available on Excel Like Filtering? Thanks.

Note that my project uses UI for ASP.NET AJAX Q1 2016. 

Regards

 

[Viktor Tachev]

Hi,

The context menu is available when you enable Excel-like filtering. Thus, you can show/hide the columns in RadGrid. Please examine the following example that illustrates the approach.

• http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/filtering/excel-like-filtering/defaultcs.aspx

Regards,
Viktor Tachev
Telerik by Progress

[E]

Hi Viktor,

Thanks for the response.

I downloaded the Live Demos from Telerik and ran the sample code as per the suggested URL you advised and it worked. The Telerik.Web.UI Trial Version was 2016.2.607.45.

However, it did not work on my RadGrid. I attached a screen shot of the properties used on my RadGrid for you to review. The Telerik.Web.UI Version was 2016.1.1136.45 on my bin folder.  

Please advise! Thanks.

Regards

 

 

 

[Viktor Tachev]

Hi,

I examined the provided code and the settings for the Grid look correct. The EnableHeaderContextMenu and EnableHeaderContextFilterMenu properties are enabled. Thus, the excel-like filtering should be enabled. Please ensure that the checklist values are populated in the FilterCheckListItemsRequested.

If you would like more detailed information on the excel-like filter functionality you would find the following article interesting.

• http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/filtering/checklist-filtering#filtertype-headercontext

With that said, would you elaborate in more detail on what is not working as expected on your end?


Regards,
Viktor Tachev
Telerik by Progress

[E]

Hi Viktor,

Thanks for the reply.

The 'EnableHeaderContextMenu' and the 'EnableHeaderContextFilterMenu' properties were enabled on the grid, and the 'FilterCheckListItemsRequested' had populated checklist values successfully. For some reason, the 'Columns' filtering option was not available from the 'Excel Like Filter' instead of two lines were shown below the 'Ungroup' option.(see attachment ExcelLikeFilter.png')

I was aware that the 'Columns' filtering option was not available from the FilterTypeHeaderContext example as well. (see attachment FilterTypeHeaderContext.png from http://docs.telerik.com/devtools/aspnet-ajax/controls/grid/functionality/filtering/checklist-filtering#filtertype-headercontext )

Regards,

E

 

[Eyup]

Hi E,

Yes, RadGrid provides Column chooser in its Excel-like filtering HeaderContext menu functionality:
http://demos.telerik.com/aspnet-ajax/grid/examples/functionality/filtering/excel-like-filtering/defaultcs.aspx

I am sending 2 web site samples, which may prove helpful in this case. Please run the second one and ensure that the Column chooser submenu is working as expected.

Regards,
Eyup
Telerik by Progress

[E]

Hi Eyup,

Thank you very much for providing me the samples. 

You advised me to run the 'RadGridFilterExcelLikeIndication' solution. Unfortunately it didn't work as expected. There were two lines below the 'Ungroup' option and the 'Column' option was still missing from the filtering menu. I provided a screen shot for your information. 

I stated that the 'Column' option was available on the Live Demos downloaded from Telerik where the trail version of the Telerik.Web.UI was 2016.2.607.45.  However, the 'Column' option was missing on my solution where the version of the Telerik.Web.UI was 2016.1.1136.45 on my bin folder. Could this issue cause by a different version of the Telerik.Web.UI?  

Please advise. Many thanks. 

Regards

[Viktor Tachev]

Hello,

I tried to replicate the behavior from the screenshot, however, I was not able to. I made a short video of the behavior I am observing. Please check it out below and let me know if I am missing something.

• http://screencast.com/t/VPtwlYY9sflH

Regards,
Viktor Tachev
Telerik by Progress

[E]

Hi Viktor,

Thank you very much for providing a sample solution for me to resolve the issue. The 'Column' option appeared on the filter menu and worked on the sample solution but it was still missing from my project.

In order to test the sample solution thoroughly, I created a new project solution in Visual Studio 2015, added a RADGRID control to the web page, re-entered your solution manually to this web page, and then run the project from Visual Studio. The ‘Column’ option appeared on the filter menu.

Next, I repeated the same processes on my current project solution but the ‘Column’ option was still missing from the filter menu.

Please note that the same Telerik.Web.UI.dll, Telerik.Web.Design.dll and Telerik.Web.UI.Skin.dll from the ‘ASP.NET AJAX Q1 2016’ release were added to both project solutions respectively.

During the investigation, I discovered that there were different UI license instances were added to the licenses.licx file among two project solutions.

There was ONE license instance found on the NEW project solution.
1) “Telerik.Web.UI.RadGrid, Telerik.Web.UI, Version=2016.1.113.45, Culture=neutral, PublicKeyToken=121fae78165ba3d4”.

There were TWO license instances in the following order sequence found on the CURRENT project solution.
1) "Telerik.Web.UI.RadGrid, Telerik.Web.UI, Version=2016.1.113.40, Culture=neutral, PublicKeyToken=121fae78165ba3d4" and
2) "Telerik.Web.UI.RadGrid, Telerik.Web.UI, Version=2016.1.113.45, Culture=neutral, PublicKeyToken=121fae78165ba3d4 

How does Telerik license file handle more than one license instances for the same UI on different versions in the licenses.licx file?  

Did two license instances for the same UI occur on the licenses.licx file was the real culprit of the issue?

I look forward to hear from you asap. Many thanks in advance.

Regards,
E

[E]

Hi,

Any comment. Thanks. 

E

[Viktor Tachev]

Hi,

The licences file should not affect the behavior of the controls. Nevertheless, if there is an error that points to the file you can delete the licences.licx file.

From your description it seems that there are references to the dll files targeting .NET 4 and .NET 4.5. Please ensure that the dll files you reference in your project correspond to the .NET version that project is targeting. The last digits of the assembly version indicate the .NET version it is targeting.

On a side note, please upgrade the components to the latest version and see how the behavior changes. The current release of the components is 2016.3.1027.

Regards,
Viktor Tachev
Telerik by Progress