Stacked Bar Chart - Hiding legends with 0 values
I'm using Crystal Reports 2008, building a report that will eventaully be called from an ASP.NET page.
I've built a stacked bar chart that is displaying values per month of the number of various vehicle types. The X values are the months, the Y values are the number of each vehicle type and the stacked series are each different vehicle type. However, depending on the months that the user asks for, there may be some vehicle types that do not have any data, thus the number is 0. Is there a way for the report to see that there is 0 data for this vehicle type and thus not include it in the legend of the various vehicle types?
First time poster, so hopefully I explained everything well enough. I searched the forums for anything matching Stacked Bar Chart and did not find anything. I don't know how to find/query SAPNotes.