I have a 3d riser graph which I'm trying to get to show On Change of SupplierName and Commodity, Show Values Sum of Indexpoints. This report is given to each of our suppliers to show how we rank them compared to other suppliers with the same commodity type. Each report that is given to the suppliers is only supposed to show the current suppliers label, but show the graph values of index points for all suppliers. Imagine a graph with a legend listing all of the commodities, but only one supplier name even though all suppliers in the commodity are listed...so for example the data may look like:
SupplierName Commodity Index Points
KF Corp. RUBBER 12
KF Corp. FASTENER 25
I am setting all suppliernames to ' ' but the current one inside of the query im using. Because all of the suppliernames=' ' it is combining them all. So in the graph I only four bar graphs, two for KF Corp and two more for EVERYOTHER supplier(one for RUBBER and one for FASTENER). I need it to show each suppliername individually instead of all the blank ones totalled. I tried to base graph on change of vendor instead of suppliername since that field will always have values, but then the graph shows all the vendor ID#'s which isn't allowed. It HAS TO show only current supplier label but show all other suppliers in same commodity without their name displayed. Any ideas how to make crystal distinguish all the Suppliername=' ' as seperate suppliernames?