Table Footer Prints Label Even Though Table is Empty SRS (Filter Causes no data to be returned)
Posted on 2010-11-27
I have 5 tables placed in a report body (SSRS 2005)
The tables point to the same Dataset
The tables have differing columns base upon the record type in the data set
The Tables are individually filtered for a [recordtype]
Then tables are grouped by [ContractType] with a subtotal at change in [ContractType] – In one column I placed [“Total “ + Fields!ContractType.Value] in the far right field I place Sum(Fields!amount.Value).
All seemed good, if there were no records that met the filter criteria for the report section - [recordtype], nothing would print on the report for that section.
I then added a Table Footer so I could show the totals for all contract types within that record type.
In one column I placed [“Combined “ + Fields!RecordType.Value] in the far right field I place Sum(Fields!amount.Value).
Now when there is a section without a qualifying record type, instead of printing nothing, it prints “Combined” and nothing else.
Note that [Fields!RecordType.Value] is only referenced in the Filter for the table and the Footer, it does not appear anywhere in the grouping or in the “Table Details”
Why is this printing (the “Combined” in the group footer) when there is no qualifying data in the table that meets the filter criteria of the table?