Report Viewer - Count RRS feed

  • 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.
    Thursday, October 15, 2009 11:48 PM

All replies

  • Help!!!
    Saturday, October 17, 2009 12:19 PM
  • 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
    Monday, November 2, 2009 11:51 AM