Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 676
  • Last Modified:

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.
0
jyothsna1803
Asked:
jyothsna1803
  • 7
  • 2
  • 2
1 Solution
 
sventhanCommented:
Write a format trigger on top of this column.
If its null or zero set the trigger to display the field.
0
 
j_coreilCommented:
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.
0
 
jyothsna1803Author Commented:
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..
0
Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

 
jyothsna1803Author Commented:
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.
0
 
jyothsna1803Author Commented:
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.
0
 
sventhanCommented:
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.
 
0
 
j_coreilCommented:
Also check the settings on the placeholder within the layout model.
0
 
jyothsna1803Author Commented:
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!
0
 
jyothsna1803Author Commented:
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.
0
 
jyothsna1803Author Commented:
Hi sventhan Could you please give me the piece of code which you have worked earlier in your project. Thanks!
0
 
jyothsna1803Author Commented:
I have used the below code to resolve this issue. Anyway thans for all.
if(:Cell is null) then
                        SRW.SET_FIELD(0,0);  ---- This line make sure that always the cell displays
                        srw.set_text_color('white');  -- This line hides the Zero Value.
end if;
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

  • 7
  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now