Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Services / Reporting Services / March 2007

Tip: Looking for answers? Try searching our database.

Creating Dashboard using SQL Server 2005

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
iweb - 18 Mar 2007 18:06 GMT
Hi,

can we create a Digital Dashboard using MS SQL Server 2005? Kindly guide.

Akshay.
Kathy - 19 Mar 2007 17:40 GMT
Hi,

Sort of.  You can integrate the Reports with SharePoint to create a
dashboard. There are other solutions out there that handle it better... I
haven't used any others, but I hear there are some excellent ones out there.  
Try googling and good luck.

-Kathy

> Hi,
>
> can we create a Digital Dashboard using MS SQL Server 2005? Kindly guide.
>
> Akshay.
iweb - 19 Mar 2007 17:57 GMT
Can we just use SQL Reports and create dashboards without using Sharepoint?

Akshay.

> Hi,
>
[quoted text clipped - 10 lines]
> >
> > Akshay.
Kevin D. White - 19 Mar 2007 18:15 GMT
Look up subreports in the SSRS documentation. Subreports allows you to embed
one report inside another. That may be what you want. Watch out though -
subreporting is not very flexible and has lots of limitations. The two most
frustrating are scheduled execution becomes very complex to manage and there
is no simple way to pass variables up or down the chain.

If all you want to do is put more than one table/chart/matrix on the screen
at once you may be better off just creating multiple datasets and chart
objects inside the same report.

> Can we just use SQL Reports and create dashboards without using
> Sharepoint?
[quoted text clipped - 17 lines]
>> >
>> > Akshay.
Amarnath - 21 Mar 2007 13:49 GMT
Not to a Professional Dashboard, but yes a scale down version, you can create
Digital dashboard, without using sharepoint. Infact I have done this before
in one of my small projects.

Amarnath, MCTS

> Hi,
>
> can we create a Digital Dashboard using MS SQL Server 2005? Kindly guide.
>
> Akshay.
A. Robinson - 28 Mar 2007 01:16 GMT
Could you elaborate a little more on how you accomplished this?

> Not to a Professional Dashboard, but yes a scale down version, you can create
> Digital dashboard, without using sharepoint. Infact I have done this before
[quoted text clipped - 7 lines]
> >
> > Akshay.
Amarnath - 29 Mar 2007 07:26 GMT
What you need to do is to bring all the data of all the controls say Table,
chart, matrix etc.. with different dataset keeping one record of all
information in each datasets. so that it doesn't iterate for the records.
This way you can achieve Dashboard at one short.

Amarnath, MCTS

> Could you elaborate a little more on how you accomplished this?
>
[quoted text clipped - 9 lines]
> > >
> > > Akshay.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.