?
Solved

Sharepoint 2010- two calendars, one printed list

Posted on 2012-03-31
4
Medium Priority
?
487 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

Veeam Task Manager for Hyper-V

Task Manager for Hyper-V provides critical information that allows you to monitor Hyper-V performance by displaying real-time views of CPU and memory at the individual VM-level, so you can quickly identify which VMs are using host resources.

Question has a verified solution.

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

Assume you have an outside contractor who comes in seasonally or once a week to do some work in your office, but you only want to give him access to the programs and files he needs and keep all other documents and programs private. Can you do this o…
When using a search centre, I'm going to show you how to configure Sharepoint's search to only return results from the current site collection. Very useful when using Office 365 with multiple site collections.
In this first video of the three-part Xpdf series, we introduce and describe Xpdf, a library containing nine command line utilities that perform various functions on PDF files. We show where the library is located and how to download it, discuss its…
In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

765 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