show total number of records at the end of the page

Question

Hi,

I would like to show total number of records of at the end of the page using crystal report. Could you please help? If there are no records I would like to display the count as 0.

Thanks,

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

http://social.msdn.microsoft.com/Forums/en/vscrystalreports/thread/189f369c-a95a-4af5-b6ba-12cbd701a03c

If you dont feel like clicking, here is the solution provided Change Summary operation" and using the "Count" fieldis 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})) then0elsecount({your filed})