Hi rbursell;

To suppress zeros on any BV Form in report designer you would right click on the quantity field you wish to suppress zeros in.  Then click, format field, number, customize.  Check Suppress if Zero. Click ok and save your document.  You must do this on every field that you wish it to suppress if the amount is a zero.

I hope this helps.

Penny

Hi,

On my packing slip the Number field is 10 digits long and BV inserts zeros to makeup the 10 digits ie, 0000012345.

When I hover over the number it is called TEMP_ORDER_HEADER.NUMBER (string). If I right click the field my choices are Field, Format Field, Highlighting Expert, Browse Field Data, Select Expert etc. When I choose Format field the tabs showing are Common, Border, Font, Paragraph, Hyperlink. There are several options on each.

I don't see anything that says suppress if the amount is zero.

Any suggestions?

Thanks.

Hi Rbursell;  Sorry I misunderstood your question.  Suppress zero amounts is only for qty fields that have a balance of zerio.

I research you question on removing leading zeros from the order number field.  This is what I found out and I'm hoping it will help you.

With a string field, Crystal relies in text so standard numeric operations like multiply, divide, brackets, etc do not apply.

Best thing to do for a string to remove the leading zeros wouldbe a simple right function.  

Example;

Right((sales_order_hearder.number),5)

where the 5 is the reight most fields which are non-zeros.