Completed
Last Updated: 28 Jun 2019 04:27 by ADMIN
Created by: Tom
Comments: 3
Category: PivotGrid
Type: Feature Request
0
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: https://www.telerik.com/blogs/how-to-implement-drill-down-functionality-in-telerik-s-pivotgrid-for-asp.net-ajax-part-2

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,

Tom


Completed
Last Updated: 30 Sep 2016 12:48 by ADMIN
PivotGrid: setting cell.CssClass to some class does not work for total cells but it does for data cells.
Completed
Last Updated: 20 Sep 2016 06:29 by ADMIN
ADMIN
Created by: Maria Ilieva
Comments: 0
Category: PivotGrid
Type: Feature Request
2

			
Completed
Last Updated: 17 Jul 2015 11:53 by ADMIN
Completed
Last Updated: 20 Sep 2016 06:29 by Marcin
Created by: Marcin
Comments: 0
Category: PivotGrid
Type: Feature Request
2
Add possibility to translate PivotGrid Total and Grand Total labels via RadPivotGrid.Main.resx file.
Completed
Last Updated: 16 Jul 2015 07:54 by ADMIN
Completed
Last Updated: 20 Sep 2016 06:30 by ADMIN
ADMIN
Created by: Pavlina
Comments: 0
Category: PivotGrid
Type: Feature Request
0

			
Completed
Last Updated: 15 Jul 2015 12:21 by Debajyoti
ADMIN
Created by: Pavlina
Comments: 1
Category: PivotGrid
Type: Bug Report
1

			
Completed
Last Updated: 20 Jul 2015 14:14 by ADMIN
Completed
Last Updated: 20 Sep 2016 06:30 by ADMIN
Completed
Last Updated: 26 Jan 2015 12:36 by ADMIN
Completed
Last Updated: 09 Mar 2015 07:01 by Grant
Completed
Last Updated: 08 Sep 2014 14:11 by ADMIN
Completed
Last Updated: 16 Jul 2015 08:29 by ADMIN
Completed
Last Updated: 07 Jan 2015 12:41 by ADMIN
Created by: Kalyani
Comments: 1
Category: PivotGrid
Type: Feature Request
1
Can you please add other type of exports to the Ajax pivot grid.  The excel export is really good but it would be great to have a native pdf and csv export.  
Completed
Last Updated: 04 May 2015 11:25 by ADMIN
Completed
Last Updated: 20 Sep 2016 06:52 by ADMIN
ADMIN
Created by: Konstantin Dikov
Comments: 0
Category: PivotGrid
Type: Feature Request
3

			
1 2