locked
Capturing days difference between last activity date and current date for an account RRS feed

  • Question

  • Hi,

    Need to run a report/Views to capture the last activity date and the days difference between current date and last activity date for an account entity in CRM 2011.

    Thanks & Regards,

    DynCRM

    Tuesday, July 23, 2013 8:28 AM

All replies

    • Proposed as answer by Roshan Mehta Tuesday, July 23, 2013 10:30 AM
    Tuesday, July 23, 2013 10:30 AM
  • You can try using following code in you SSRS report:-

    =IIf(DATEDIFF("s",ReportItems!new_dateofverification.Value,GETDATE()) > 432000, "KPI NOT  MET","KPI MET")


    Regards Faisal

    Tuesday, July 23, 2013 10:41 AM
  • Thanks RoscoNZ for your quick response..Since I am a functional person, so is there any other way to achieve without help of SSRS.

    Thanks & Regards,

    DynCRM

    Tuesday, July 23, 2013 11:32 AM
  • Hi,

    Thanks form your reply. Can it be achieved without any code as I am a functional consultant.

    Thanks & Regards,

    DynCRM

    Tuesday, July 23, 2013 11:34 AM
  • You can create reports in report manager of CRM and it has some functionality of doing sum, average etc. You cannot add a calculated column into your report. Therefore you are left with one option which is ssrs report.

    Regards Faisal

    Tuesday, July 23, 2013 12:11 PM
  • You could try exporting the data into Excel and then create a formula to display the data you need.
    • Proposed as answer by Roshan Mehta Wednesday, July 24, 2013 10:11 AM
    Wednesday, July 24, 2013 10:11 AM