dianemarie
Instructor
Hello, I'm working with filtering records in a table (top 20 on a group). I am using runningvalues to grand total the top 20 records returned. (As many know, SSRS will total all the records, not just the records returned from the top 20 filter). The developer I work with did a second row on the group with running values for the fields we are summarizing, then she conditionally suppresses all the rows except the 20th row. However, if there are more than 20 top 20 (in the case of ties), then we run into a problem hard-coding the 20th row. Is there a way to conditionally suppress all group footer rows except the last one? Sort of screwy, I know. This should be easier.... Thanks for any help.