Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Sum values on report RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello all,

    I have a dropdown box with six different values in on my contact form.  I want to run a simple report on this field to tell me how many of each I have on the database, how can I do this?

    Thanks!

    Monday, April 14, 2014 2:01 PM

Answers

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi RoarCRM,

    For your purpose attainment you have to make FetchXMl parametric report from where you'll pass a parameter in the report same of your dropdown field with same number of values. and then make an aggregate on the passing parameter.

    You are referred to this blog post for understanding the basic of FetchXMl.

    __________________________________________________________________________________________________

    Mark as answer if this post is helpful for you.


    Monday, April 14, 2014 2:15 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    You can use the OOB CRM Report wizard to give you the count of records by the option set value.When creating the report select the option set (dropdown) field as the Group column and summary type as count.

    Here is a sample where I chose Gender (Option set) as Group field with Summary type : Count

    If my response helps you in finding your answer then please click 'Mark as Answer' and 'Vote as Helpful'

    • Proposed as answer by Mamatha Swamy Monday, April 14, 2014 3:10 PM
    • Marked as answer by RoarCRM Monday, June 30, 2014 12:58 PM
    Monday, April 14, 2014 3:10 PM
  • Question
    Sign in to vote
    0
    Sign in to vote

    you could also create chart or standard CRM report created using reporting wizard for this....

    http://dynamicsuniversity.com/blog/report-wizard-microsoft-dynamics-crm-2011

    https://www.youtube.com/watch?v=Iz_lARcO-VA

    MayankP
    My Blog
    Follow Me on Twitter

    • Marked as answer by RoarCRM Monday, June 30, 2014 12:58 PM
    Tuesday, April 15, 2014 7:36 PM
    Answerer