Limiting Records in Section Expert 1

[LMGroup]

I'm using CR 2008 and trying to limit the number of records I'm retrieving in a subreport to the 5 most recent revisions based on the revision number. I've entered the following the the Section Expert-Details-Common-Suppress (No Drill-Down) formula

numbervar RevLoop;
numbervar RevMax;

RevMax = Maximum ({Revisions.RevisionN});
RevLoop = RevMax-4;

{Revisions.RevisionN}<>RevLoop To RevMax

I'm a total rookie at this (obviously) so I'm sure I'm missing information that you may require.

Thanks for any help.
Lorraine

 

[lbass]

Assuming you have sorted in descending order by revision number and that there is one row per revision number, use a suppression formula like this:

recordnumber > 5

-LB

 

[LMGroup]

That was much easier than what I was trying to do. Now I'm only getting the last 5 instead of all or none. Is there a way to make it print in ascending order after doing that?

 

[LMGroup]

Never mind the previous post. I used your tip and sort of combined it with mine and got the last 5 records printing in ascending order.

Thanks so much!!