attach another conversion routine and use FMT function of jbase to format it. eg., FMT(AMOUNT,"R%2") Regards, Mohan
On Fri, Jul 23, 2010 at 2:51 AM, JOSE L MARTINEZ-AVIAL <[email protected]>wrote: > You can setup a format string. > > 2010/7/22 Sridhar <[email protected]> > >> Hi, >> Thanks for your reply and its working fine now. But, is any routine >> required for displaying the field value in decimals. For eg, my output is >> fetched as 55000.000. I need it to be displyed as 55,000.00. How to achieve >> this?? >> >> >> Thanks and Regards, >> Sridhar >> >> On Thu, Jul 22, 2010 at 12:28 AM, JOSE L MARTINEZ-AVIAL <[email protected] >> > wrote: >> >>> You need to get create a field with the PD id, and then do a conversion >>> like this: >>> >>> L PD.PAYMENT.DUE,PAYMENT.AMOUNT >>> >>> Hope it helps >>> JL >>> >>> 2010/7/21 Sridhar <[email protected]> >>> >>> Hi, >>>> >>>> Can you tell how the conversion will exactly happen? I have the >>>> LD id as CONTRACT.ID and is available in the standard selection. >>>> So, I gave ( S CONTRACT.ID )in Operation field and gave PD O/S AMOUNT: >>>> in the FIELD.NAME field. >>>> Also, attached a conversion routine to pick up the Total outstanding >>>> amount field from the PD record. >>>> What actually happended, is that the outstanding amount value got >>>> displayed in the header and the label did not get displayed. >>>> >>>> How to get this done without conversion routine attached.?? I mean, how >>>> to achieve it through the setup? >>>> >>>> In conversion field what are the manipulations to be made for reading PD >>>> record by appending “PD” with LD id and then reading the PD record with the >>>> outstanding amount field? >>>> >>>> Thanks in advance, >>>> Sridhar >>>> >>>> On Tue, Jul 20, 2010 at 12:32 AM, Ram <[email protected]> wrote: >>>> >>>>> Hi, >>>>> Add a field in enquiry for header . use conversion routine to fetch >>>>> PD value and display as header using arrtibs --> header property >>>>> >>>>> Regards, >>>>> Ram >>>>> >>>>> On 19-Jul-2010, at 10:25 PM, Sridhar <[email protected]> wrote: >>>>> >>>>> Hello, >>>>> How to fetch value from another file in a File enquiry? For >>>>> eg, I need a header value to be obtained from PD record but >>>>> it is a file enquiry fetching values from LD record. >>>>> >>>>> Is there any conversion routine that is needed? If so, can anyone tell >>>>> me where it has to be attached to? >>>>> >>>>> >>>>> Thanks in advance, >>>>> Raadha >>>>> >>>>> -- >>>>> Please read the posting guidelines at: >>>>> <http://groups.google.com/group/jBASE/web/Posting%20Guidelines> >>>>> http://groups.google.com/group/jBASE/web/Posting%20Guidelines >>>>> >>>>> IMPORTANT: Type T24: at the start of the subject line for questions >>>>> specific to Globus/T24 >>>>> >>>>> To post, send email to <[email protected]>[email protected] >>>>> To unsubscribe, send email to <[email protected]> >>>>> [email protected] >>>>> For more options, visit this group at >>>>> <http://groups.google.com/group/jBASE?hl=en> >>>>> http://groups.google.com/group/jBASE?hl=en >>>>> >>>>> -- >>>>> Please read the posting guidelines at: >>>>> http://groups.google.com/group/jBASE/web/Posting%20Guidelines >>>>> >>>>> IMPORTANT: Type T24: at the start of the subject line for questions >>>>> specific to Globus/T24 >>>>> >>>>> To post, send email to [email protected] >>>>> To unsubscribe, send email to [email protected] >>>>> For more options, visit this group at >>>>> http://groups.google.com/group/jBASE?hl=en >>>>> >>>> >>>> -- >>>> Please read the posting guidelines at: >>>> http://groups.google.com/group/jBASE/web/Posting%20Guidelines >>>> >>>> IMPORTANT: Type T24: at the start of the subject line for questions >>>> specific to Globus/T24 >>>> >>>> To post, send email to [email protected] >>>> To unsubscribe, send email to [email protected] >>>> For more options, visit this group at >>>> http://groups.google.com/group/jBASE?hl=en >>>> >>> >>> -- >>> Please read the posting guidelines at: >>> http://groups.google.com/group/jBASE/web/Posting%20Guidelines >>> >>> IMPORTANT: Type T24: at the start of the subject line for questions >>> specific to Globus/T24 >>> >>> To post, send email to [email protected] >>> To unsubscribe, send email to [email protected] >>> For more options, visit this group at >>> http://groups.google.com/group/jBASE?hl=en >>> >> >> -- >> Please read the posting guidelines at: >> http://groups.google.com/group/jBASE/web/Posting%20Guidelines >> >> IMPORTANT: Type T24: at the start of the subject line for questions >> specific to Globus/T24 >> >> To post, send email to [email protected] >> To unsubscribe, send email to [email protected] >> For more options, visit this group at >> http://groups.google.com/group/jBASE?hl=en >> > > -- > Please read the posting guidelines at: > http://groups.google.com/group/jBASE/web/Posting%20Guidelines > > IMPORTANT: Type T24: at the start of the subject line for questions > specific to Globus/T24 > > To post, send email to [email protected] > To unsubscribe, send email to [email protected] > For more options, visit this group at > http://groups.google.com/group/jBASE?hl=en > -- Please read the posting guidelines at: http://groups.google.com/group/jBASE/web/Posting%20Guidelines IMPORTANT: Type T24: at the start of the subject line for questions specific to Globus/T24 To post, send email to [email protected] To unsubscribe, send email to [email protected] For more options, visit this group at http://groups.google.com/group/jBASE?hl=en
