This is a migrated thread and some comments may be shown as answers.

Report Filter

21 Answers 165 Views

PivotGrid

This is a migrated thread and some comments may be shown as answers.

21 Answers, 1 is accepted

answered on 23 Oct 2012, 06:04 AM

Hello Rieni De Rijke,

Thanks for choosing RadPivotGrid and reporting this issues.

The first mentioned problem with drag and drop was found by our team very soon after the release and we have fixed it, so it will be included in this weeks internal build. You'll be able to download it very soon under your account.

As you know RadPivotGrid is in its BETA release and some of the features are still in development. That's why the Report Filter is not working in the moment - we are currently implementing it and hopefully you'll be able to use it very soon.

We are sorry for the caused inconvenience.

Greetings,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

answered on 05 Feb 2013, 03:49 PM

RadPivotGrid-WPF-OLAP-ReportFilters.zip

Hello Davide,

We have just finished our Sorting and Filtering implementation for data from OLAP Cubes. This means that this feature is not included in this week's internal build and will be available in the next one. But we decided to send you the dlls and a simple project, so you will be able to test RadPivotGrid's filtering from now. We'll be very happy if you share your opinion about this feature. Please note that with the current implementation the dialog for report filter will give you the chance to check/uncheck only the first 1000 items from the cube. We have planned to add searchbox so in the future you will be able to filter all items, no matter how big is the data in your cube.

Please check the attached project and inform us if you have any problems or concerns.

Kind regards,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

answered on 06 Feb 2013, 01:47 PM

Hi Davide,

Thanks for reporting this problem - we have reproduced it and fixed it, so it will be included in our next internal build.
For your question - unfortunately we will not be able to finish this type of filters (directly on a row or column) for the official release, but we'll add them to our RadPivotGrid at the earliest possible time after the release - maybe in an internal build or for the ServicePack.

Thanks again for your help. I've updated your Telerik Points as a small sign of our appreciation for your efforts. Feel free to contact us if you have any problems, concerns or suggestions.

Greetings,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

answered on 16 Jan 2015, 10:20 AM

Hi Tiago,

I'm not sure if I understand correctly the exact requirements. If you need to show the data in both PivotGrids and afterwards by modifying the FieldList to update only the second one - you can implement tow analogical DataProviders (for the both PivotGrids) and to only bind the second one the FieldList. This way only the second PivotGrid will be updated.

If you need to show the underlying data as it is in the bound collection - you would need to use a GridView for example to show it as the PivotGrid can only display the aggregated and grouped values of the data (not the data itself).

Hope this helps.

Regards,
Kalin
Telerik

Check out the Telerik Platform - the only platform that combines a rich set of UI tools with powerful cloud services to develop web, hybrid and native mobile apps.

answered on 16 Jan 2015, 11:27 AM

I would like to thank the great help given
For documentation purposes, Below is the code suitable for vb.net language, the solution worked perfectly

Private Sub radButton1_Click(sender As System.Object, e As System.EventArgs) Handles radButton1.Click<br> For Each item As IGroupDescription In pivotGrid.RowGroupDescriptions<br> Dim desc As IGroupDescription = item.Clone()

'as IGroupDescription<br>            PivotGrid1.RowGroupDescriptions.Add(desc)<br>        Next<br><br>        For Each item As IGroupDescription In pivotGrid.ColumnGroupDescriptions<br>            Dim desc As IGroupDescription = item.Clone()<br>            PivotGrid1.ColumnGroupDescriptions.Add(desc)<br>        Next<br><br>        For Each item As IAggregateDescription In pivotGrid.AggregateDescriptions<br>            Dim desc As IAggregateDescription = item.Clone()<br>            PivotGrid1.AggregateDescriptions.Add(desc)<br>        Next<br><br>        Dim newDataSet As New DataTable()<br>        newDataSet = (pivotGrid.DataSource).Copy()<br>        PivotGrid1.DataSource = newDataSet<br>        PivotGrid1.DataMember = pivotGrid.DataMember<br><br>    End Sub

answered on 16 Jan 2015, 11:37 AM

The code in vb.net below

Private Sub radButton1_Click(sender As System.Object, e As System.EventArgs) Handles radButton1.Click

For Each item As IGroupDescription In pivotGrid.RowGroupDescriptions

Dim desc As IGroupDescription = item.Clone() 'as IGroupDescription

PivotGrid1.RowGroupDescriptions.Add(desc)

Next

For Each item As IGroupDescription In pivotGrid.ColumnGroupDescriptions

Dim desc As IGroupDescription = item.Clone()

PivotGrid1.ColumnGroupDescriptions.Add(desc)

Next

For Each item As IAggregateDescription In pivotGrid.AggregateDescriptions

Dim desc As IAggregateDescription = item.Clone()

PivotGrid1.AggregateDescriptions.Add(desc)

Next

Dim newDataSet As New DataTable()

newDataSet = (pivotGrid.DataSource).Copy()

PivotGrid1.DataSource = newDataSet

PivotGrid1.DataMember = pivotGrid.DataMember

End Sub

Congratulations Telerik team!