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

  • Question

  • 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

  • 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
  • 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
  • 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