Top N Percentage

[twilliamson2]

I am using Crystal Reports X and an Oracle DB.

I have approximately 6000 employee records with salaries. I would like to extract 10% of the 6000 employees with the highest salaries.

The result should be 600 employees extracted with the highest salaries.

Please help!

 

[lbass]

You might be able to use a command like this:

Select top 600 table.`salary`, table.`employee`
from table
Order by table.`salary` desc

This isn't a percentage though. Not sure how to do that in a command, but you could instead allow all records into the report, sort by salary descending, and create a running total {#cntall} like this: count of {table.employee}, evaluate for each record, reset never. Then go to the section expert->details->suppress and enter:

{#cntall} > distinctcount({table.employee})/10

-LB