Hi
When I have a DateTime field in my dataset (from a SQL query thru OnNeedDataSource), I get some ranges automatically, see the left side in the attached screendump. But I cannot group it properly in the PivotGrid, it keeps grouping by each day no matter which range, I select as column or row field (year/quarter/month/week/day/hour/minute/second). See the right side in the screendump.
Another question: How can I select which range to be displayed/grouped by? E.g. disable hour, minute, and second?
Best regards,
Kasper
When I have a DateTime field in my dataset (from a SQL query thru OnNeedDataSource), I get some ranges automatically, see the left side in the attached screendump. But I cannot group it properly in the PivotGrid, it keeps grouping by each day no matter which range, I select as column or row field (year/quarter/month/week/day/hour/minute/second). See the right side in the screendump.
Another question: How can I select which range to be displayed/grouped by? E.g. disable hour, minute, and second?
Best regards,
Kasper
1 Answer, 1 is accepted
0
Hi Kasper,
Thank you for contacting us.
Using the sample attached in the following blog post, can you provide us the exact steps we need to follow in order to reproduce the behavior?
http://blogs.telerik.com/blogs/13-12-03/aspnet-pivot-table-made-easy
As for hiding some items in the Configuration Panel, you can try a similar approach to the suggested on in this post:
http://www.telerik.com/forums/hiding-and-sorting-fields-in-the-configurationpanel#smQq5jDqsEy9VMvDejQREg
Regards,
Eyup
Telerik
Thank you for contacting us.
Using the sample attached in the following blog post, can you provide us the exact steps we need to follow in order to reproduce the behavior?
http://blogs.telerik.com/blogs/13-12-03/aspnet-pivot-table-made-easy
As for hiding some items in the Configuration Panel, you can try a similar approach to the suggested on in this post:
http://www.telerik.com/forums/hiding-and-sorting-fields-in-the-configurationpanel#smQq5jDqsEy9VMvDejQREg
Regards,
Eyup
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.