Dash board Reports in SSRS(SQL Server 2008)

Question

Dear all

How to Prepare Dahsboard Reports in SSRS. and What are Flexibility with Dashaboard Reports

Anybody knows Pls Explain Sample Dashboard in SQL SErver 2008

Answer 1

Are using PerformancePoint in SharePoint 2010 to create Dashboards with Reporting Services reports?

What are you trying to achieve? "Dashboard" can mean many different things to different people.

Answer 2

Hi Stephen,

I Want to Create SSRS(SQL Server 2008) Dash board Reports.Data is presented in Sql server Database using that data and create Dash board Reports.

Answer 3

What do you mean by "Dash board Reports"? Give us an example.

Answer 4

Typically you'd use a dashboard designer like the one that comes with PerformancePoint for SharePoint.

http://technet.microsoft.com/en-us/library/ff724283.aspx

If you don't have SharePoint and only want to use Report Server then you could imbed URLs into a web page with direct calls to the report server (which gives you the ability to turn off the toolbar etc that would normally show up if using Report Manager).

Alternatively, you could place multipe objects (drill down charts, gauges, matrix etc) on a single report and publish it in Report Manager. You could add parameters that all the objects reference.

Answer 5

Yes

I set up something like this just using SSRS for unattended real time autorefreshing dashboards that were displayed on a screen in the ops room.

I used a combination of subreports to create a parent report.

I used the autorefresh feature on the report to have the data autorefresh every 2 mins

It didn't work too well because the SSRS report manager web service has a built in "as designed" .net garbage collection feature that runs every 12 hrs by default and that would cause the autorefreshing to break at 12:30am and 12:30pm every day.

We ended up creating a wrapper site like stephen suggested and used the reportviewer control to show the reports (this also allowed us to brand the front end for for the reports) and used html to control the autorefresh

If you dont need autorefreshing it should be fine