Joined: 02 Oct 2008
Online Status: Offline
Posts: 5
Topic: hiding an element Posted: 24 Oct 2008 at 6:30am
Hi, I have been searching through the books but I can't seem to find how to set an elements visible property. I have a formula field that is a number, if it is 0 then the report prints 0.00 I want it to print nothing.
I am pretty new to crystal so I could be going about this wrong way even, I don't know - Any advice would be great. This is what my current formula looks like.
if({DataTable1.Agent_Commission} > 0) Then {DataTable1.Agent_Commission} Else
Joined: 19 Jun 2007
Location: United Kingdom
Online Status: Offline
Posts: 150
Posted: 24 Oct 2008 at 7:08am
I would conditionally suppress the field if the value was zero. Put it on the report, then 'Format Field', tick the Suppress box, and put =0 in the formula box beside the tick
Joined: 20 Jan 2008
Online Status: Offline
Posts: 92
Posted: 24 Oct 2008 at 9:17am
Another option ....
Go ahead and have your else return a zero.
To set the format to suppress the zero, right click on the object on your report, go to Format Field, Click on the number tab, click on Customize and check the suppress if zero box.
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot delete your posts in this forum You cannot edit your posts in this forum You cannot create polls in this forum You cannot vote in polls in this forum
IP Logged
