If you can't modify the SQL that this report is based on (I don't think that Crystal allows you to add a Top 50 to the SQL directly in the report, so you'd have to base this on a View or SP), you can add in a suppression formula for each band being displayed as follows:
recordnumber > 50
The problem is the report will still receive all records, degrading performance.
Hello, let me clarify the purpose of this report ....
it is to pull in the top 25 salesman then the middle 25 salesman then only one time salesman. for each there should be only 25 records and in the format ...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.