Hi,
Can please anyone help me, as I am working on the telerik pivot grid and while binding I have a datafield named 'date', so I have assign that field in the PivotGridColumnField on telerik, but I want a PivotGridReportFilterField for date and it should be of month, day etc. But I am not able to set group interval to the PivotGridReportFilterField.
Can please anyone help me, as I am working on the telerik pivot grid and while binding I have a datafield named 'date', so I have assign that field in the PivotGridColumnField on telerik, but I want a PivotGridReportFilterField for date and it should be of month, day etc. But I am not able to set group interval to the PivotGridReportFilterField.
Please help me out how to assign the quarter, month etc. Do I have to calculate the data by month, quarter in the database?3 Answers, 1 is accepted
0
Brad
Top achievements
Rank 2
Rank 2
answered on 30 Nov 2012, 08:03 PM
What I have done is created another table MASTERDATE and then I have YEAR, QTR, MONTH, WEEKNUMBER, DAY. I also have the same for Fiscal_YEAR, Fiscal_QTR, Fiscal_MONTH, Fiscal_WEEKNUMBER. Then I have the date joined to this table by full date so I have access to all the other fields.
That is how I have done this.
That is how I have done this.
0
Hi Lindsay,
The approach Brad has provided is totally correct and should covers your requirements. Give it a try and let us know if further assiatance is needed.
All the best,
Maria Ilieva
the Telerik team
The approach Brad has provided is totally correct and should covers your requirements. Give it a try and let us know if further assiatance is needed.
All the best,
Maria Ilieva
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the RadControls for ASP.NET AJAX, subscribe to their blog feed now.
0
Lindsay
Top achievements
Rank 1
Rank 1
answered on 03 Dec 2012, 10:55 AM
Thank you. Maria Ilieva and Brad, Will try it and let you if we have any issues.