Asked by:
Capturing days difference between last activity date and current date for an account

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
-
-
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