Reporting Services & Charting
<rant>
I'd like to proclaim that I HATE the charting capabilities in SQL Reporting Services. I spent about an hour trying to figure out how to do a basic scatter graph with a very small set of data. Well, after trying about 50 gazillion ways, I cannot get the graph to work. Just to make sure I wasn't crazy, and actually knew the data I had could be graphed...I copied the data into an Excel spreadsheet. After that I inserted a chart, and 2 minutes later I had a scatter graph the way I wanted it.
Why is it so freaking hard in Reporting Services? Why can't they have an easy to use tool like Excel? Why did I spend so much time to get a chart that didn't work? I just don't understand it. I hate it! ARRH!
</rant>
Okay, now that I'm done ranting & raving, does anyone know how to properly chart things using SQL Reporting Services?