Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
expression with if and count condition in fetch xml ssrs reports RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

       Hi,

    I have created one option set field with values gold silver and bronze in CRM 2013, now i want to count the total number of gold,silver and bronze in my designing view of Fetch XML SSRS reports. Please help me for this?

    I tried by filter condition and one expression.but only one count value is coming rest for silver and bronze not coming.

    help me for this?

    Sunday, April 6, 2014 11:27 AM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Sarita,

    Here is sample of a fetchxml statement that will give you a count of category (group by). Replace the entity name and attribute name (optionset) to match your requirements.

    <fetch mapping="logical" aggregate="true" >
    <entity name="account" >
        <attribute name="new_categoryname" alias="catname" aggregate="count" />
        <attribute name="new_category" alias="cat" groupby="true" />
    </entity>
</fetch>

    Eric UNG [Senior Analyst Programmer :: Sydney, Australia]

    • Marked as answer by sarita shaw Sunday, April 13, 2014 4:23 AM
    • Unmarked as answer by sarita shaw Sunday, April 13, 2014 4:23 AM
    Sunday, April 6, 2014 1:18 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    thanks eric i will try this.

    sarita shaw dell international services

    Sunday, April 13, 2014 4:24 AM
  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Sarita,

    Please refer following example article for this..

    http://crmdm.blogspot.co.uk/2013/09/custom-fetchxml-based-report-in-crm.html

    Hope this helps..

    MayankP
    My Blog
    Follow Me on Twitter

    Sunday, April 13, 2014 1:59 PM
    Answerer