Hello. I have a tablix that is grouped by an event name with a child group of ID. The child group is filtered to only display where there are more than 10 occurances of an ID. I want to be able to show how many rows there are in this group in the footer of the tablix (ie. outside the ID group). I assume that I may have to add some code - but I can't work it out. Any help appreciated. Thanks. EG: MACBETH --------------------------------- ID | Name | Total IDs 001 | Mr Smith | 11 008 | Mrs Smith | 15 ---------------------------------- Total Rows: 2

Hi, You can easily do this by using ReportItem("Id").Value. So now, you need to add following expression in page footer = "Total Rows: " + Count(ReportItems("ID").Value) Note:- Here ID is a textbox name, change it accordingly For More details Kindly visit this good post from Jason http://beyondrelational.com/blogs/jason/archive/2011/02/07/display-current-page-total-in-footer.aspx- Chintak (My Blog)

Add a footer to the group event name and in that footer just do count(ID), that should give you the count for every eventnamePlz mark as Answer if your problem is resolved. Reddy

Hi CharlieGriffiths, As Chintak posted, it is a good solution to solve your issue. By the way, please change the “+” symbol into “&”. Set the expression like this: = "Total Rows: " & Count(ReportItems("ID").Value) Best Regards, Bin Long