how to add a condition (Row(99)) to my Report ( I've seen that previously) - Answers - Salesforce Trailblazer Community
Trailblazer Community
Ask Search:
Christelle TOLEDEChristelle TOLEDE 

how to add a condition (Row(99)) to my Report ( I've seen that previously)

I would like to limite my results on my report to 99 ( or somethine else).
My language is in french.

 

Any tip on how to do it ?
 

Javier GonzalezJavier Gonzalez
Click on the Add  dropdown in the report filter.

User-added image
Christelle TOLEDEChristelle TOLEDE
Pb ist that I don't have this choice on my screen...User-added image

Javier GonzalezJavier Gonzalez
It has to be a tabular report. Change the report format.
Steve MolisSteve Molis
@Christelle, from your screenshot I can see that you are using a Summary Report, the Limit Report Rows feature is only available on Tabular Format reports (as indicated by Javy's screenshot).  

Limiting Report Results

Available in: All Editions except Database.com

User Permissions Needed
To create, edit, and delete reports:“Create and Customize Reports”
To create, edit, and delete reports using the report builder interface:“Report Builder” (unless you've enabled the upgrade)

You can limit your report results in the following ways:

  • To see a collapsed view of a report showing only the headings, subtotals, and total in report builder, deselect Show | Details.

    On the report run page, click Hide Details or Show Details at the top of the report.

  • To eliminate unwanted records, add custom filters.
  • In Professional, Enterprise, Unlimited, and Developer Edition organizations, the Hierarchy links let you browse report results based on the role or territory hierarchies. See Reporting on Your Team.
  • If your organization uses divisions to segment data and you have the “Affected by Divisions” permission, use the Division drop-down list to include records in just one division or all divisions. Select --Current-- to show records in your current working division. Reports that are already scoped (such as My Cases or My team’s accounts) include records in all divisions, and you can't further limit them to a specific division. If you do not have the “Affected by Divisions” permission, your reports include records in all divisions.
  • You can set the maximum number of records to display in a tabular report by clicking Add | Row Limit in report builder. Set the number of rows, then choose a field to sort by, and the sort order. Limiting rows on a tabular report allows you to use it as a source report for dashboard table and chart components.

    The Row Limit option on tabular reports only shows fields from the primary object on reports created from custom report types where object A may or may not have object B. For example, in an accounts with or without contacts report, only fields from accounts are shown. Fields from objects after a may-or-may-not association on custom report types aren't shown. For example, in an accounts with contacts with or without cases report, only fields from accounts and contacts are available to use.

    Note
    If you change the report format, Row Limit settings are lost.

Limiting Account Reports

The standard View filter for account reports allows you to limit your account data according to the following options. These options vary depending on your organization's Edition and setup.

  • My accounts—Shows accounts that you own.
  • My account team accounts—Shows accounts where you are on the account team.
  • My account team and my accounts—Shows accounts you own and those where you are on the account team.
  • My team's accounts—Shows your accounts and accounts owned by all of your subordinates in the role hierarchy.
  • My territories—For organizations that use territory management, this option shows accounts that belong to the territories to which you are assigned.
  • My territory team's accounts—For organizations that use territory management, this option shows accounts that belong to your territories and your territories' descendants.
  • My team's account team and their own accounts—For users who report to you in the role hierarchy, shows accounts they own or for which they are on the account team.
  • All visible accounts—Shows all accounts that you can view, as determined by your sharing model.
  • Territories—For organizations that use territory management, the additional Territories filter can be set to All, Multiple Territories, or Missing Territory. However, the Territories filter on report results run from custom report types that include territories does not include Multiple Territories or Missing Territories.
  • If your organization uses a Salesforce Customer Portal, add the Customer Portal Account field to your account reports to view which accounts have contacts enabled to use the portal.
  • When a report returns a list of contacts or person accounts, you can click Add to Campaign to associate those individuals with an existing campaign. The button only displays if you have the required permissions to manage campaign members. For more information, see Adding Campaign Members from Reports.

Limiting Activity Reports

The standard filters for activity reports allow you to limit your report results using the following options. Some of these options will not be visible depending on your Edition. Use these options to limit your report results to avoid processing too many records.

  • My Activities—Shows activities that you own.
  • My Delegated Activities—Shows activities that you created but are owned by someone else in the same role as you, and below your role, in the role hierarchy.
  • My Team's Activities—Shows activities owned by users who report to you in the role hierarchy.
  • All Activities—Shows all activities that you can view, as determined by your sharing model.

Limiting Opportunity Reports

If your organization uses territory management, the Hierarchy filter on opportunity reports lets you view data according to either the role or territory hierarchies. In addition, the Territories filter lets you display either opportunities from all territories or opportunities that lack an associated territory.

Use the View filter to limit your opportunity report results. View options vary depending on your organization's Edition and setup.

  • My opportunities—Shows only your opportunities.
  • My team-selling opportunities—Shows opportunities for which you are on the sales team.
  • My team-selling and my opportunities—Shows your opportunities and opportunities for which you are on the sales team.
  • My team's opportunities—Shows your opportunities and opportunities owned by all of your subordinates in the role hierarchy.

    If your organization uses territory management, the effect of this option depends on the value of the Hierarchy filter above. If you select Role, you see your opportunities and opportunities owned by all of your subordinates in the role hierarchy. If you select Territory, you see opportunities that you own and any opportunities owned by your territories' descendants.

  • My team's team-selling and their opportunities—For users who report to you in the role hierarchy, shows opportunities they own or for which they are on the sales team.
  • My territories—For organizations that use territory management, this option shows opportunities that belong to the territories to which you are assigned.
  • All opportunities—Shows all opportunities you can view.
Territory Management Overview 
Christelle TOLEDEChristelle TOLEDE
Yessss !
Thanks a lot