+ 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