You can use the Content Query Web part to rollup calendar items (see below)...

http://www.microsoft.com/belux/msdn/nl/community/columns/stevenvandecraen/contentquerywebpart.mspx

http://msdn2.microsoft.com/en-us/library/ms497457.aspx

http://msdn2.microsoft.com/en-us/library/aa981241.aspx

BUT...

I need help putting all of this information together so that I can format
the result of the list so that it makes sense for calendar items (i.e. Title,
Description, Start, End, Location). I have not found an example of anyone
that has done this.

I would like to group by Date, then display start time, title, description
location...

February 19, 2007

Meeting One Title
This is the description of the first meeting of the night.
7:00 PM at 123 Location Street

Meeting Two Title
This is the description of the second meeting of the night.
9:00 PM at 456 Location Street

February 20, 2007

Meeting Three Title
This is the description of the first meeting of the night.
8:00 PM at 789 Location Street

Anyone have thoughts?

I have the same need - for a global calendar with events from sub-sites. I
created a new site column "roll-up" with a Yes/No to mark events that will be
rolled-up to the 'global' calendar.

But I am stuck there. There are articles on CQWP but I need more specifics
such as how to add the start date to the CQWP list - it only shows the 'Title'

regards

I have a similar issue, but I am using WSS 3.0.  I want each sub-site to
have its own calendar, but then allow a view of all sub-site calendar events
on the "global" calendar as well.  So while the solution using Sharepoint
2007 sounds great, what are the options for WSS3.0?

Thanks in advance.

Mike
michael.mcnett@usma.edu

(Let's start by cutting this long list of newsgroups down - .teamservices
for one is nonsensical as that is for the back back 2001 product SharePoint
Team Services) Follow-ups set to .setup_and_administration only.)

CorasWorks used to have cross-site list consolidation in their suite of
programs for WSS 2.0 (and SPS 2003) and I presume this is still available in
their present suite for the v3 SharePoint products. The suite of course
costs quite a bit but it's less than MOSS 2007.

Mike Walsh
WSS FAQ http://www.wssfaq.com
No private e-mail please.

Here's a link to an article that will tell you how to do this.  It's a
typically convoluted SharePoint solution but it works.  We've used
this technique with calendars and task lists.  It seems everyone wants
to roll these things up - I'm surprised Microsoft hasn't come up with
an easier way to do it.

http://www.heathersolomon.com/blog/articles/CustomItemStyle.aspx

Hi,

We have a solution for that - KWizCom Calendar web part - Calendar Plus
it can do what you need -




Support both MOSS 2007/WSS 3.0 and SPS 2003/WSS 2.0
Support resizing the calendar to fit your web page's design
Aggregate events from multiple SharePoint sites
Connect to any required list type (not only "Events")
Support viewing data from the user's Outlook calendar
Support viewing Microsoft Outlook shared calendars
Aggregate data from any legacy application
Event coloring according to event source
Event coloring according to event type
Support list views - enabling you to aggregate list items defined by custom
SharePoint list views
Printable calendar
Support dynamic URL tokens � tokens such as [current site] enable you to use
the CalendarPlus web part in a site template using relative URL, eliminating
the need to configure the web part after a site is created
No client installation needed � fast & easy deployment
Dynamic generated background colors for aggregated list levels
Asynchronous calendar loading
Support different user credentials for SharePoint and Exchange server
Multi-lingual

Product page -
http://www.kwizcom.com/ProductPage.asp?ProductID=175&ProductSubNodeID=176


thanks

Uri


--
Uri Nissani
KWizCom Corp
http://www.kwizcom.com