Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: datahead2009
- Order by date
-
Wanted three latest (dates) for memo field
lbass, Thanks for the info. I figured out the same thing as your first choice ! Way to go. Thanks for your help. The only thing I did different was pass a parameter (userID) to the SQL command, utilizing the Top N method. !- datahead2009
- Post #5
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Wanted three latest (dates) for memo field
Yes, the three latest memo fields for that specific individual( by Memo Date ). Report is run for each individual. By the way I tried ranking in SQL. The SQL ranks for all people, not just one. I tried crystal reports summary, does not work for memo fields.- datahead2009
- Post #3
- Forum: Business Objects: Crystal Reports 4 Other topics
-
Wanted three latest (dates) for memo field
I just need a way to display the "top three records" of a table that contains a date, user id, and memo field. I want these records by user. Output: User, Date, Memo field.- datahead2009
- Thread
- Replies: 4
- Forum: Business Objects: Crystal Reports 4 Other topics
