Aiko You should set two variables in the report one for Mr or Mrs and one for the title. Assuming the column in the table is gender and you already have the vFrstName and vLastName variables already set.
SET VAR vMrorMrs = (IFEQ(Gender,'M','Mr',(IFEQ(Gender,'F','Mrs',NULL)))) SET VAR vTitle = (IFNULL(.vMrorMrs,(.vFrstName & .vLastName),(.vMrOrMrs & .vFrstName & .vLastName))) Buddy -----Original Message----- From: [email protected] [mailto:[EMAIL PROTECTED] On Behalf Of Aiko Ichimura Sent: Saturday, March 03, 2007 11:45 PM To: RBASE-L Mailing List Subject: [RBASE-L] - Re: V 6.5 Does anyone know how to set a format for report on a field to prevent printing any spaces when the value is NULL. I am dealing with title printing. My client keep track of sex of people in their table. The value could be unknown. When they print a letter putting name of people, either 'Mr.' or "Ms.' is printed except when it's unknown. I set vtitle to be Null when sex is unknown. But when Null value is printed, it prints 3 spaces because I put enough spaces to print 'Mr.' or 'Ms.' I want set some format , if exists, to prevent printing those 3 spaces and left justify their names.. Thank you always for your insightful suggestions and hints to help me. Aiko Ichimura [EMAIL PROTECTED] --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
