Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
Fetch XML Report

Unanswered Fetch XML Report

  • Wednesday, May 02, 2012 6:03 PM
     
     
    Sign In to Vote
    0

    I have a requirement where i need to develop a report for crm 2011 online

    I have 2 attributes "This Year" and "Last Year" 

    I have to show the Top 50 values of the difference value i,e This Year -  Last Year Value

    How can i do this? Any Work Round for this

    Thanks

    Varun Kumar

     

All Replies

  • Thursday, May 03, 2012 6:30 AM
    Moderator
     
     
    Sign In to Vote
    0

    I'm not sure if you can do this with reporting in Crm Online. FetchXml will not support doing the calculation ('This Year' - 'Last Year'); you might be able to use a field that is calculated within the report, however Crm Online restricts the functions that can be used in reports, so this may or may not work.

    If a calculated field in the report doesn't work, then I think you'll need a different approach. A couple of options are:

    1. Write a plugin that calculates ['This Year' - 'Last Year'] and places the result in a new field. You could then report on this field
    2. Have the users export the data to Excel, and do the calculation and filtering within Excel

    Microsoft CRM MVP - http://mscrmuk.blogspot.com  http://www.excitation.co.uk