I've been asked to set up a dashboard that will enable our users to call up various reports that interrogate a variety of data sources - either SQL Server 2008 or Sybase 11 (incredibly old). The dashboard is to be accessed using a browser, probably IE.
I was just wondering what people's opinion of the best approach for this would be? I have BIDS 2008 and Visual Studio 2010 available. VS2010 doesn't actually give me a project type for Web reporting (the only reporting options seem to use Windows Forms or WPF), but if I could get around that drawback, my gut feeling is that I should use VS2010 in conjunction with some webservices that will return the data for me (I've never written a web service and would like to try my hand at it). Is that a good idea? If not, what would anyone recommend?
Thanks in advance!