Try to perform a set fields, CURRENT TRANSACTION, set a tmp field to $Diary$, works for me .../L ars
-----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Sueli Kanegae Sent: Monday, September 04, 2006 9:57 PM To: arslist@ARSLIST.ORG Subject: Re: Diary Field last entry Hi List, I need to know the last entry in a Diary field and was taking a look at old exchanged messages. I´ve found a solution below but couldn´t do the Set Field: "Most Recent Action" 'TR.Work Diary' I also tried '$TR.Work diary$', but it doesn´t work. Any other idea to save just the last entry (diary field)in a character field? (I don´t need odbc drivers or crystal as Carina does) Thanks in advance! Sueli On Tue, 15 Jun 2004 14:26:16 -0400, Tilton, Claire E. Ms. NGB-ARNG <[EMAIL PROTECTED]> wrote: >Make a field called "Most Recent Action" (Field Size = 0 or whatever you >feel is appropriate to catch the last diary entry). Create a filter that >fires on > 'TR.Work Diary' != $NULL$. > >Do a set fields "Most Recent Action" := 'TR.Work Diary'. Then you can >report on that field instead of the work diary. > >Thanks, >Claire >-----Original Message----- >From: Carina Burns [mailto:[EMAIL PROTECTED] >Sent: Tuesday, June 15, 2004 1:32 PM >To: ARSLIST@ARSLIST.ORG >Subject: Diary Field Question > >Listers, >With the user preference form, you can set the diary field to display the >most recent entry first. While this works through the forms (whether web >or client,) it doesn't work when using the odbc drivers and crystal >reports -despite using an id with the diary preference set. The first >entry is displayed rather than the last entry. Has anyone out there found >a way to retrieve only the last entry or to specify the display order of >the diary entries within a crystal report? > >Much Appreciated, > >Carina Burns >Database Admin >Richardson ISD >[EMAIL PROTECTED] > _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org
