NthLargest Formula being used in the select expert

[mmm76]

Hi,
Does anyone know of I way I can use an Nthlargest formula in my select expert? I need the largest term date for a benefit based on a class but then I need to narrow down my report to those benefits after a certain term date.
Thanks in advance for any help.

 

[Madawc]

You can suppress sections or groups that include data that you need to check but not display.

Right-click on a section and choose Section Expert. Then choose the formula icon (x+2 and a pencil) for suppression. Enter a suitable formula.

If that isn't possible for your test, it could be done using subreports, though this is inefficient.

Madawc Williams (East Anglia, UK). Using Windows XP & Crystal 10

 

[lbass]

How about some more specifics? Are you grouping by class? By benefit? Please show some sample data and explain a little more about what you are trying to do.

-LB