Tuesday, February 14, 2012

Creating Dashboard using SQL Server 2005

Hi,
can we create a Digital Dashboard using MS SQL Server 2005? Kindly guide.
Akshay.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
"iweb" wrote:
> Hi,
> can we create a Digital Dashboard using MS SQL Server 2005? Kindly guide.
> Akshay.|||Can we just use SQL Reports and create dashboards without using Sharepoint?
Akshay.
"Kathy" wrote:
> 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
> "iweb" wrote:
> > Hi,
> >
> > can we create a Digital Dashboard using MS SQL Server 2005? Kindly guide.
> >
> > Akshay.|||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.
"iweb" <iweb@.discussions.microsoft.com> wrote in message
news:4529B1C9-3881-44E2-B41A-46454B8D13D4@.microsoft.com...
> Can we just use SQL Reports and create dashboards without using
> Sharepoint?
> Akshay.
> "Kathy" wrote:
>> 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
>> "iweb" wrote:
>> > Hi,
>> >
>> > can we create a Digital Dashboard using MS SQL Server 2005? Kindly
>> > guide.
>> >
>> > Akshay.|||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
"iweb" wrote:
> Hi,
> can we create a Digital Dashboard using MS SQL Server 2005? Kindly guide.
> Akshay.|||Could you elaborate a little more on how you accomplished this?
"Amarnath" wrote:
> 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
>
> "iweb" wrote:
> > Hi,
> >
> > can we create a Digital Dashboard using MS SQL Server 2005? Kindly guide.
> >
> > Akshay.|||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
"A. Robinson" wrote:
> Could you elaborate a little more on how you accomplished this?
> "Amarnath" wrote:
> > 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
> >
> >
> > "iweb" wrote:
> >
> > > Hi,
> > >
> > > can we create a Digital Dashboard using MS SQL Server 2005? Kindly guide.
> > >
> > > Akshay.

No comments:

Post a Comment