Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

Sharepoint 2010- two calendars, one printed list

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

Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

Question has a verified solution.

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

PaperPort is a popular document imaging/management product from Nuance Communications (http://www.nuance.com/). It is in widespread use by both individuals (http://www.nuance.com/for-individuals/by-product/paperport/index.htm) and businesses (http:/…
These days socially coordinated efforts have turned into a critical requirement for enterprises.
This video is the second in a two-part series that discusses PaperPort's "Send To Bar" feature . The first video tutorial (http://www.experts-exchange.com/VP_207.html) explains the purpose of the Send To Bar, how to use it, and how to hide unwanted …
In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
Suggested Courses

571 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