Interactive Reporting in ASP.NET using SSRS (2005)

Hi, I am looking for some guidance on the way to go for achieving the task described below.

I am working on a project to generate various statistical reports for the Revenue managers.

The application is aimed to be a browser based application usingASP.NET. The reports shall be interactive with all the functionalities like annotations, dynamically changing the range of the x-axis and report-click should take the user to a new report/web page, context menus, multiple reports on the same page - charts and matrix/tabular.

My boss is envisioning the applications to have interactive charts just like those you find on the Yahoo Finance website.http://finance.yahoo.com/charts. They seem to be using the Flash player.

Questions:

We have a license for SQL Server 2005 reporting services. We had a hard time incorporating the SQL Server reports into the
ASP.NET AJAX enabled web application, using the ReportViewer control that comes along with VS2005, and they are pretty much static. Is there a better approach? I have looked at Dundas Charts they don't quite seem to be as interactive as the google finance and yahoo finance charts.Is the same thing possible without SSRS?. In terms of having Flash like report interactivity on the webpages?.Do Silverlight and/or WPF offer me the capability of building a RIA ASP.NET website (Rich Internet Application) with support for charting.

Any reponse is appreciated.

Thanks

Try the Digital Dashboards & Executive Dashboards.

http://www.dundas.com/Dashboards/index.aspx?Campaign=ASPAlliancePS

|||

Thanks Momo_Stev,

I have taken a look at them, however they lack a little on the rich presentation side. After I posted this query, I came accross the below article which sounds to be doable in my case.

Article breifly explains how to integrate Flash into client side with ASP.NET server scripting.

http://www.4guysfromrolla.com/webtech/032603-1.shtml

Thank you.