I'm wondering what my options are for presenting a series of reports based on SharePoint task list data...Each report contains a pie chart and bar graph based on certain task criteria.
I'm figuring that this could be done either via Excel Services with an excel workbook connection to the SharePoint list or via SQL Reporting Services.
I've read that the data source does not dynamically update when publishing the workbook to excel services, but a UDF can be created to get around this.
I'm not sure what is possible via Reporting Services.
Basically I'm after some expert advice and recommendations on the pros, cons, gotchas etc for each option.