• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 493
  • Last Modified:

Sharepoint 2010- two calendars, one printed list

I need to create a datasheet type view in SharePoint 2010 that combines two separate calendars. Is this possible? The two calendars need to remain separate in SharePoint, but the VP needs to be able to export from one one place so he can (quarterly) print just a list of Calendar item titles and start/end dates covering both calendars.
0
K_Deutsch
Asked:
K_Deutsch
  • 2
  • 2
1 Solution
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Hello,

you could use SharePoint Designer to create a data source that merges the two lists (calendars are just lists), then create a LVWP or a DVWP based on that data source.

Taking this a step further, you can use query parameters to narrow down the date range of the items displayed in the DVWP.

cheers, teylyn
0
 
K_DeutschAuthor Commented:
I've not abandoned this question, but it may take me some time to get up to speed on how to do what you have described.
0
 
K_DeutschAuthor Commented:
Can you describe the first few moves I need to make within SP Designer to get me on the path of the data source merge you mentioned? I can figure it out further from there.

And the query SP thing will be new to me, but I defintitely want in on it. Can you point me to a resource?

Then I will award points.
0
 
Ingeborg Hawighorst (Microsoft MVP / EE MVE)Microsoft MVP ExcelCommented:
Sure.

Let's say the two calendars are called "Red Calendar" and "Green Calendar".
Open the site with SharePoint Designer
In the Navigation panel, click Data Sources
In the Ribbon click Linked Data Source
On the Source tab of the dialog, click "Configure Linked Source"
In the next dialog, select the red and the green calendars and click the Add button
Click Next

screenshot

Select the "Merge" option and click Finish

screenshot
On the General tab, provide a name, for example "MergedCalendars"
This new data source will now be listed in under "Linked Sources".

To use the data source, edit one of the site pages in SharePoint Designer.
On the Insert Ribbon, click the Data View drop down. Scroll down past the lists and libraries to the LinkedSources section, where you will find your newly created data source. Select it to use it as the source for the Data View Web Part.

From then on, it's just like any other DVWP. Sort by "Start Time" and set a filter to show only events with a start time greater than or equal to the current date.
screenshot
cheers, teylyn
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now