function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
OssieOssie 

Limit number of records on Report

Hello,

Is it possible to create a report, which only shows 5 or more Open Cases for a Customer?  Not sure how to apply this criteria of 5 or more. 

Any help would be greatly appreciated.
 
Balaji BondarBalaji Bondar

Hi Ossie,
We can limit the number of rows.Below link may help you:
http://www.crmsalesforcetraining.com/filtering-report-data-limit-add-rows/

Important :
If this is what you were looking for then please mark it as a "SOLUTION" or You can Click on the "Like" Button if this was beneficial for you.
OssieOssie
Hi Balaji,

Thank you for the prompt response. But maybe i wasn't very clear in my post.  I want to see which customers have 5 or more open Cases. Whereas the solution you have provided limits the records i can see and so doesn’t necessary show me 5 or more open Cases for a customer.  Is this correct?
 
Balaji BondarBalaji Bondar
Hi Ossie,

I am not sure about report but you can quey like : 
SELECT Owner.Name, COUNT(Status) FROM case where Status='Open' GROUP By Owner.Name  having COUNT(Status)>=5
Note: Update query for customer field