It worked, thank you! On Mon, 4 Sep 2006 22:07:13 +0200, [EMAIL PROTECTED] wrote:
>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 >======================================================================== _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org