Good ..There is always a solution to everything, sometimes hidden behind deep 
clouds, sometimes just around the corner ...but never say, not impossible ...// 
L ars

-----Original Message-----
From: Action Request System discussion list(ARSList)
[mailto:[EMAIL PROTECTED] Behalf Of Sueli Kanegae
Sent: Monday, September 04, 2006 10:43 PM
To: arslist@ARSLIST.ORG
Subject: Re: Diary Field last entry


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

_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at http://www.wwrug.org

Reply via email to