Report Viewer - Count

Question

Hello Guys.

I have a report that works like the following:

Customer             |    City            

John                     |    London

Joseph                  |    New York

Bill                       |    Rome

Bob                      |    London

Clark                    |    New York

I would like to count, in the table's footer, how many times each city appears in the report, like following:

London: 2

Rome: 1

New York: 2

Only the cities that appear in the report should be counted (cities with count 0 may not appear). Any ideas?

Thanks in advance.

Answer 1

Help!!!

Answer 2

HI Macarrao,

There is a option for grouping in tables, you can group by city, once you do grouping you can see group header and footer, so sum(count as you mentioned) will be easliy displayed

Hope this will help You

-Raja Sekhar K