Sign in
Microsoft.com
 
Microsoft
 
 
 

locked
Limit number of records returned in view and report RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Is it possible to limit the number of records returned in a view and report?  To be more specific, I am building an activity report and view in CRM 2013 and want to limit the report to a quick view of the LAST completed activity only by sales rep.  Cannot seem to find a way to accomplish that...  thanks!

    Monday, March 31, 2014 7:46 PM

All replies

  • Question
    Sign in to vote
    0
    Sign in to vote

    You need to edit the report and modify the query.
    If it is a SQL report you need to use a TOP clause, something like

    SELECT TOP 5 * FROM FilteredAccount

    if your report is FetchXml, you need to use the count property, for example:

    <fetch count="5" mapping="logical">
  <entity name="Account">
    <all-attributes />
  </entity>
</fetch>

    My blog: www.crmanswers.net - Rockstar 365 Profile

    Monday, March 31, 2014 9:11 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    ahhh ok so this cannot be accomplished through the wizard.  so can I take the report from the wizard, edit it with fetchXML then add it back to CRM?  thanks for your response!
    Monday, March 31, 2014 9:26 PM
  • Question
    Sign in to vote
    0
    Sign in to vote
    Yes, you are right, it is not possible by the wizard, you need to edit the report using BIDS (Business Intelligence Development Studio) and upload back to CRM.

    My blog: www.crmanswers.net - Rockstar 365 Profile

    Monday, March 31, 2014 9:33 PM