<
telerik:RadGrid
ID
=
"RadGrid2"
runat
=
"server"
RenderMode
=
"Lightweight"
AllowSorting
=
"true"
>
<
ExportSettings
>
<
Excel
Format
=
"Biff"
/>
</
ExportSettings
>
<
ClientSettings
>
<
ClientEvents
OnCommand
=
"onCommand"
/>
</
ClientSettings
>
<
MasterTableView
AutoGenerateColumns
=
"True"
CommandItemDisplay
=
"Top"
>
<
CommandItemSettings
ShowExportToExcelButton
=
"true"
/>
</
MasterTableView
>
</
telerik:RadGrid
>
If the first column contains a list of Countries and you select for instance USA, the filter item in next column, which contains a list of Cities, should contains only cities from USA.
User friendly Grid filtering... I developed a custom feature where I display the filter expression used in a grid. This is very helpful so that users do not have to guess or remember what exactly they filtered on. And it provides a single click to clear all the filters at once. Before, all they saw was that certain columns are being filtered by, but they don't see what the filters actually are (EqualTo, Not EqualTo, StartsWith,,,etc) and they had to clear one filter at a time to get rid of all filtering. There is not much to it but it's subject to break if Telerik makes changes to the their filtering mechanism (which did happen). It would be nice if this feature can be standard so it will be part of Q.A after any changes to the Grid. Attached is a working sample page to see this in action. See comments in code.
Need the ability to Sort Grouped Items (ex. Salesperson) by the value of another Grouped Item (Sum of Sales). Currently, there is NO WAY to sort a list of Salespeople by Total Sales. You can only perform an alpha sort on Salesperson's Name. So, if you have a list of 100 Salespeople and their total product sales across dimensions like (product, geographic) you will have to MANUALLY look through and note who are your top Salespeople !!!!!!!!!!! How can this be acceptable ?? An alpha sort on Salesperson is the best you guys can do??
The GridCheckBoxColumn cannot handle null values in a bit field. I would like to be able to bind the checkboxcolumn to a bit field that allows nulls. The checkbox should be checked when the value is true, unchecked when it is false, and filled when it is null. The current solution is to use the RadButton inside a GridTemplateColumn and add custom togglestates, but this solution is not documented and it is very time intensive for something that should be quick and simple. It requires a lot of coding to update or insert a record.
In RadGrid, we can use the ClientSettings.Scrolling.UseStaticHeaders property to have a fixed header when scrolling the grid. This requires a fixed height of the grid. However, what if we do not want a fixed height of the grid, but rather want the grid to flow down the page, using as much space as necessary do display its records. In such a scenario, the grid header will disappear when we scroll down the page. I have implemented a kind of fix for this in one of my projects. Instead of trying to explain how it works, I have prepared an example. You can find it here: http://www.ifag.no/RadGridHeader.aspx Maybe some of you can suggest even better solutions to the scenario I have described. Comments are welcome!
I have a requirement where I need to right align the data in my RadGrid (a row of numbers) and I also need to right align the header and the filter controls. Currently there is no FilterStyle like there is HeaderStyle or ItemStyle. Yes, I can right align all of the filter columns, but I need to be able to pick-and-choose which columns get right aligned. When I opened a support ticket the following css was suggested, but that only right aligns the text in the text box, the the controls themselves in the <td>. .rgFilterRow td:nth-child(4), .rgFilterRow td:nth-child(7) { text-align: right; }
In case the RadGrid has several popup forms they are hidden behind the modal background.
As a user I would like to see on each grid the aggregate function totals for the actively displayed grid and on the last page the aggregate function totals for the active displayed grid and the data set aggregate function totals so that each page displays only its page level total and on the last page displays the full total of all data displayed. See attached examples: Example: Page level Total on every page and on the last page Page level Total plus Grid whole Total on the last page.
The behavior described in the following KB should be fixed https://www.telerik.com/support/kb/aspnet-ajax/grid/details/horizontal-scroll-speed-is-slow-with-static-headers In the meantime, you can use the workarounds from the article, or, if it fits your scenario, move to scrolling horizontally through frozen columns via the Prev/Next buttons the grid can provide. You can find an example of that in the second grid (Navigate through the columns by clicking on the Prev/Next buttons) in the following demo: https://demos.telerik.com/aspnet-ajax/grid/examples/columns-rows/columns/frozen-columns/defaultcs.aspx
Please add a setting for the Grid in batch edit mode to enable prompting to save changes. The prompt should occur when navigating away from the page, when paging, when filtering, when refreshing, or any other action that would cause loss of changes without a save. For details on how I implemented this manually, please see ticket 933229.
Please add support for tags in exported PDF documents. We need these tags for accessibility purposes. Currently, when we export a PDF from a RadGrid, it is created without any tag structure, which can make it difficult for a screen reader to process correctly.
This feature request is regarding the ExportToExcel button in Radgrid. ExportToExcel button in Radgrid adds an extra row in the exported excel sheet. This is due to the presence of Filtering items. Export to Excel code in radgrid: <ExportSettings ExportOnlyData="true" IgnorePaging="true" Excel-Format="Biff" OpenInNewWindow="True"> <Excel Format="Biff" AutoFitImages="True"></Excel> </ExportSettings> <CommandItemSettings ShowAddNewRecordButton="False" ShowRefreshButton="False" ShowExportToExcelButton="True" ExportToExcelText="Export Grid To Excel"/> The above code produces an extra row. I know there is a fix by disabling the Filtering items in the grid in OnItemCommand event. So I used that. The code is given below: protected void RadGrid1_ItemCommand(object sender, GridCommandEventArgs e) { if (e.CommandName == RadGrid.ExportToExcelCommandName) { ReviewByCollegeGrid.AllowFilteringByColumn = false; ReviewByCollegeGrid.Rebind(); ReviewByCollegeGrid.ExportSettings.Excel.Format = GridExcelExportFormat.Biff; ReviewByCollegeGrid.ExportSettings.IgnorePaging = true; ReviewByCollegeGrid.ExportSettings.ExportOnlyData = true; ReviewByCollegeGrid.ExportSettings.OpenInNewWindow = true; } } But it is a lot of work when you have to do it for all the web pages in your application. Please provide a feature which will help to solve this issue in an easier way.
How is it possible to autofit / autosize a giving column (or all columns) when exporting the contents from RadGrid to xlsx using ExportStructure? The only option available is Width with a defined value. I was unable to find an autofit / autosize function. And also add AutoFilter feature... Please consider to add this features :-)
Create a FilterControlEmptyMessage property so users can set an empty message in the grid filter textbox, much like the EmptyMessag property of RadTextBoxes. Ideally make it so this property can be accessed/modified client and server-side.
Forum threads on this topic: