?
Solved

How to supress showing of zero value

Posted on 2001-07-31
4
Medium Priority
?
272 Views
Last Modified: 2013-12-26
I have datawindow with 10 similar double field for edit.  During runtime, I will try to insert 10 rows to the DW control and make it become a 10x10 field for input value. Now since I need to compute the subtotal for rows and columns and so I intialise each field with zero.  However, for easy viewing, I would like to suppress showing all the zero value.  I've try to set a rule in the datawindow object in the column.color attribute, like "if ([column] = 0, rgb(255,255,255), 0)"  However it doesn't work well since when I try to input value, since the font color is now white(same as backgroud), I can't view the value before I jump to another field. Do anyone have other good and easy suggestion?
0
Comment
Question by:kokan
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 4

Accepted Solution

by:
Bhatti earned 200 total points
ID: 6339520
Hi Kokan

I think you need not to change the color in your coulumn to disable the value and again change color.
For your values use the format in Expression of datawindow column properties or you computed field properties.

You can also use the Modify function to adjust your format and also the string function to adjust the format.

Let me know, may I write you some codes.
0
 
LVL 2

Expert Comment

by:rajeXsh
ID: 6341375
Set the format of all the fields to '#' (# is zero supression)
0
 
LVL 1

Expert Comment

by:levr
ID: 6342756
Use editchanged event:
If data argument is != 0, change the color back.

If this is not clear - I will send you the code.
Lev
0
 

Author Comment

by:kokan
ID: 6343480
Finally, I done it by put the formula [ if [column] = 0, "#", "0.00" ] in the format attribute of the column object.  It works very fine!  Thank you for all of you's valuable suggestion.
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In our object-oriented world the class is a minimal unit, a brick for constructing our applications. It is an abstraction and we know well how to use it. In well-designed software we are not usually interested in knowing how objects look in memory. …
Update (December 2011): Since this article was published, the things have changed for good for Android native developers. The Sequoyah Project (http://www.eclipse.org/sequoyah/) automates most of the tasks discussed in this article. You can even fin…
THe viewer will learn how to use NetBeans IDE 8.0 for Windows to perform CRUD operations on a MySql database.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.
Suggested Courses

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question