Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Filtered accounts with no phone calls RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hello

    I know how to make custom view but I dont know how to set up filter criteria to view only accounts that have no phone calls assigned.

    can anyone help me?

    thanks
    Peter
    Thursday, July 16, 2009 8:42 AM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi Peter,

     I do not think you can do this using advanced find.  I believe you will need to write a report to extract this information.


    Hassan.

    Hassan Hussain | http://hassanhussain.wordpress.com/
    Thursday, July 16, 2009 8:57 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    That is not good.

    I saw there view that says "Accounts: no orders in last 6 month" so I hoped it will be no problem to do the same thing for phone calls.
    How can I write report that can do that. Do I need to use VS?

    thanks
    Thursday, July 16, 2009 9:11 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    The "Accounts: No Orders in Last 6 Months" is a system view and you cannot view the filter or change it.

    You'll need the SQL Server BI Studio.The SQL Server Business Intelligence Studio comes with the MS SQL Server license. In all probability it would already be installed on the server where you have SQL Server installed. 

    The Buss. Intelligence development studio does look exactly like Visual studio but only with only BI (Business Intelligence) project types.

    It does not matter where you install the development studio as long as you can access to the SQL server.

    To install the Business Intelligence studio on your machine you will need to run the setup program again to reinstall the Business 
    Intelligence studio. You can launch the setup program in the "Tools" folder in the MS SQL server setup CD media.

    You can read more about writting reports at:
    http://technet.microsoft.com/en-us/library/bb955081.aspx

    Hope this helps.

    Hassan.


    Hassan Hussain | http://hassanhussain.wordpress.com/
    • Proposed as answer by Hassan Hussain Thursday, July 16, 2009 9:27 AM
    Thursday, July 16, 2009 9:27 AM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Hi Peter,

    have a look at this articel:
     

    http://dmcrm.blogspot.com/2008/02/creating-saved-views-that-advanced-find.html

    Viele Grüße

    Michael Sulz
    axcentro GmbH
    MVP für Microsoft Dynamics CRM
    Thursday, July 16, 2009 9:42 AM
  • Question
    Sign in to vote
    1
    Sign in to vote
    Hello Peter,

    You can create a marketing list based upon all accounts that HAVE a phone number, and then create a marketing list of accounts that do not occur in the first marketing list
    Thursday, July 16, 2009 10:08 AM