Goal: To have a legend that only shows visible layer symbologies in ArcMap 10.0
Background: I have map that is symbolizing code enforcement cases by pulling live data out of SQL Server and joining it to parcel polygons based on parcel ID. The map gets exported daily using a simple Python script. There about nine different case types that can be shown on the map, but there are not always cases of every type open and displayed on the map. Currently, the map legend shows the symbology for all nine case types, when in reality there may only be 4-5 case types visible on the map. Ideally the legend would only contain the visible symbology for the (a la Dynamic Legend in Arc 10.1).
Question: Is there a way to configure the legend or layer so that the map legend will only show the case type symbologies that are currently visible on the map (without upgrading to ArcGIS for Desktop 10.1 of course)?
Thanks to anyone who has the answer, even if the answer is no :)