Top 20 Rows

Last Post 25 May 2007 06:22 AM by ChabotWVU. 1 Replies.
AddThis - Bookmarking and Sharing Button Printer Friendly
  •  
  •  
  •  
  •  
  •  
Sort:
PrevPrev NextNext
You are not authorized to post a reply.
Author Messages
brownrj
New Member
New Member

--
23 May 2007 04:09 AM
I have a report that lists people names. with those names i have multiple record numbers and comments along with the numbers and a colum with a date in it. BUT I only need the top 20 records for each person based on the date in DESC order.
I have the drilldown created with the records showing BUT iu need to just have the top 20 show. With the amount of records i can not use SQL based query because then it times out.
ChabotWVU
New Member
New Member

--
25 May 2007 06:22 AM


-Go to the properties of the control you are displaying the details (table or list box)

-First set your sort, go to the sort table and pick the date field in the expression and set descending for the direction

-Second set you filter, go to the filter tab and for the expression select your first detail field (can be any but lets just use the first), for the operator select TOP N and for the value enter = 20
You are not authorized to post a reply.

Acceptable Use Policy