I would like to show total number of records at the end of the page using Crystal Reports. If there are no records I would like to display the count as 0
.
If you don't feel like clicking, here is the solution provided:
"Change Summary operation" and using the "Count" field
is a formula :count({your filed})
if no rows,count({your filed})
will returnnull
.
so, you can create a new formula filed to replace your Σ 。
the formula:if isnull(count({your filed})) then 0 else count({your filed})