Issues with "0" in report (1 Viewer)

[mkdrep]

Please see (Zeroes.jpg) of a report I am printing. Each line represents when a product shipped and the quantity of the product on each order. Unfortunately, since each order doesn't include a quantity for each of the (10) products, I get a lot of "0" values in report. However, on relatively few occasions, I will get two of three products on one line, as shown in (Zeroes-2.jpg)

Is there anyway to set up the report so only it only prints the fields on an individual row when the product quantity > "0"?

Thank you.

 

[CJ_London]

exclude them with criteria. Without knowing your underlying recordsource, cant suggest what that criteria would look like

 

[theDBguy]

Which rows in your sample images need to be excluded? I couldn't determine which ones you want to eliminate.

 

[isladogs]

Use conditional formatting to set the font color to be the same as the back color when the values are zero

 

[arnelgp]

better Ask around your colleages?
for whom the report is for?
obviously those people who are before you want
to know those details.

 

[CJ_London]

Which rows in your sample images need to be excluded?

I'm assuming it is the first row of zeros-2

Re conditional formatting - I would use the format property

 

[mkdrep]

Use conditional formatting to set the font color to be the same as the back color when the values are zero

I don't know how to accomplish your suggestion. I assume I would highlite each field one at a time, but I'm not sure how to use conditional formating to accomplish what I want. Any other info you could give me would be greatly appreciated.

 

[theDBguy]

...to accomplish what I want.

Hi. I guess I'm the only one who doesn't know what that is. Sorry.

 

[Sun_Force]

I would use the format property

Ready to learn another trick.
How?

Thanks.

 

[MajP]

I think we are not sure what you mean. It is not completely clear. I can see there are several different guesses. If you want the 0s to be invisible then do as mentioned by setting the font forecolor to the backcolor.

This would do something like

 

[mkdrep]

I think we are not sure what you mean. It is not completely clear. I can see there are several different guesses. If you want the 0s to be invisible then do as mentioned by setting the font forecolor to the backcolor.
View attachment 92868

This would do something like
View attachment 92869

Sorry for the confusion I caused everyone. That being said, what you are showing above is what I'm trying to accomplish. Thank you!

 

[Gasman]

I'm assuming it is the first row of zeros-2

Re conditional formatting - I would use the format property

@CJ_London
Like this you mean or similar?

#.000;-#.000;"";""

 

[MajP]

A third/fourth way is to use a calculated value in a query or a calculated control.
In a query you would format each field like:

SELECT IIf([sl15]>0,[sl15],"") AS SL15Format, ... FROM tblProduct;

in a calculated control for the SL15 text box:

= IIf([sl15]>0,[sl15],"")

 

[mkdrep]

Sorry for the confusion I caused everyone. That being said, what you are showing above is what I'm trying to accomplish. Thank you!

The attached is what I finally settled on, which gives a much clearer view than the original report. Thank you again for your help.

 

[theDBguy]

The attached is what I finally settled on, which gives a much clearer view than the original report. Thank you again for your help.

Hi. Glad to hear you got it sorted out. Good luck with your project.

 

[Pat Hartman]

Do you really have ten product columns in your table?