How to Create Dashboard using SSRS 2005 Reports.??

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Reporting Services » Reporting Services 2005 Development » How to Create Dashboard using SSRS 2005...

How to Create Dashboard using SSRS 2005 Reports.??

Rate Topic

Display Mode

Topic Options

Author

Message

bhushan_juare

Posted Monday, November 05, 2012 10:43 PM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:14 AM
Points: 62, Visits: 358

Hi All,
After all attempt I finally Suceeded to deploy SSRS reports outside Local Host...Next thing I am trying to create Dashboards using SSRS reports but I am not able to understand what I suppose to install..?? After lots of google I come to know about SharePoint Server but don't know how to integrate with SSRS 2005..
Does anybody knows how to do...?

Thanks & Regards,
Bhushan

Post #1381375

peterzeke

Posted Wednesday, November 07, 2012 7:55 AM

SSC Veteran

Group: General Forum Members
Last Login: Today @ 10:04 AM
Points: 285, Visits: 1,203

Bushan:

You don't necessarily need sharepoint to create and display a dashboard that is built within a SSRS report.

You can actually create a dashboard within a single SSRS report. If necessary, you can build a "container report" than is comprised of subreports. Each subreport can focus on a specific type of data for the dashboard.

On the other hand, depending on what the nature of your data is and what message you are attempting to convey on the dashboard, you may be able to build just one SSRS report that contains one or more datasets that are then displayed on the report using various graphs.

By the way, if you don't have a lot of experience designing dashboards or reports that include data visualizations (graphs, charts), please take some time to browse the information on Stephen Few's website: www.perceptualedge.com His articles are excellent, his blogs are relevant, and the discussion forums are engaging.

Stephen Few is an expert in data visualization and the design of dashboards. He doesn't focus on technology, however, so don't expect to find solutions specific to SSRS. What you will find are excellent principles of dashboard design.

As for help with SSRS, keep coming back to sqlservercentral. Lots of smart people here who are willing to assist.

--pete

Post #1381994

« Prev Topic | Next Topic »

Permissions