Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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

  • Question
    Sign in to vote
    1
    Sign in to vote

    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

  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    0
    Sign in to vote

    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
  • Question
    Sign in to vote
    1
    Sign in to vote

    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