I need help to create a report that uses several lists that are part of a recurring meeting workspace. As you may know these lists include a column (InstanceID) that limits scope based on the occurance of the meeting. Can anyone help me understand how to build reports on these special types of lists? Is there a whitepaper / article that explains how to use them with RS Data Extension?
For example, if I am accessing the 4/12/2007 instance of a meeting, the Agenda list will display items that are relevant to this particular instance of the meeting. In sharepoint, while viewing the list, the user can go to Actions->All Meetings and view all items in the list, regardless of the instance of the meeting presently in scope. In ASPX terms, this calls the AllItems.aspx view passing the parameter "?InstanceID=ALL".
When I create a report using the Enesys RS Data Extension and provide the Agenda list as a data source, the data retrieved are automatically filtered for the "current" (I am a bit confused as to what current is...?) instance of the recurring meeting.