MOSS Forum

Ask Question   UnAnswered
Home » Forum » MOSS       RSS Feeds

WSS and Reporting services

  Asked By: Eleanor    Date: Mar 06    Category: MOSS    Views: 1082

This might be a stretch. I have a client on WSS3.0 that wants some basic
dashboard functionality. Things like bar graphs with the YTD Gross vs net by

I am thinking about just creating a custom list to put the data into (now it is
in an excel doc) and using SQL reports to create the graphs.

First, has anyone done this before? Next, I know this is better for MOSS then
WSS, but is there a way to get the data from an Excel doc in a document library
in WSS and use that to create some bar and donut graphs?

Does anyone have any suggestions for doing a Dashboard like this in WSS?



12 Answers Found

Answer #1    Answered By: Santana Osborn     Answered On: Mar 06

Firstly, you should check out the 'Import a spreadsheet' functionality  for
creating custom  lists. That will get your Excel into a custom list  nicely.

Next, look into the Google Charts APIs. They make it pretty easy to create  some
fantastic charts from your data.

Answer #2    Answered By: David Brown     Answered On: Mar 06

Some good articles on using google chart on wss  -

Answer #3    Answered By: Daamodar Bhadranavar     Answered On: Mar 06

The instructor I had for a recent SharePoint class said he often recommended to
his customers that they avoid MOSS and just use WSS, unless there was a specific
need that MOSS solved for them. I am finding out more and more that is exactly
the case.

Answer #4    Answered By: Destiny Lewis     Answered On: Mar 06

Can't say as I agree at all. WSS has no cross site search or publishing
functions. Those alone are reasons for MOSS.

Answer #5    Answered By: Tanisha Rowe     Answered On: Mar 06

I have put  WSS Site collections under the parent to allow for being able to
search. It is not great, but it does work.

Answer #6    Answered By: Sierra Lewis     Answered On: Mar 06

Could you explain what you mean by that? Site collections don't exist in a
hierarchy. They are independent of each other. Although Managed Path URLs make
it look like a site collection is in a hierarchy there is no Parent Child
relationship between a site collection in the root and a site collection in a
managed path. So I don't understand what you mean when you say that you
“put WSS site collections under the parent.

Answer #7    Answered By: Dwight Becker     Answered On: Mar 06

Clearly a case-by-case basis, but neither of those would be useful (at this
point in time) at FDOT.

Answer #8    Answered By: Amar Kumbar     Answered On: Mar 06

This is true with any product. Fit the product to the client, not the client  to
the product.
Don't sell the client a Ferrari if they need a Yugo.

BTW, MS has a spreadsheet that compare the features of WSS, Standard and

Answer #9    Answered By: Marc Dixon     Answered On: Mar 06

Although I agree that clients should always start their planning with WSS and
only move to MOSS when they needed it, 95% of all my clients find very quickly
that they need some feature in MOSS. For example:

1. If you have more than one site collection you need MOSS to be able to
search the entire Farm.

2. If you want to aggregate content from multiple sites, lists or
libraries you need either SharePoint Designer or the Content Query web part
(which is only in MOSS).

3. If you want to use user profiles and Mysites you need MOSS.

4. If you want to use publishing to have users create  content pages
without understanding HTML you need MOSS

5. Etc.

WSS is a nice foundation, and its FREE. But most installations outgrow it very
quickly. So the instructor was right, but almost everyone has a specific need
that Moss solves.

Answer #10    Answered By: Johathan Mcgowan     Answered On: Mar 06

The .NET 4.0 chart control is pretty impressive as well.

Answer #11    Answered By: Georgia Barr     Answered On: Mar 06

No experience here but watch the WSS pitfall.
Spending more time, money and energy getting something to work when upgrading to
SharePoint standard could have done it out of the box.

Answer #12    Answered By: Jessi Sweet     Answered On: Mar 06

I wish I had control over this, but my client  is in charge.

Didn't find what you were looking for? Find more on WSS and Reporting services Or get search suggestion and latest updates.

Related Topics:



Related Post