eholleman
asked on
Table Footer Prints Label Even Though Table is Empty SRS (Filter Causes no data to be returned)
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]
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?
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]
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?
ASKER
What I don't understand is that I also have a concatenation of "Total" and a non- existent data value in the group footer row directly above the page footer row yet when I remove the page footer it does not print the "Total" in the group footer nor does it print when I add the footer back.
It may be academic at this point as I will revert to onditional visibility but I want to understand if this is default behavior of a footer or if I have done something self destructive to cause this aggravation.
It may be academic at this point as I will revert to onditional visibility but I want to understand if this is default behavior of a footer or if I have done something self destructive to cause this aggravation.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Just wanted to see if this information has answered your question, and if you were able to get your report working as you wanted.
This question has been classified as abandoned and is being closed as part of the Cleanup Program. See my comment at the end of the question for more details.
The concatenation of "Combined" and the non-existent data value does not yield a "null" in this scenario. The non-existent value concatenates as if it were an empty string, so you end up with just "Combined". Without the conditional hiding, the footer will show.
If you not familiar with hiding report items, look at the Visibility property for the items. It can be set to False (not hidden), True (hidden), or can use an expression to conditionally determine True or False. You can also toggle visibility using another report item.