| SRW.SET_FORMAT_MASK-- creating issues [message #483821] |
Wed, 24 November 2010 13:41  |
buggleboy007
Messages: 282
Registered: November 2010
Location: Canada
|
Senior Member |
|
|
I am running a Oracle report (Now this issue comes up only when I generate the report in .PDF( and not in paper layout format), and one of the field on the report called "F_prev_val_amt_000" has a trigger in it and is as follows:
******************************
function F_prev_val_amt_000FormatTrigge return boolean is
begin
IF :line_item_nbr_000 = '065' THEN
SRW.SET_FORMAT_MASK('(fm9,999,999,999)');
ELSE
SRW.SET_FORMAT_MASK('(fm9,999,999,990.00)');
END IF;
return (TRUE);
return (TRUE);
end;
****************************
When the report is generated, the value for :line_item_nbr_000 = 065 produces exact value as required from the database where as
if you look at the else statement below
(ELSE SRW.SET_FORMAT_MASK('(fm9,999,999,990.00)') )
This else produces all astreix or xxxxxxxxx
I have also checked "after report" trigger and that does not have any code that causes this astreix so to speak.
I have checked all the property insepector sheet and found nothing wrong. There are also similar triggers in my report and they too produce the correct and expected results.
I ran the following at SQL prompt and found it generated correct result as required.
"SELECT TO_CHAR(6721922976,'fm9,999,999,990.00') FROM DUAL" out put was :6,721,922,976.00.
Can any one help me in getting this issue sorted.. i.e. why am I seeing Astreix or XXXXXXXXXXX instead of a number?
Thanks in advance,
Sandeep
|
|
|
|
| Re: SRW.SET_FORMAT_MASK-- creating issues [message #483822 is a reply to message #483821] |
Wed, 24 November 2010 14:16  |
buggleboy007
Messages: 282
Registered: November 2010
Location: Canada
|
Senior Member |
|
|
Issue fixed:
I changed the length of the field in the table.. taht did not fix the issue. So increased the length of the object on the report editor and that seemed to have fixed the issue for me. I am now able to see the monetary figure.
Thanks in Advance to everyone who had their line of thought on the same issue.
|
|
|
|
| Re: SRW.SET_FORMAT_MASK-- creating issues [message #483824 is a reply to message #483822] |
Wed, 24 November 2010 15:04 |
 |
Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe
|
Senior Member
Account Moderator |
|
|
Right; all ****** usually mean that there's no enough space to display desired output. What is even more funny, is the fact that the same report viewed as "Paper layout" looks OK, while PDF causes lines wrap, numbers and dates turn into **** and similar. Therefore, it is not enough to make your report fancy (sort of) just in paper layout, but you have to frequently test it in PDF format.
I'm glad you found the solution!
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
