I have created a report as a local report which looks like this:
I'm trying to add a chart to this report and I'd like it to display something like this (so sorry for the crude drawing):
It seems like it should be quite straight forward but I've tried dragging the fields into the chart all different ways and can't make it happen. I'm using Visual Studio 2010 and here's what my list of fields from the dataset look like:
I thought ObservationYear would be the series and all the other fields would be the data but this doesn't work. It produces a chart like this which wasn't what I was hoping for:
Please could you help me understand what it is I'm doing wrong? I'm very grateful for any help/advice you might be able to provide.
View Complete Post