Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Supress Zero Values 1

Status
Not open for further replies.

kmPremier

MIS
Mar 30, 2004
8
CA
Hello,
I am attempting to suppress the Zero Values in a report.
I attempted to do the following formula:
if {ARIBD.AMTEXTN} = 0
then " "
else {ARIBD.AMTEXTN}

However my "else" statement gets rejected saying that I need a string here...

Any thoughts? I truly appreciate any help I can get on this.

Thanks!
 
Instead of creating a formula, write some code in the conditional suppression for your {ARIBD.AMTEXTN} field.

Right click the {ARIBD.AMTEXTN} field on the report, and choose format field.
Under the Common tab, select the X+2 button to the right of the Suppress property.
Add the following line in the editor:

{ARIBD.AMTEXTN} = 0

Save and Close and Test it.

~Brian
 
Thank you so much!
That worked perfectly, I knew it had to be something fairly simple, I just couldn't, for the life of me find it.
Thanks again!
K
 
Or just right click the field, select format field->Number->Customize and check the Suppress if Zero.

No code required.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top