Add date as column field in the pivot grid but it should have filters of month, day, year and quarter.

4 posts, 0 answers
  1. Lindsay
    Lindsay avatar
    5 posts
    Member since:
    May 2012

    Posted 28 Nov 2012 Link to this post


    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?
  2. Brad
    Brad avatar
    8 posts
    Member since:
    Oct 2011

    Posted 30 Nov 2012 Link to this post

    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.
  3. Maria Ilieva
    Maria Ilieva avatar
    4017 posts

    Posted 03 Dec 2012 Link to this post

    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
    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.
  4. Lindsay
    Lindsay avatar
    5 posts
    Member since:
    May 2012

    Posted 03 Dec 2012 Link to this post

    Thank you. Maria Ilieva and Brad, Will try it and let you if we have any issues.
Back to Top