Re: Best way to handle this Business Problem

Tech-Archive recommends: Fix windows errors by optimizing your registry

On May 22, 2:20 am, Rich <rkrue...@xxxxxxxxx> wrote:
Hi --

Before I get into the problem; I'd like to say that this client has
not decided on WSS 3.0 or MOSS ... and the figuring the optimal SP
solution for this business problem will definitely influence their
choice.

This client loves excel spreadsheets ... They take on these large
scale contracts that they call "Programs". Well, a given "Program"
encompasses many "Physical Locations", and at a Location the can have
many Widgets. Many of these columns hold dates, boolean values, and
notes.

Well, they like to track all their widgets per site ... and the Type
Of Program will dictate the excel template per each Location in that
Program (each program type having its own set of columns). All cut and
dried so far ... The problem is aggregation of all this information
from all these disparate spreadsheets into a single "data
structure?" ... I say data structure because I don't want to pin down
the solution to a SPList ... Here are some answers that the
aggregation needs to be good enough to show ... How many Locations
have date X < today? What are those Locations? (and other questions
like this ... but I think you get the point).

Does anybody have any idea?

Thanks,
Rich

If you go with MOSS, the content query web part might get the job
done.

Alternatively, some custom programming could be written to provide a
facade against which SSRS reports could be run.

Again with MOSS, excel services might also work well.

This newsgroup is really focused on WSS specific questions. You
should probably post this to a more general themed group.

--Paul Galvin, Conchango
RSS @ http://feeds.feedburner.com/PaulGalvinsSharepointSpace
Web site @ http://paulgalvin.spaces.live.com
Twitter @ http://twitter.com/pagalvin (I follow anyone who follows
me)
.

Quantcast