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

  • Question

  •    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

  • 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
  • thanks eric i will try this.

    sarita shaw dell international services

    Sunday, April 13, 2014 4:24 AM
  • 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