top N

[Shin25]

Hi Iam creating a Crystal Report xi Rel2 which has a parameter where a user can select one of two options for
example : greater than 250 or less than 250.

I have a column 'Paid', which I have applied a Top N to. But I want to change the Top N to Bottom N depending on what parameter
value gets selected.

So if 'greater than 250' is selected then 'paid' appears as top n and if 'less than 250' gets selected then 'paid' changes
to bottom N.

Anyone any ideas?

Many Thanks

 

[lbass]

Create a formula:

if {?parm} = "greater than 250" then
{table.paid} else
-{table.paid}

Insert a sum on this at the group level, and then choose this as your group sort field, using topN descending. Leave your original summary on display, and suppress the above formula's summary.

-LB