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.
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.