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

Question

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 1

Well, one thing you can do is add a field to the resultset that is the count of the number of the records in the result set.

It may not be the prettiest solution; the count has to appear in every row returned. When I last used Crystal Reports (pushing two years ago now), I don't recall a single report being capable of handling results from multiple data sources.

Answer 2

• MSDN Source

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})