How to show the total number of records at the end of the page

nav100 picture nav100 · Nov 13, 2009 · Viewed 14.5k times · Source

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.

Answer

Woot4Moo picture Woot4Moo · Nov 13, 2009

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 return null.
so, you can create a new formula filed to replace your Σ 。
the formula: if isnull(count({your filed})) then 0 else count({your filed})