Printing a report and exclude all data with 0

[jwright77]

Hi,



I created a Report and some of the data has 0, and I would like to print the report excluding the entire row if possible that has 0 across the board.

Thanks for your help. And attached is the report.You can see Chesnee and Cowpens have 0 for data, and I want to get rid of the entire line w/o creating specific reports for each day.
WIC 8-16 final.pdf

[pbaldy]

You can base the report on a query that excludes them. In SQL view the criteria would look like

WHERE Field1<> 0 Or Field2 <> 0 Or Field3 <> 0

You could also use the Wherecondition clause of OpenReport and leave the report's source as it is.

[jwright77]

Thanks for the reply. Is there a way to print the report just with one specific date? My reports are printing every record. But the date at the top is just the same date...while the data was entered in using a date field on different days.

[pbaldy]

Sure. You can add a criteria to the query or use this technique:

BaldyWeb wherecondition