When setting datasource if the data is a dynamic type it wont render anything.

My type is IEnumerable<dynamic>

Cheers

PivotGrid: setting cell.CssClass to some class does not work for total cells but it does for data cells.

We are able to bind the data from OLAP cube by using ADOMD data provider and XMLA data provider. How do we access multiple cubes from RadPivotGrid?

Hi Team,

Using Persisting Pivot Settings : Filter Settings is being saved in filter window after clicking cancel button
(Ex : http://demos.telerik.com/aspnet-ajax/pivotgrid/examples/applicationscenarios/persisting-radpivotgrid-settings/defaultcs.aspx?product=persistenceframework)

1. Click on any filter icon in Pivot Grid (CategoryName filter icon)
2. Deselect first item from the list in pop up window (like Beverages)
3. Click Cancel
4. Filter is not applied on Pivot Grid which is perfect
5. Click on same filter icon (CategoryName filter icon) 
6. Observe that it is still showing first item as not selected (though the filter was cancelled and is not present on grid as well)

Expected : When we click cancel on Filter Window, the changes done should be removed.

One of my PivotGridColumnField's is a smalldatetime field from SQL Server.

In the PivotGrid column header labels I want the dates to be formatted as MMM-yy,  like Aug-15.

I can accomplish that for the detail columns (the non-aggregate columns) by setting the DataFormatString="{0:MMM-yy}"

But that format string is NOT applied to the label of the column total header.  The aggregate column header label still reads:  "08/01/2015 00:00:00 Total"

If you allow a custom format to the detail column headers, it would be logical to assume I want that same custom format used in the aggregate column header.  So in my example, that label should display:   Aug-15 Total

I was told in the Forum that I'd have to parse that column header string in the  CellDataBound Event to get the date portion and then format it and use that to set the header text.  That is a very UGLY solution.

I don't want to strip the word "Total" out of that string and then then convert the date that remains to a string in the date format I want. 

Thanks,
Brent

Currently, you have ColumnGroupsDefaultExpanded and RowGroupsDefaultExpanded available for the PivotGrid.

I would like to request an ExpandedGroupsBehavior that allows you to set a particular level to expand to.

To better explain this, the WPF PivotGrid has this. Here is a the documentation: http://docs.telerik.com/devtools/wpf/controls/radpivotgrid/features/expand-behavior.html

Thank you

Add possibility to translate PivotGrid Total and Grand Total labels via RadPivotGrid.Main.resx file.

When adding a calculated column to give you something like the Avg Price. The column appears across the whole pivot grid. So say you have your totalprice and qty showing for different stores. So the grid groups by stores. When you add the grandtotal calculation you get a new column added to each store.

I don't want the avg price added to each store .. I only want to see the average price in the grand totals section to the right?

Thanks.

Can not open database created with the latest sql using 2008, same issue here.

Add Caption/Title as property for the RadPivotGrid so if there is any need of adding a title/caption when user exports a file as excel sheet, we don't have any need of custom code. This newly requested property for Title should do the trick. This will ease the title/caption feature, and that is what telerik is all about 'EASE'.