How do I format a phone number value in Bus. Objects? For example, the value in Informix is 9999999999. I want my report to reflect 999-999-9999
Is this possible in the reporter module, or do I have to do something in designer?
Thanks,
Marie Phillips
Sr. Systems Analyst
ALARIS Medical Systems
Ph: 858-458-7862
Fax: 858-458-7640
mjphilli@alarismed.com
Listserv Archives (BOB member since 2002-06-25)
Question:
How do I format a phone number value in Bus. Objects? For example, the value in Informix is 9999999999. I want my report to reflect 999-999-9999
Is this possible in the reporter module, or do I have to do something in designer?
Yes!!! This is possible in the reporter module. To achieve this type of phone number format, highlight the appropiate column in the report. Afterwards, select “Edit Formula” under the “Format” on the Toolbar menu, then enter the formula displayed below.
=Concatenation(SubStr(YOUR PHONE NUMBER GOES HERE ,1, 3), “-”) + Concatenation(SubStr(YOUR PHONE NUMBER GOES HERE,4, 3),"-") + SubStr(YOUR PHONE NUMBER GOES HERE,7,4)
Thanks,
Ed Kelly
IT Consultant - RENAISSANCE WORLDWIDE, INC. (aka, The Registry) On site at Bell South Celluar Corp.
Office: 770.351.1374
email: kellye@bscc.bls.com
Listserv Archives (BOB member since 2002-06-25)
Ed
An easier way is to use the number mask “000-000-0000” in the format cell options. The “-” is the escape character to include the “-” in the format.
Mike McErlain
At 03:02 PM 3/29/2000 -0500, you wrote:
Question
How do I format a phone number value in Bus. Objects? For example, the value in Informix is 9999999999. I want my report to reflect 999-999-9999 Is this possible in the reporter module, or do I have to do something in designer?
Yes!!! This is possible in the reporter module. To achieve this type of phone number format, highlight the appropiate column in the report. Afterwards, select “Edit Formula” under the “Format” on the Toolbar menu, then enter the formula displayed below.
=Concatenation(SubStr(YOUR PHONE NUMBER GOES HERE ,1, 3), “-”) + Concatenation(SubStr(YOUR PHONE NUMBER GOES HERE,4, 3),“-”) + SubStr(YOUR PHONE NUMBER GOES HERE,7,4)
Listserv Archives (BOB member since 2002-06-25)
Didn’t look up the exact syntax but this gives you a good idea of one way to do it…
left(,3)+“-”+instr(,4,3)+“-”+right(,4)
“Phillips, Marie” MJPhilli@ALARISMED.COM 03/29/00 11:04AM >>>
How do I format a phone number value in Bus. Objects? For example, the value in Informix is 9999999999. I want my report to reflect 999-999-9999
Listserv Archives (BOB member since 2002-06-25)
Has anyone found that the Webi version of BO does not retain custom formatting when downloading as a .csv file.
Example:
When formatting our Job Number string…Base Job, Split No, Back No within BO Thick Client they appear as such when downloading. Base Split BO
777777 000 00
However, even when utilizing the same “custom” format on the Webi version that appear as such when downloading.
Base Split BO
777777 0 0
Appreciate any input. Is this fixed in 5.1, 2.6?
Thanks in advance!
BO 5.0 Webi 2.5 Oracle
Suzanne
Listserv Archives (BOB member since 2002-06-25)
At 02:28 PM 5/29/2001 -0500, Suzanne Fries wrote:
Has anyone found that the Webi version of BO does not retain custom formatting when downloading as a .csv file.
Suzanne, when you run a query, rows of data are brought back to the WebI server. When you go to the “Format” tab in WebI, you are telling WebI how to format an HTML report from those rows of data.
The problem is that when you download the .csv file, you are downloading the data “cube”, the raw data from the WebI server, not the “formatted” report. That’s why you’re not seeing the formatting per se.
But the question then is, how are you opening the .csv file? In Excel? If so, you can apply your “formatting” there.
Regards,
Anita Craig
Stanford University
Listserv Archives (BOB member since 2002-06-25)