Link to home
Start Free TrialLog in
Avatar of jyothsna1803
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.
Avatar of sventhan
sventhan
Flag of United States of America image

Write a format trigger on top of this column.
If its null or zero set the trigger to display the field.
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.
Avatar of jyothsna1803
jyothsna1803

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..
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.
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.
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.
 
Also check the settings on the placeholder within the layout model.
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!
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.
Hi sventhan Could you please give me the piece of code which you have worked earlier in your project. Thanks!
ASKER CERTIFIED SOLUTION
Avatar of jyothsna1803
jyothsna1803

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial