Printing only rows in which a specific field is greater than 0

[Jerry Call]

I have a CalcValue column in a report. Here's its defining code:
=Round([FullUnitCost]/[NoInFull]*[CumTally],3

This code produces the results I want, rounding off to 3 decimal places.

However, I would like to add one additional detail:
If the resulting number is not greater than zero,
I don't want that row to print on the report.



Is this the correct place to make that happen?
If so, how? If not, what is the best way to obtain this result.

[Micron]

you can't suppress records in a report based on calculations performed in the report - or at least not easily. Once the report is loaded, that's it. There may be a report event (e.g. detail format) that would work, but it would be clumsy and could end up running for every record or group header in the report.
IMO you need to move that calculation to your query and bind the report control to that query field. Criteria for the calculated field would be >0.

[Jerry Call]

Aha! Put a WHERE clause in the query. Works like a charm. Thanks!

[Micron]

You're welcome. Please mark your thread as solved (Thread Tools at top).

[Jerry Call]

I see your mark as solved option at the top, but I'm darned if I can get to the specific option it lists.
Just for the heck of it, please tell me how to get to that path!

But as for this thread, yes, you can mark it solved (since I seem to be unable to do so).

[Micron]

Seems I was able to mark it as solved but that surprises me. I thought that option was only available to the creator of the thread, which makes sense. Maybe it's one for the moderators.