title: Top N in View or Crystal Reports?
body: <p>I am wondering if it's possible to use a view to get the top 5 lines from a table.
  I am finding that Crystal reports doesn't seem to have anything built in to do this, or I'd do it there.</p>
  
  <p>When I query the view <code>Select * from qryTranHistory</code>, it returns the first 5 items, but if I try to select a specific type <code>Select * from qryTranHistory Where tID = 45</code> it returns nothing, since there are no tID=45 in the top 5 normally. </p>
  
  <p>Is it possible to do this?<br>
  Can it be accomplished in a sub report in Crystal Reports?</p>