Dataset

I need to show (not to edit - just show and print) in a calendar view the sum of a couple XML recordset.

Your idea sounds similar to the one I've been implementing.

My approach was to construct a filter of event records that are keyed to each "participant".  The events of interest per participant are then easy to isolate.

I built an "appointment" table which contains the participant information in records which is then keyed to the calendarEvent eventID. It's a similar approach to how the recurring events are handled.

This seemed to be the most appropriate method to me since I am working with an SQL database engine where I could add my custom tables without much trouble.

I believe you could also try using the "CustomPropertiesXMLData" field as well without adding a table if you didn't have too many other columns to add. If you had a lot of different "participants" it would slow things down considerably as you would have to parse that field every time you wanted to filter the records.

Where I've been having trouble is exactly how to get only the filtered events displayed in the calendar. The system seems to want to reload all the records each time I change a participant filter which I am trying to avoid.  I tried finding a "collection" of the events for the calendar so I could perhaps isolate the records that way and selectively remove the ones that were filtered out from the display. I haven't found anything like that yet though and received no responses to my inquiry on this message board. My hunch is that there isn't one which could make this problematic. The lack of a collection does sort of make sense as you would only load the records that were "in demand" and not have them all in memory all the time. I'll probably end up making my own array of eventID's as the records are loading and work from that.

One other thing you could try is modifying the "multi-schedule" system. It does selective events, but what seems to me in a very inefficient manner.. by setting up different entire databases for each participant or group. For that reason (and the absence of SQL support) I didn't find it of any use.

I hope this gives you some ideas and you can work something out. I'd be interested in hearing your solution.

Gents,

For me it looks like a native solution for this problem in Calendar control is to use Schedules collection.

Isn't it ease to use? You need just a few typical operations:
1) Set an Id for an event:
NewEvent.ScheduleID = CalendarControl.DataProvider.Schedules(0).Id

2) Setup your view to show only events with particular schedules:
    ...
    Dim pRes As New CalendarResource
    ...
    pRes.ScheduleIDs.Add YourID1 ' and all which you'd like
    ...

Call Populate and that's it! For a future you will only need to modify pRes.ScheduleIDs collection when needed to hide/show some another appointments bunch.

--
WBR,
Serge

Hmmm.... This sounds pretty wise. Why we haven't implemented that from the beginning?  Will try to recall...

--
WBR,
Serge