BO Report question

[JeanneZ]

I will create a BO report to list Top 100 paid employees. I used Free-hand SQL ranking all the employees because I need the show total paid for top 100 and top paid for all others.
On the report, I only need show top 100. How can set the filter? Thanks a lot for any help.
Jeanne

 

[blom0344]

If you use a real ranking function in your free-hand SQL than it is a simple matter of applying a complex filter on that object. (like <rankobject> <= 100)

Ties Blom

 

[JeanneZ]

Thanks a lot for your help.