Solved

Sharepoint 2010- two calendars, one printed list

Posted on 2012-03-31
4
479 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
  • 2
  • 2
4 Comments
 
LVL 50

Expert Comment

by:teylyn
Comment Utility
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
Comment Utility
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
Comment Utility
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:
teylyn earned 500 total points
Comment Utility
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

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

Note:  There are two main ways to deploy InfoPath forms:  Server-side and directly through the SharePoint site.  Deploying a server-side InfoPath form means the form is approved by the Administrator, thus allowing greater functionality in the form. …
This article provides the solution to a question (http://www.experts-exchange.com/Software/Photos_Graphics/Images_and_Photos/Q_28674207.html) posed here at Experts Exchange. The asker of the question has many JPG images in many folders, and all of t…
In this fifth video of the Xpdf series, we discuss and demonstrate the PDFdetach utility, which is able to list and, more importantly, extract attachments that are embedded in PDF files. It does this via a command line interface, making it suitable …
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…

743 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

Need Help in Real-Time?

Connect with top rated Experts

13 Experts available now in Live!

Get 1:1 Help Now