Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 Analysis Server and Reporting Services (2008)
 Dash Boards

Author  Topic 

Adam West
Constraint Violating Yak Guru

261 Posts

Posted - 2009-09-11 : 14:58:23
HI I have to convert a program from Crystal Reports XCelisius, which is a dashboard program. Is there a way to have dashboards here in Reporting Services?

cat_jesus
Aged Yak Warrior

547 Posts

Posted - 2009-09-11 : 16:22:02
Yes you can create dashboards in SSRS.

An infinite universe is the ultimate cartesian product.
Go to Top of Page

Andrewra
Starting Member

17 Posts

Posted - 2009-09-14 : 13:18:28
Just depending on the complexity of your dashboard there are several solutions, from the basic SSRS report to integrating Shartpoint with SSRS along with performancepoint and Proclarity.

Andrew Alexander
Go to Top of Page

Adam West
Constraint Violating Yak Guru

261 Posts

Posted - 2009-09-25 : 15:43:56
It looks like they want to use Dundas. I will give it a go.

Go to Top of Page

Adam West
Constraint Violating Yak Guru

261 Posts

Posted - 2009-09-29 : 09:00:48
I want to do a Report that will have dashboards in it. It is to show some sales data per customer and product, and to have a alert in red of some kind, when a product is over budget, so there is a third table involved.

My question is, can this be done just using Visual Studio 2008 and Reporting services, putting the finished report in Report Manager?

Where can I see some examples or information on how to do this?



Go to Top of Page

dbradish
Starting Member

24 Posts

Posted - 2009-10-05 : 16:30:07
You can do all of that using SQL 2008 inserting a Chart or Gauge that ships with SQL. You don't have to purchase Dundas separately unless you need a map or something more complex. Use the chart/gauge properties to set goals/levels based on percentages in your data set.

Sorry I can't attach a screen print, but it's pretty easy to figure out if you have a few minutes.

Deploy your report to the report server, either native or SharePoint integrated. We have several dashboards using SSRS08 alone and they work great with many built-in user optional parameters and drill-down reports.

Good luck!
Go to Top of Page

Adam West
Constraint Violating Yak Guru

261 Posts

Posted - 2009-10-14 : 15:17:54
Yes I am not seeing some codes how to do the dashboards.
Go to Top of Page

Adam West
Constraint Violating Yak Guru

261 Posts

Posted - 2009-10-15 : 11:04:57
Where do you tell the Report that a particular fields shows as a Dashboard or as a gauge?
Go to Top of Page
   

- Advertisement -