I am looking at the possibility of using Reporting Services and Business Scorecard Accelerator as the front end dashboard.

Can someone please provide me information on how these two products work together?

I understand all of the report development work would be in Reporting Services. Is the Business Scorecard Accelerator simply used as a method to display KPI's based on these reports....and then when you drill into the KPI's, it actually opens the reports in report manager???Or are the reports opened in Business Scorecard Accelerator?

Hope someone can provide me with information of how these two applications interact.

hi,

I am not sure this is going to solve the issue as i am not familiar with Business Scorecard Accelerator, but i can comment on integration of reporting services to other applications.

To call a report from another web app usually you have two methods
1)You can use the http://ReportServer url(not the http://reports url which leads to reports manager) with paramerters in query string
2)You can consume the it as web service and render it to your page

Prashant

Thanks Prashant..I was aware that you could pass parameters via URL...

I have been reading the SQL Server product overview, and it states that KPI's can be created but there are currently no packaged client tools with SQL Server 2005 which allow you to use these KPI's. As a result I am looking into other Scorecard/Dashboard applications which I could use to either create the KPI's or display them. Once they have been created, it would be good to be able to click onto them to open the relevant Reporting Services report.

Any ideas?