Last Updated: 28 Jun 2019 04:27 by ADMIN
Created on: 23 May 2018 14:09
Category: PivotGrid
Type: Feature Request
PivotGrid Filter Includes/Excludes "Getter"
Hi I have a straightforward feature request: I would like to be able to "get" the row/column "filter" values the user has selected server-side. Basically need a public property or some type of getter. Currently on the PivotGrid, the row/column "Filter" "Includes/Excludes" can be "set" programmatically, but user selected values can't be easily gotten.

I would use it in a couple ways: 

1) to display context to the user for the numbers in the grid. (e.g., show the user the active filter values responsible for the numbers they are seeing in the PivotGrid Detail). 

2) I need the filter values to close Ticket 1168787.

A Telerik employee make a nice sample project to do drill-through functionality:

But the PivotGrid counts and RadGrid detail data records returned are not in agreement because selected PivotGrid filters aren't applied to the detail returned in the RadGrid. I need to do that. I need to be able to mimic a drill through action into the detail records that make up the data counts. If I click a cell that says "100" (orders, 2018 year included) I need 100 orders returned in the detail. Not 7000 orders (all order years, unfiltered).

In that ticket, I'm trying to mimic the functionality similar to an SSAS "drillthrough action" (like many cube browsers have built in, e.g., RANET OLAP), except here with a regular SQL data source. This way I can drill into the detail records that make up the numbers displayed to the user in the PivotGrid. However, as it stands, the counts and detail will not be congruent until I can get the filter values selected by the user and apply them accordingly to the data set for the detail RadGrid. The BI users expect to be able to drill into the data and I need to provide it.

Thank you,


Posted on: 28 Jun 2019 04:26
Hello Tom,

This was already resolved some time ago in the official support ticket.

But now also a resource KB with the solution was created so other developers may use it if they stumble upon this requirement:

Progress Telerik
Get quickly onboarded and successful with your Telerik and/or Kendo UI products with the Virtual Classroom free technical training, available to all active customers. Learn More.
Posted on: 20 Jun 2018 18:08
What are the odds of really getting this added? I think it is really important that the programmer should be able to get at the user selections in the report filters. I'm really hampered.
Posted on: 24 May 2018 20:35
Basically, the programmer should have the ability to get at the user's choices made in any of the FilterWindows for the instance. Therefore, this request would also apply to the hidden "Report Filter" field FilterWindows, since they're essentially the same FilterWindow.