Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Sharepoint 2010- two calendars, one printed list

Posted on 2012-03-31
4
Medium Priority
?
488 Views
Last Modified: 2012-04-11
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
Comment
Question by:K_Deutsch
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 50
ID: 37792230
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
 

Author Comment

by:K_Deutsch
ID: 37799347
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
 

Author Comment

by:K_Deutsch
ID: 37829269
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
 
LVL 50

Accepted Solution

by:
Ingeborg Hawighorst (Microsoft MVP / EE MVE) earned 2000 total points
ID: 37830219
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

Featured Post

Fill in the form and get your FREE NFR key NOW!

Veeam® is happy to provide a FREE NFR server license to certified engineers, trainers, and bloggers.  It allows for the non‑production use of Veeam Agent for Microsoft Windows. This license is valid for five workstations and two servers.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

PaperPort (http://www.nuance.com/for-individuals/by-product/paperport/index.htm) is among the most important applications that I run on my Windows computers. I use it every day, for nearly all of my document and photo scanning, as well as most of my…
A while back, I ran into a situation where I was trying to use the calculated columns feature in SharePoint 2013 to do some simple math using values in two lists. Between certain data types not being accessible, and also with trying to make a one to…
In this video, we show how to perform Bates Numbering/Stamping of PDF documents using Power PDF Advanced, the newest product from the Document Imaging division of Nuance Communications. There are two editions of Power PDF — Standard and Advanced. Th…
In a recent question (https://www.experts-exchange.com/questions/28997919/Pagination-in-Adobe-Acrobat.html) here at Experts Exchange, a member asked how to add page numbers to a PDF file using Adobe Acrobat XI Pro. This short video Micro Tutorial sh…

610 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question