jyothsna1803
asked on
The borders are missing around all of the cell if value is Zero
i have developed a oracle report, it has few cells and datatype is Zero. If the value of the column is null then the cell border is disappearing. How to fill the Cell border even thought the value of the column is null.
Another option is to enclose the SQL or PL/SQL block with an nvl() to determine if a null is determined. Then you can catch it and return a ' ' or 0 or something else that is handled.
ASKER
More info:
Source field for this column is a Summary column and Format mask is NNNGNNNGNNNGNN0. Please let me know if you have any clue please...
If its null or zero set the trigger to display the field?? Could you please tell me the sample code..
Source field for this column is a Summary column and Format mask is NNNGNNNGNNNGNN0. Please let me know if you have any clue please...
If its null or zero set the trigger to display the field?? Could you please tell me the sample code..
ASKER
Hi j_coreil: This is a summary column. So as sventhan adviced write format trigger on top of this column is a better option, but i don't know how to write. any one tell me what code should i write if the field name is f_test.
ASKER
function F_cs_test1FormatT return boolean is
begin
if (:cs_test IS NULL) then
srw.set_field(0, to_number(:cs_test));
return (TRUE);
end if ;
return (TRUE);
end;
still no luck, even i checked without srw.set_field(0, to_number(:cs_test)); still noluck. As i think Number column won't allow blanks. Even i tried format if null case still no luck. Good other valuable suggestions.
begin
if (:cs_test IS NULL) then
srw.set_field(0, to_number(:cs_test));
return (TRUE);
end if ;
return (TRUE);
end;
still no luck, even i checked without srw.set_field(0, to_number(:cs_test)); still noluck. As i think Number column won't allow blanks. Even i tried format if null case still no luck. Good other valuable suggestions.
I've faced this kind of issues before and I'll try to find the source code for you.
The other idea is create a dummy column behind this actual column. With the use of format trigger you could enable and disable that column.
Good Luck.
The other idea is create a dummy column behind this actual column. With the use of format trigger you could enable and disable that column.
Good Luck.
Also check the settings on the placeholder within the layout model.
ASKER
Please let me know if you find the source code, Even i know by adding dummy column as Char datatype probably may solve the issue. But my report got atleat 100 cells, it is not possible to create 100 dummy columns. Also i need to implement the same for several reports. Thanks!
ASKER
I don't see any speical settings we need to specify on the place holder. It is a field type and source is a summary column and with format mask NNNGNNNGNNNGNN0.
ASKER
Hi sventhan Could you please give me the piece of code which you have worked earlier in your project. Thanks!
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
If its null or zero set the trigger to display the field.