When you are the sharepoint admin, forms developer, site admin, andgeneral guru for your organization, they tend to expect LOTS of effort. And whenyour organization is a state agency that's had its budget cut 10% every year forthe past 3 years and they are talking about even MORE cuts, you make do withwhat you have and expect a LOT from the folks you do have. Such is the life of a"public servant"!! At this point, I'm grateful to have a job that isn't with anagency that is now taking mandatory unpaid "furloughs" because of the economy!

Not sure if this will help or not but it's worth a look. It's an article onrolling up two lists in different site collections. Note that I have not triedthis as yet.........too much other stuff going on.

If you can get your org to go for it there are a number of third parties thatprovide the functionality you are looking for.

Well what we're talking about is essentially coding a calendar UI inXSL. A quick web search should give you several examples of how to dothat portion in a generic sense. Once you have that figured out, youneed to apply this to the XSL for either a Content Query or Data Viewweb part in such a way that the list data gets filtered for the currentcalendar view scope and the individual items appear in the correcthour/day/month/etc.

If I had a few days of free time I could probably work up an example,but I have paying projects to finish

If you're really forced to build it yourself, you can search for "sharepointcalendar rollup content query" to get some tutorials on modifying theContent query Web Part... though personally, I'd rather write a new WP inVisual Studio at that point.

We are the same in higher ed. We have plans when things start to get better tohire two more FTE(s) but for now my job is as SharePoint ADMIN and developer. Isuspect this is true of many companies today. My hope is to learn all I can,survive. Don't even get me started on wages...

If you have to be stuck in a situation like this, it might as well be withSharePoint; you're gaining real-world experience in one of the hottestup-and-coming areas in software right now (which makes you valuable andinteresting to a whole lot of people).

It's not just higher ed Buck. I'm in the same boat, different industry. I havegotten to the point that when I am asked my job title or what I do I tell them Iam the "SharePoint single point of failure".

This is becoming a common them, wearing of many hats. i was originally hired tobe the SharePoint Admin. Now i'm doing the Admin portion, plus development, andjust added was updating our VB6 applications. I know nothing about VB6, so thisis going to be interesting.

Its long time but for other's use. We just implemented Bamboo Roll-up list. Its doesn't give the Calendar look and feel but its OK.We had requirement to show current month events and next month events. So wrote the following CAML queries:------------<Where><And><Geq><FieldRef Name="EventDate" /><Value Type="DateTime" IncludeTimeValue="false"><Today OffsetDays="-15" /></Value></Geq><Leq><FieldRef Name="EventDate" /><Value Type="DateTime" IncludeTimeValue="false"><Today OffsetDays="15" /></Value></Leq></And></Where>------------<Where><And><Geq><FieldRef Name="EventDate" /><Value Type="DateTime" IncludeTimeValue="false"><Today OffsetDays="16" /></Value></Geq><Leq><FieldRef Name="EventDate" /><Value Type="DateTime" IncludeTimeValue="false"><Today OffsetDays="36" /></Value></Leq></And></Where>

Go4Sharepoint, is a Microsoft Featured Community.
Microsoft, Windows, Sharepoint, Sharepoint logo, Windows logo, etc are trademarks of the Microsoft Corporation.
All product names, logos, copyrights, and trademarks mentioned are acknowledged as the registered intellectual property of their respective owners. This site is not in any way affiliated with, nor has it been authorized, sponsored, or otherwise approved by, Microsoft Corporation.