locked
Report/views on Account with No Activity in last 30 days RRS feed

  • Question

  • Hi,

    I have one query which is asked by one of my client. He wants to run a report or views to see that how many account is not acted upon since last 30 days.

    i.e require a report/views to see the list of Account with "NO ACTIVITY " in last 30 days.

    Thanks,

    DynCRM 


    • Edited by DynCRM Tuesday, July 23, 2013 10:57 AM
    Tuesday, July 23, 2013 10:43 AM

Answers

  • Hi,

    Try this

    Regards,

    Yusuf


    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer". Thanks and Regards, Mohammad Yusuf Ansari http://microxrm.blogspot.in

    This query could not help you. Create a left join query on the account and the activities in the SQL, then use it in a SSRS report. You could import the build rdl file to the CRM. For more information have a look at this link.


    My Weblog | My Website

    Tuesday, July 23, 2013 12:58 PM
    Moderator

All replies

  • Hi,

    Try this

    Regards,

    Yusuf


    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer". Thanks and Regards, Mohammad Yusuf Ansari http://microxrm.blogspot.in

    Tuesday, July 23, 2013 10:59 AM
  • You cannot acheive this from Advanced Find because CRM knows what exists and CRM doesnot know what does not exists. You need a ssrs report to meet your requirements.


    Regards Faisal

    Tuesday, July 23, 2013 12:14 PM
  • Hi,

    Try this

    Regards,

    Yusuf


    If you find this post helpful then please "Vote as Helpful" and "Mark As Answer". Thanks and Regards, Mohammad Yusuf Ansari http://microxrm.blogspot.in

    This query could not help you. Create a left join query on the account and the activities in the SQL, then use it in a SSRS report. You could import the build rdl file to the CRM. For more information have a look at this link.


    My Weblog | My Website

    Tuesday, July 23, 2013 12:58 PM
    Moderator