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

Change DateTimeGroupDescription Step by ui

3 Answers 65 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Mauro
Top achievements
Rank 1
Mauro asked on 28 Dec 2012, 03:35 PM
Is this possible?
If not, will it be possible on first release?
Any suggestion or example on dynamic drill-down?

Best reguards
Mauro

3 Answers, 1 is accepted

Sort by
0
Rosen Vladimirov
Telerik team
answered on 30 Dec 2012, 10:40 PM
Hi Mauro,

With the current release it is not possible to change the step of DateTimeGroupDescription at runtime. We have included this feature in our to-do list and we'll try to include it for the official release, but there are a lot of features that we are working on.

Can you give us more details on the way you want to use drill down dynamically - we are currently considering all suggestions for this feature and we'll be very happy if you can send us feedback what would you expect.

Thanks for choosing RadPivotGrid. Do not hesitate to contact us if you have any suggestions or concerns.

All the best,
Rosen Vladimirov
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

0
Mauro
Top achievements
Rank 1
answered on 31 Dec 2012, 09:48 AM
Something like the Demo - Olap Support (the row group of dates), but made with LocalDataSource.
I achieve to do it in code with something like this:

PropertyGroupDescriptionBase pg = localData.RowGroupDescriptions.FirstOrDefault(c => c.PropertyName == "DateTimeField");
if (pg != null) {
  DateTimeGroupDescription dtgd = pg as DateTimeGroupDescription;
  if (dtgd != null) {
    DateTimeStep dts;
    if (Enum.TryParse<DateTimeStep>((string)comboboxStep.SelectedValue, out dts)) {
      dtgd.Step = dts;
      localData.Refresh();
    }
  }
}

It would be nice to be possible to:
  • make this operation by PivoltFieldList UI
  • Select a step by Week or some other system to be more granulary
  • Customize the routine by which group the data
Let me know what you think about code snippet (or if it is not clear)

Mauro
0
Pana
Telerik team
answered on 02 Jan 2013, 11:37 AM
Hello,

We have plans to implement the step selection in the RadPivotFieldList UI in future. However we are not yet sure of a timeframe since we have other more important tasks scheduled for the near future.

The grouping routine can be currently changed by implementing a custom PropertyGroupDescriptionBase and more importantly its GroupNameForItem method. Basically you will be getting DateTimes there and can convert them to custom Week objects returned in that method (class with int Week property, implementing GetHashCode, Equals, ToString). However please note we are still in beta and there may be some changes introduced in the API for the official release. We have an example you could use for quick reference for custom grouping available in the Silverlight QSF, the WPF API is the same and the example is available for WPF in the same location in the WPF QSF.

Also we are currently working on notification system in the pivot that would make the change of the Step to invalidate and eventually refresh the pivot automatically.

Kind regards,
Pana
the Telerik team

Explore the entire Telerik portfolio by downloading Telerik DevCraft Ultimate.

Tags
PivotGrid
Asked by
Mauro
Top achievements
Rank 1
Answers by
Rosen Vladimirov
Telerik team
Mauro
Top achievements
Rank 1
Pana
Telerik team
Share this question
or