Sign in
Microsoft.com
 
Microsoft
 
 
 
Microsoft >
> 
> 
> 
How to bring last created activity in report?

Unanswered How to bring last created activity in report?

  • Friday, May 25, 2012 5:34 AM
     
     
    Sign In to Vote
    0

    Hi All,

    I am using online MS crm 2011. I have created a report for an opportunity entity which includes fields for Activity (related entity) . For each opportunity there will be more than 10 Activities. So the report shows one opportunity for more than 10 line along with their activity in report. I want only the last created activity in report which will display each opportunity in one line. How to do this, Any solution?

    Thanks

    Shankar.B

     

All Replies

  • Friday, May 25, 2012 6:45 AM
    Moderator
     
     
    Sign In to Vote
    0

    Hi Shankar,

    you should be able to fetch last activity using order by based on created date.

    Mahain : Check My Blog
    Follow me on Twitter
    Make sure to "Vote as Helpful" and "Mark As Answer",if you get answer of your question.

     
  • Friday, May 25, 2012 6:50 AM
     
     
    Sign In to Vote
    0

    Hi Mahender,

    Thanks for your reply.  can u pls tell which condition can i use for last created activity?