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

DateTimeGroupDescription step year missing

2 Answers 44 Views
PivotGrid
This is a migrated thread and some comments may be shown as answers.
Charles Benoualid
Top achievements
Rank 1
Charles Benoualid asked on 02 Jul 2013, 02:21 PM
Hi,
if i choose a step for DateTimeGroupDescription that is month, day etc. The year is not shown in the result.
It should show year has well.

2 Answers, 1 is accepted

Sort by
0
Charles Benoualid
Top achievements
Rank 1
answered on 02 Jul 2013, 05:43 PM
We would like to be able to group by year, quarter, month etc all together in one group description.

The result would be year subdivided in quarter subdivided in month etc... With options to see what I want. Lets say i want to see first level year and second level month, etc.

This is very important has our customer requirer this feature.
0
Rosen Vladimirov
Telerik team
answered on 03 Jul 2013, 05:59 AM
Hello,

With our latest release we have introduced entire new UI to set DateTime Step via RadPivotFieldList. You can find more information about the change in our Backwards Compatibility article.With these changes you are able to select different steps in the UI and use them simultaneously. In your case you can use code similar to:
<pivot:LocalDataSourceProvider.ColumnGroupDescriptions>
    <pivot:DateTimeGroupDescription PropertyName="Date" Step="Year" />
    <pivot:DateTimeGroupDescription PropertyName="Date" Step="Quarter"/>
    <pivot:DateTimeGroupDescription PropertyName="Date" Step="Month" />
</pivot:LocalDataSourceProvider.ColumnGroupDescriptions>

I also suggest you to take a look at our article describing how to use DateTimeGroupDescription. You can download a runnable project with modified FieldTree (read the article in order to find out how to modify RadPivotFieldList's FieldTree) from our SDK Examples.

Using three different steps simultaneously will lead to a result similar to the one you have sent in your last mail, but if you want to use only one group description, you will have to create custom group description. You can download a sample project how to implement it from our SDK Examples.

Hopefully this helps. Feel free to contact us if you have any other problems or concerns. 

Regards,
Rosen Vladimirov
Telerik
TRY TELERIK'S NEWEST PRODUCT - EQATEC APPLICATION ANALYTICS for SILVERLIGHT.
Learn what features your users use (or don't use) in your application. Know your audience. Target it better. Develop wisely.
Sign up for Free application insights >>
Tags
PivotGrid
Asked by
Charles Benoualid
Top achievements
Rank 1
Answers by
Charles Benoualid
Top achievements
Rank 1
Rosen Vladimirov
Telerik team
Share this question
or